Solved

A Question regarding Oracle OPatch Tool (Further Clarification need)

Posted on 2012-03-16
2
693 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:uompradeep
2 Comments
 
LVL 47

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

770 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