?
Solved

A Question regarding Oracle OPatch Tool (Further Clarification need)

Posted on 2012-03-16
2
Medium Priority
?
721 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 1500 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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…
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…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

719 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