Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: Apply Oracle Database Patch using opatch and opatch options

  1. #1
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    5

    Apply Oracle Database Patch using opatch and opatch options

    Whenever we encounter ORACLE bugs or INTERNAL ERRORS(eg:ORA-600,ORA-7445) we need to apply certain piece of code (provided by oracle support) to
    the binaries of ORACLE.This piece of code is known as PATCH and the process of applying patch is known as PATCHING

    When we apply the patch to Oracle software installation, it updates the executable files, libraries, and object files in the ORACLE home directory.

    Patches are applied by using OPatch, a utility supplied by Oracle.

    To download Patch :-
    We obtain patches from My Oracle Support, which is the Oracle Support Services Web site

    To check the Opatch version
    :-

    [oracle@localhost OPatch]$ opatch version

    Invoking OPatch 10.2.0.1.0

    OPatch Version: 10.2.0.1.0

    OPatch succeeded.

    APPLYING PATCH:-

    1) MUST read the Readme.txt file included in opatch file, look for any prereq. steps/ post installation steps or and DB related changes.
    Also, make sure that you have the correct opatch version required by this patch.

    2) Check the ORACLE_HOME Environment Variable

    3)Update the path environment variable =
    oracle@localhost OPatch]$ export PATH=$PATH:$ORACLE_HOME/OPatch

    4)Make sure you have a good backup of database.

    5)Make a note of all Invalid objects in the database prior to the patch.

    6)Shutdown All the Oracle Processes running from that Oracle Home,including the Listener and Database instance.

    7) MUST Backup your oracle Home and Inventory

    tar cvf - $ORACLE_HOME $ORACLE_HOME/oraInventory | gzip > Backup_oracle.tar.gz

    8) Unzip the patch in $ORACLE_HOME/OPatch

    9) cd to the patch directory and do opatch -apply to apply the patch.
    $ORACLE_HOME/OPatch/opatch apply

    We can get all the options using opatch -help

    Usage: opatch [ -help ] [ -r[eport] ] [ command ]

    command := apply
    lsinventory
    prereq
    query
    rollback
    util
    version

    To Uninstall the Patch :-
    [oracle@localhost OPatch]$ opatch rollback -id<patch id number>

    For complete details of the opatch options and impact , refer to this link : opatch-options
    Last edited by Hemant; 11-02-2011 at 02:24 PM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Very helpful post for database patch application

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    really helpful and summarized.
    Regards,
    -Amit

  4. #4
    Thanks for summarized the Opatch...................

+ Reply to Thread

Similar Threads

  1. OPATCH ERROR on ORACLE_HOME of APPS TIER
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 06-18-2012, 01:45 AM
  2. Error in Starting the Apache after CU2 patch apply
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 4
    Last Post: 01-20-2012, 04:17 PM
  3. Strategies to Apply Patch to RAC Instances
    By Hemant in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-29-2011, 08:27 PM
  4. Distributed AD to apply a patch
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-12-2011, 11:51 AM
  5. Opatch Options
    By Hemant in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 11-02-2011, 02:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics