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

Thread: Opatch Options

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Opatch Options

    Patching Procedure to apply a patch using opatch has been covered in :
    Applying database patch using opatch

    The most commonly-used commands running OPatch are:

    1. opatch apply ...
    This command applies a patch from the patch directory. The OUI inventory is updated with the patch's information.

    2. opatch rollback ....
    This is the command to rollback or undo a patch installation. The respective patch information is removed from the inventory.

    3. opatch lsinventory
    lsinventory lists all the patches installed on the Oracle Home.

    4. opatch lsinventory -detail
    lsinventory -detail gives list of patches and products installed in the ORACLE_HOME.

    5. opatch version
    version option displays the version of OPatch installed.

    6. opatch napply
    napply applies the patches in a directory. This is used while applying a patch that is a bundle of individual patches. napply eliminates the overhead of running opatch multiple times by the administrator. The napply option skips subsets or duplicates if they are already installed.

    7. opatch nrollback
    nrollback rolls back the patches using the IDs specified.

    8. opatch apply -minimize_downtime
    This is specific to Real Application Clusters (RAC) enabled instances (DB tier patches). The -minimize_downtime option allows you to apply a patch by bringing down one database server instance at a time. OPatch applies the patch to the quiesced server instance, the instance is brought back up, and then OPatch moves on to the next database server in a Real Application Clusters pool.

    9. opatch apply -force
    -force overrides conflicts with an existing patch by removing the conflicting patch from the system.

    Caution: This option should be only used when explicitly it is said safe to be used in the README of the patch.

    10. opatch apply -invPtrLoc <...>
    The option -invPtrLoc can be used to specify the oraInst.loc file in case it's not in the default location e.g., /etc/oraInst.loc in Linux. The argument to this option is the location of this file.

    11. opatch query
    The query command can be used to find out useful information about the patch

    Syntax to be used:


    opatch query [-all] [-jre <LOC> ] [-oh <LOC> ] \ [-get_component] [-get_os] [-get_date] [-get_base_bug] \[-is_rolling_patch] [-is_online_patch] \ [-has_sql] [ <Patch Location> ]

    all
    Retrieves all information about a patch. This is equivalent to setting all available options.

    get_base_bug
    Retrieves bugs fixed by the patch.

    get_component
    Retrieves components the patch affects.

    get_date
    Retrieves the patch creation date and time.

    is_online_patch
    Indicates true if the patch is an online patch. Otherwise, the option is false.

    is_rolling_patch
    Indicates true if the patch is a rolling patch. Otherwise, the option is false.

    oh
    Specifies the Oracle home directory to use instead of the default directory. This takes precedence over the ORACLE_HOME environment variable.

    Patch Location
    Indicates the path to the patch location. If you do not specify the location, OPatch assumes the current directory is the patch location.

+ 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. Profile options for concurrent manager(cm)
    By mdmasood in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 02-03-2012, 04:37 PM
  3. Apply Oracle Database Patch using opatch and opatch options
    By sneha in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 3
    Last Post: 11-23-2011, 10:34 AM
  4. Retrieve Profile Options Where Trace is Enabled
    By Hemant in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 11:04 AM
  5. adpatch options
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 10-30-2011, 12:52 AM

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