Solved

A Question regarding Oracle OPatch Tool (Further Clarification need)

Posted on 2012-03-16
2
710 Views
Last Modified: 2012-03-17
Dear Sir (Experts),

I have another set of questions in my mind about Oracle OPatch Tool.

(1). In Oracle, What are the interim patches?

(2). Apart from interim patches, are there other types of patches?

(3). When I apply patches to Oracle Database, Should I apply all Oracle released Patches one by one relevant to my oracle version? As an example, If Oracle has released 4 patches ( Lets take patch names as A,B,C and D - Here A is oldest patch and D is newest ) to My oracle version,

(3.1). can I apply only newest patch without any dependencies of previous patches?

(3.2). or to apply newest patch, should I apply all old patches definitely?

(4). For further clarification please tell me..Can I use default OPatch tool of my Oracle 10.2 database (Here default means, The OPatch tool installed with my Oracle 10.2 installation) to apply all Oracle released patches relevant to my Oracle version? or should I upgrade my OPatch tool version time to time to apply different patches to same oracle version?

Thank You in advance.
Pradeep.
0
Comment
Question by:Pradeep Siriwardana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 500 total points
ID: 37729935
Interim patches are small sets of corrections. They are intended to fix an important error.

Upgrades are collections of such patches, but the are published rarely - once at year or two. They comprise all interim patches and are cumulative.

Most of the intereim patches are cumulative - they comprise old patches.

Every patch explains in the README.html file what version of Orapatch it will use.

To see the current Opatch version:

# opatch lsinventory

Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..


To upgrade the Opatch version:

01. Download, transfer, install latest opatch utility.

     ####  Current state:  ######
   
    # opatch lsinventory

     Invoking OPatch 10.2.0.3.0


     ####    Solution:     ######

     OPatch 10.2.0.5.1:        Download the new Orapatch version in some directory:   /fac_sw/oracle/product/patches/p6880880_102000_AIX.zip

           
     Backup the current OPatch;

          cd /fac_sw/oracle/product/10.2.0.3.0.b.002/db

          mv OPatch OPatch.old

     Transfer the new version:

          cd    /fac_sw/oracle/product/10.2.0.3.0.b.002/db

          cp    /fac_sw/oracle/product/patches/p6880880_102000_AIX.zip  .

          unzip p6880880_102000_AIX.zip

          opatch version

                 Invoking OPatch 10.2.0.5.1

                 OPatch Version: 10.2.0.5.1

                 OPatch succeeded.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37729981
To add to the above:

Some patches do not use OPatch.  The readme for the patch will tell you how to install that particular patch.

Also note that some interim patches, normally called one-off patches, are not cumulative.  They might have come out to late to be included in a larger patchset.  The readme for the patch will also tell you this information.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question