Oracle | OPatch

Oracle OPatch Version 19c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose OPatch is Oracle's patching utility for database, ASM, and Clusterware.

APPLY

Applies an interim patch to an ORACLE_HOME from the current directory. The patch location can specified using the parameter patch_location.

This command does not support System Patch. SYNTAX
opatch apply [-connectString <List of connect strings>] [-delay <value> ] [ -force ] [ -force_conflict ] [-init <parameters for the init script in escaped double quotes> [-opatch_init_end] ] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-local ] [-local_node <Local node name>] [-minimize_downtime ] [-no_bug_superset ] [-no_inventory ] [-no_relink] [-no_sysmod] [-ocmrf <Response file location> ] [-oh <ORACLE_HOME> ] [-post <parameters for the post script in escaped quotes> [-opatch_post_end] ] [-pre <parameters for the pre script in escaped double quotes> [-opatch_pre_end] ] [-profile_mask <Name of profile>] [-property_file <Path to property file>] [-ptlConnect <portal connect string>] [-ptlPassword <portal password>] [-ptlSchema <portal schema>] [-remote_nodes <List of remote nodes (node1,node2)>] [-retry <value ] [-runSql ] [silent ] [-sqlScript <path of the sql file>] [-verbose ] [ <Patch Location> ]

OPTIONS
-all_nodes
Apply the patch using all-node mode.

-connectString
This option can be used to specify the list of database instances on which the patch needs to be applied. The value for this option is specified as per the following syntax "SID:User:Passwd:Node". The SID is a must, others can be ignored, OPatch takes default values for it.
Ex: oracle:dba:dba:mymachine,oracle1:::
NOTE: If the system is not part of RAC setup, then to patch just the local node, provide the node name as empty string.

-delay
If -retry is specified, this options tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-force
This option is meaningful with 'silent' option and is used to override the behavior of silent under specific circumstances.

-force_conflict
If a conflict exist which prevents the patch from being applied, the -force_conflict flag can be used to apply the patch. OPatch will remove all the conflicting patches before applying the current patch. This will override the 'silent' behavior for conflicts and hence is meaningful only when used with 'silent' option.

-init
This option is used to pass parameters to the init script. This script is executed before prerequisite checks are run. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_init_end'.

-invPtrLoc
Used to locate the oraInst.loc file. Needed when the installation used the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
Patch the local node, then update inventory of the local node. Do not propagate the patch or inventory update to other nodes.

-local_node
This option can be used to specify to OPatch the local node name to be used for RAC mode application of the patch.

-minimize_downtime
Only applied to RAC instances. User supplies the order of nodes to be patched. This option cannot be used in conjunction with -local option with a rolling patch.

-no_bug_superset
This option tells OPatch to error out if the current patch's bugs-to-fix is a super-set (or same set) of an installed patch's bugs-fixed in the Oracle Home.

-no_inventory
This option specifies not to update the inventory, it just updates the files in the system. If inventory is readable, then OPatch tries to read the inventory.

-no_relink
The nolink option does not perform any make operations. This option can be used during multiple patch applications and perform the linking step only once. OPatch does not keep track of the make operations it did not perform. It is the job of the OPatch users to make sure the execute OPatch without this option at the end, so that compilation happens once.

-no_sysmod
This option specifies not to update the files in the system. It just updates the inventory. It also will not execute the pre and post scripts.

-ocmrf
Give OPatch the absolute path to the OCM response file to be used for OCM configuration. -silent must be used in conjunction with -ocmrf if Oracle Home doesn't have OCM installed and configured.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-opatch_init_end
This option is used to mark the end of init options. Without this option everything after init till end of the command is passed into init. This option is meaningless without -init option.

-opatch_post_end
This option is used to mark the end of post options. Without this option everything after post till end of the command is passed into post. This option is meaningless without -post option.

-opatch_pre_end
This option is used to mark the end of pre options. Without this option everything after pre till end of the command is passed into pre. This option is meaningless without -pre option.

-post
This option is used to pass parameters to the post script. This script is executed after application of the patch. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_post_end'.

-pre
This option is used to pass parameters to the pre script. This script is executed before application of the patch. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_pre_end'.

-profile_mask
If the patch to be applied specifies WLS patch/patchset as prerequisites, OPatch will read the WLS default patch profile. To have OPatch read non-default patch profile, specify the patch profile name with this option.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-ptlConnect
This option can be used to specify the connect string of the portal schema.

-ptlPassword
This option can be used to specify the password of the portal schema.

-ptlSchema
This option can be used to specify the schema of the portal repository patch.

-remote_nodes
This option can be used to specify to OPatch the list of remote nodes to be used for RAC mode application of the patch. The node names are comma separated and without spaces.

-report
Just prints out the actions without executing.

-retry
This option tells OPatch how many times it should retry in case of an inventory lock failure.

-runSql
This option can be used to specify OPatch to run the sql scripts and sql procedures if they are present in the given patch.

-silent
This suppresses any user-interaction.

-sqlScript
This option can be used to specify the custom sql script to be run by OPatch after patching is completed.

-verbose
This option prints more OPatch output to the screen as well as to the log file

PARAMETERS
Patch Location
Path to the location for the patch. If the patch location is not specified, then the current directory is taken as the patch location.

TBD

CHECKAPPLICABLE

This operation checks if a given patch is applicable to one or more Oracle Homes.

For a Fusion Middleware installation, OPatch will look for Oracle Homes present under the Middleware home and registered with a single defined central inventory. If environment variable MW_HOME (or) 'mw_home' option is not defined and the ORACLE_HOME environment variable or 'oh' option is also not defined then OPatch will run the command on the applicable Middleware Home. If ORACLE_HOME environment variable is defined or the 'oh' option is given, OPatch will run the command on the referenced Oracle Home with precedence given to the 'oh' option.

Examples of patches not applicable are:
- Patches requiring components that are not installed in the Oracle Home (or) installed but not of the same version.
- Files mentioned by patch metadata could not be patched. SYNTAX
opatch checkApplicable -ph <Patch location> [-allhomes ] [-invPtrLoc <Path to oraInst.loc file> ] [-mw_home <Path of the middleware home> ] [-oh <Path of the reference oracle home> ]

OPTIONS
-allhomes
This option will overide all other options involved in the logic of getting the homes for test of 'checkApplicable'. This option ensures that the check is only applied to all registered homes in central inventory.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-mw_home
Path of the Middleware Home. This takes precedence over MW_HOME environment variable.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME. This also ensures that the command runs only on this Oracle Home.

-ph
The location of the patch to be checked if it is applicable.

PARAMETERS
The location of the patch to be queried

TBD

CHECKINSTALLEDONEOFFS

This operation checks if the given patch(es) are installed on a number of Fusion Middleware Oracle Homes.

For a Fusion Middleware installation, OPatch will look for Oracle Homes present under the Middleware home and registered with a single defined central inventory. If environment variable MW_HOME (or) 'mw_home' option is not defined and the ORACLE_HOME environment variable or 'oh' option is also not defined then OPatch will run the command on the applicable Middleware Home. If ORACLE_HOME environment variable is defined or the 'oh' option is given, OPatch will run the command on the referenced Oracle Home with precedence given to the 'oh' option.

If 'domain' option is given, the command will be invoked on Fusion Middleware Oracle homes associated with a domain. SYNTAX
opatch checkInstalledOneOffs -id <List of Patch IDs separated by commas> ] [-domain <Name of the domain> ] [-invPtrLoc <Path to oraInst.loc file> ] [-mw_home <Path of the middleware home> ] [-oh <Path of the reference oracle home> ]

OPTIONS
-id
A single Patch ID (or) comma separated list of Patch IDs.

-domain
Name of the domain.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-mw_home
Path of the Middleware Home. This takes precedence over MW_HOME environment variable.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME. This also ensures that the command runs only on this Oracle Home.

PARAMETERS
Patch IDs separated by commas

TBD

COMPARE

Allows for comparison between two files generated by the 'opatch lsinv -xml' command. Currently, the command only takes in two such files as input. SYNTAX
opatch compare [<file1> <file2>]

OPTIONS
-help
This will bring up this help text.

PARAMETERS
<file1> <file2>
These are the two files that will be compared.
Currently, only two file names will be accepted, and these files must have been generated by the 'opatch lsinv -xml' command.

TBD

DEPLOY

This operation deploys the following modified artifacts.

1. Life cycle operations for JEE.
2. SOA composite artifacts.

This operation assumes that the patch is already installed in the Oracle Home. So, 'id' option needs to be used to specify the patch for deployment.

Please refer the following instructions for life cycle & SOA composite deployment.

The -domain <DOMAIN_NAME> option has to be specified along with the -auto option for automated rollout to the Fusion Middleware domain.
If only a single domain has been created out of the Oracle Home you can omit specifying the domain name.
Only certain patches which have been certified by Oracle Product Support can be rolled out using this command.

OPatch will pose questions to query for information necessary for accessing the Fusion Middleware domain. They are Admin Server URL, Admin Server User, Admin Server Password, Node Manager User and Node Manager password. Node Manager User and Node Manager password are not needed for SOA composite deployment. SYNTAX
opatch deploy -id <ID of the patch installed in Oracle Home> [-domain <DOMAIN_NAME>] [-auto ] [-invPtrLoc <Patch to oraInst.loc file ] [-jre <JRE location> ] [-mw_home <Middlware Home> ] [-oh <Oracle Home Path> ] [-report ] [-silent ] [-property_file <Path to custom property file>]

OPTIONS
-domain
The name of the Fusion Middleware domain to which the artifacts affected by the patch will be redeployed.

-auto
This option is deprecated and is no-op for 'deploy'.

-id
A single Patch ID that is installed in the Oracle Home.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

For SOA deployment, the following keys are required with the necessary values.

'AdminConfigFile' - Encrypted file for Admin Server user.
'AdminKeyFile' - Encrypted file for Admin Server password.
'AdminServerURL' - Admin Server URL.

For encryption files, Please check 'storeUserConfig' WLST command for details.

For life cycle deployment, the following keys are required with the necessary values.

'AdminConfigFile' - Encrypted file for Admin Server user.
'AdminKeyFile' - Encrypted file for Admin Server password.
'AdminServerURL - Admin Server URL.
'NodeManagerConfigFile' - Encrypted file for Node Manager user.
'NodeManagerKeyFile' - Encrypted file for Node Manager password.

For encryption files, Please check 'storeUserConfig' WLST command for details.

The Key, value pair is of the format 'x=y' where 'x' is OPatch understood key and each pair is separated by newline in the property file. This option is typically used for silent operations.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-mw_home
The Middleware Home for the Fusion Middleware install. This takes precedence over the environment variable MW_HOME.

-oh
The Oracle Home of the Fusion Middleware product which is to be used for the deploy operations. This takes precedence over the environment variable ORACLE_HOME.

-report
Just prints out the actions without execution.

-silent
Invoke the operation in silent mode. Path to custom property file may be provided which will have required inputs as name-value pairs.

If required inputs are not found, OPatch willl error out with missing key values. Please check 'property_file' option for more details.

PARAMETERS
The 'id' option should be used and it mandates that patch be installed in the Oracle Home.

HELP

Display OPatch help opatch -help

C:\Users\oracle>opatch -h

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Usage: opatch [ -help ] [ -report ] [ command ]

      

                 command := apply

                            compare

                            lsinventory

                            lspatches

                            napply

                            nrollback

                            rollback

                            query

                            version

                            prereq

                            util

      

      <global_arguments> := -help Displays the help message for the command.

                            -report Print the actions without executing.

      

      example:

        'opatch -help'

        'opatch -help -fmw'

        'opatch apply -help'

        'opatch compare -help'

        'opatch lsinventory -help'

        'opatch lspatches -help'

        'opatch napply -help'

        'opatch nrollback -help'

        'opatch rollback -help'

      &nbp; 'opatch prereq -help'

        'opatch util -help'

      

      OPatch succeeded.

LISTCOMPOSITES

This command lists down all the SOA Composites that are deployed to a SOA Server. The option '-name' can be used to shortlist the composites of a specified name.

It operates through the Admin Server of the domain which needs to be accessible. In addition, the Node Manager is required to be configured and running on the machines which have the WebLogic Server instances installed and affected by this command. OPatch will query for information necessary for accessing the Fusion Middleware domain such as Admin Server URL, Admin Server User and Admin Server Password. SYNTAX
opatch listComposites [-invPtrLoc <Path to oraInst.loc file> ] [-oh <Reference Oracle Home path> ] [-name <Name of the composites to shortlist> ] [-silent ][-property_file <Path to custom property file> ]

OPTIONS
-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-oh
The Oracle Home to work on. This takes precedence over the environment variable ORACLE_HOME.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch For FMW components, 'AdminConfigFile', 'AdminKeyFile', location can be specified as keys with corresponding files as values. They refer to encrypted, decrypted files for Admin user and Admin password respectively.

For encryption files, Please check 'storeUserConfig' WLST command for details.

Similarly, Admin Server URL (key as 'AdminServerURL'), can be given as key with corresponding value. The Key, value pair is of the format 'x=y' where 'x' is OPatch understood key and each pair is separated by newline in the property file.

-name
The name of the composites to be shortlisted.

-silent
Invoke the operation in silent mode. Path to custom property file may be provided which will have required inputs as name-value pairs. If required inputs are not found, OPatch will exit with error message quoting the missing inputs.

PARAMETERS
There are no required parameters.

C:\app18\OPatch>opatch listcomposites

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_20-50-13PM_1.log

      

      Unable to lock Central Inventory. OPatch will attempt to re-lock.

      Do you want to proceed? [y|n]

      n

      User Responded with: N

      OPatchSession cannot load inventory for the given Oracle Home C:\app18. Possible causes are:

      No read or write permission to ORACLE_HOME/.patch_storage

      Central Inventory is locked by another OUI instance

      No read permission to Central Inventory

      The lock file exists in ORACLE_HOME/.patch_storage

      The Oracle Home does not exist in Central Inventory

      

      UtilSession failed: Unable to lock Central Inventory. Stop trying per user-request?

      

      OPatch failed with error code = 73

LSDOMAINS

This command produces a list of WebLogic domains that have been created from the application and library artifacts installed in the given Fusion Middleware product Oracle Home.

The Middleware Home can be specified by using the 'mw_home' command-line option or by specifying the MW_HOME environment variable (the command-line option has higher precedence). SYNTAX
opatch lsdomains [-invptrloc <Path to oraInst.loc> ] [-mw_home <Path of the Middleware home> ] [-oh <The Oracle Home within a Middleware Home> ]

OPTIONS
-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-mw_home
Path of the Middleware Home. This takes precedence over MW_HOME environment variable.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

PARAMETERS
There are no mandatory parameters defined for this command.

C:\Windows\system32>opatch lsdomains

      

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_20-53-30PM_1.log

      

      Unable to lock Central Inventory. OPatch will attempt to re-lock.

      Do you want to proceed? [y|n]

      n

      User Responded with: N

      OPatchSession cannot load inventory for the given Oracle Home C:\app18. Possible causes are:

      No read or write permission to ORACLE_HOME/.patch_storage

      Central Inventory is locked by another OUI instance

      No read permission to Central Inventory

      The lock file exists in ORACLE_HOME/.patch_storage

      The Oracle Home does not exist in Central Inventory

      

      UtilSession failed: Unable to lock Central Inventory. Stop trying per 
      user-request?

      

      OPatch failed with error code = 73

LSHOMES

This command lists all the Oracle Homes pertaining to logical entities such as Host or Domain. For a Host, the list of Oracle Homes is obtained from the machine's central inventory. For a WebLogic domain, the list of homes is limited to product Oracle Homes that are installed within a top-level Middleware Home. If the 'domain' or 'domaindir' option is used the command lists the Oracle Homes that have been used to create or extend the WebLogic domain. If the 'domain' or 'domaindir' option is not given, all the homes registered with the machine's central inventory or the inventory location specified using the 'invPtrLoc' are listed. The Middleware Home can be specified by using the 'mw_home' command-line option or by using MW_HOME environment variable. When the Middleware Home is specified and the 'domain' or 'domaindir' option is not specified this command will list all the Oracle Homes within the Middleware Home that are registered with the machine's central inventory or the specified inventory location. SYNTAX
opatch lshomes [-domain <Name of the domain> | -domaindir <Path to the WebLogic domain> ] [-invPtrLoc <Path to oraInst.loc> ] [-mw_home <Path of the Middleware home> ] [-oh <Reference Oracle Home> ]

OPTIONS
-domain
The name of the domain.

-domaindir
The path to the location of the Weblogic domain.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-mw_home
Path of the Middleware Home. This takes precedence over MW_HOME environment variable.

-oh
The reference Oracle Home to work on. This takes precedence over the environment variable ORACLE_HOME.

PARAMETERS
There are no mandatory parameters for this command.

C:\Windows\system32>opatch lshomes

      

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_20-58-42PM_1.log

      

      Unable to lock Central Inventory. OPatch will attempt to re-lock.

      Do you want to proceed? [y|n]

      n

      User Responded with: N

      OPatchSession cannot load inventory for the given Oracle Home C:\app18. Possible causes are:

      No read or write permission to ORACLE_HOME/.patch_storage

      Central Inventory is locked by another OUI instance

      No read permission to Central Inventory

      The lock file exists in ORACLE_HOME/.patch_storage

      The Oracle Home does not exist in Central Inventory

      

      UtilSession failed: Unable to lock Central Inventory. Stop trying per user-request?

      

      OPatch failed with error code = 73

LSINV

Crosscheck installed products and Oracle home directories. List the inventory for a particular $ORACLE_HOME or display all installations that can be found. SYNTAX
opatch lsinventory [-all ] [-all_nodes] [-bugs_fixed <asc | desc> ] [-delay <value> ] [-detail ] [-group_by_date ] [-inactive] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-local ] [-oh <ORACLE_HOME> ] [-patch <asc | desc> ] [-patch_id <asc | desc> ] [-ptlConnect <portal connect string> ] [-ptlPassword <portal password> ] [-ptlSchema <portal schema> ] [-property_file <path to property file>] [-retry <value> ] [-translation_patch ] [-xml <xmlFile>]

OPTIONS
-all
Report the name and installation directory for each $ORACLE_HOME found.

-all_nodes
Reports the patches installed on the given Oracle Home in all nodes of the RAC system. It also prints the oracle binary's size and checksum on all nodes. This option cannot be used in conjunction with -all, -detail, -patch.

-bugs_fixed
Reports bugs fixed by installed patches in a tabular format. Besides the bugs fixed, the report also displays the installed patches, installed times, and bug descriptions. The fixed bugs are sorted per installed patch. Default display is patches in descending order based on installed time and ascending order of bugs within each patch. You can use 'asc' (or) 'desc' with this option to enforce sort order on bugs within each patch.

You can use this option with the patch (or) patch_id option to obtain sort orders with installed patches.

-delay
If -retry is specified, this option tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-detail(s)
Report installed products and other details. This option cannot be used in conjunction with all option.

-group_by_date
This option tells OPatch to group all installed patches by the date they were installed in the Oracle Home.

-inactive
This option lists all the inactive patches that have been superseded by other superset patch(es) installed in the Oracle Home.

-invPtrLoc
Used to locate the oraInst.loc file. When the installation used the invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
This option tells OPatch to display inventory information of the local node only.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-patch
Lists the patch IDs installed in the Oracle home in ascending (asc) or descending (desc) order, which is the default, based on installed time.

-patch_id
Lists the patch IDs installed in the oracle home in ascending (asc) or descending (desc) order based on patch numbers. The value defaults to ascending (asc).

-ptlConnect
This option is used to specify the connect string credentials of the portal schema.

-ptlPassword
This option is used to specify the password of the portal schema.

-ptlSchema
This option is used to specify the schema of the portal repository.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-retry
This option tells OPatch how many times it should retry in case of an inventory lock failure.

-translation_patch
Report installed translation patch(es) in a tabular format.
The report displays translation patch, unique patch identifier, language code, installed time of the translation patch and base patch for any single row in the table.

-xml
This option must be followed with an xml filename, and it will generate xml output based on the current Oracle Home inventory into the filename.

PARAMETERS
This operation does not have any required parameters.

C:\Windows\system32>opatch lsinv

      

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_21-01-09PM_1.log

      

      Lsinventory Output file location : C:\app18\cfgtoollogs\opatch\lsinv\lsinventory2019-01-17_21-01-09PM.txt

      ----------------------------------------------------------------------

      Local Machine Information::

      Hostname: 10.0.0.96

      ARU platform id: 233

      ARU platform description:: Microsoft Windows (64-bit AMD)

      

      Installed Top-level Products (1):

      

      Oracle Database 18c 18.0.0.0.0

      There are 1 products installed in this Oracle Home.

      

      

      Interim patches (3) :

      

      Patch 28267731 : applied on Sat Aug 18 04:34:22 CDT 2018

      Unique Patch ID: 22301563

      Patch description: "WINDOWS OJVM BUNDLE PATCH : 18.3.0.0.180717 (28267731)"

      Created on 8 Jul 2018, 06:48:38 hrs PST8PDT

      Bugs fixed:

      27642235, 27952586, 27304131, 27461740, 27636900, 27539876

      This patch overlays patches:

      27783303

      This patch needs patches:

      27783303

      as prerequisites

      

      Patch 27908644 : applied on Sat Aug 18 04:31:26 CDT 2018

      Unique Patch ID: 22299245

      Patch description: "UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171"

      Created on 29 Jun 2018, 02:51:19 hrs PST8PDT

      Bugs fixed:

      27908644

      

      Patch 27783303 : applied on Sat Aug 18 04:25:42 CDT 2018

      Unique Patch ID: 22238986

      Patch description: "Windows Database Bundle Patch : 18.3.0.0.180717 
      (27783303)"

      Created on 16 Aug 2018, 07:58:43 hrs PST8PDT

      Bugs fixed:

      27026401, 27994333, 27680509, 27314206, 27345231, 24925863, 27447452

      26792891, 27236110, 27608669, 27670484, 27421101, 27240246, 27213140

      27740844, 27616657, 18701017, 27177852, 27697092, 27379956, 26598422

      27688099, 27580996, 27534509, 27602488, 27333978, 27098733, 27163313

      27551855, 27012915, 27603841, 27224987, 28165545, 27259983, 27919283

      28039953, 27357773, 27302730, 27263996, 27345498, 27517818, 27377219

      26882126, 27396377, 27701279, 27285557, 27779886, 27739006, 27585755

      27321834, 27748954, 27950708, 26646549, 26961415, 27061736, 27066519

      27498477, 28174926, 21806121, 24489904, 27570318, 27365139, 27028251

      27435537, 27869339, 27226913, 27192754, 27038986, 27537472, 27483974

      27329812, 27356373, 27714373, 27422874, 27334648, 27339115, 25035594

      27128580, 27952762, 27691717, 27534289, 27425622, 27434974, 27518227

      27426363, 27352600, 26450454, 27631506, 27143882, 27346949, 27181521

      27199245, 27252023, 27911160, 27365702, 27497950, 26586174, 12816839

      27389352, 25287072, 27215007, 27345190, 27475272, 25634405, 27813267

      27726269, 27463879, 27086406, 27283029, 27850736, 27338838, 27428790

      27395404, 27924147, 27284286, 27430254, 27262945, 27250547, 27346329

      27693713, 27347126, 27745220, 27341036, 27481765, 28174827, 27450355

      27214085, 27503413, 27451182, 27359178, 27625274, 27587672, 28320117

      27367194, 27782464, 27735534, 27396365, 27210872, 27501327, 27984028

      27309182, 27520070, 27999597, 27381383, 27302415, 27378103, 27861909

      27782339, 27254851, 27086821, 27101273, 27465480, 27232983, 27941514

      27486253, 27489719, 27222626, 27560562, 27244785, 27458829, 27262650

      27155549, 25743479, 27897639, 27615608, 27459909, 27267992, 27304936

      27663370, 27602091, 27448162, 27434486, 26933599, 26928317, 27586810

      27153755, 27348081, 27314390, 27786669, 27573408, 27532375, 26818960

      25824236, 27563767, 27060859, 27126666, 27284499, 27210038, 25726981

      9062315, 27301308, 27725967, 27452760, 28188330, 27834984, 27748321

      26990202, 27811439, 27376871, 27654039, 27080748, 27333664, 28059199

      27420715, 27315159, 27331374, 27398660, 27680162, 25035599, 27718914

      27599689, 27595801, 26615291, 27040560, 26476244, 27801774, 27450783

      27066451, 27935826, 28098865, 26226953, 27501465, 27558559, 27496806

      27381656, 27299455, 27124867, 27496224, 27707544, 27163928, 27147979

      27395416, 27532009, 21766220, 27727843, 27607805, 27271876, 26860285

      27997875, 28204423, 27204133, 27627992, 27592466, 27395794, 27430802

      27511196, 27302800, 27204476, 27941896, 27560702, 27053044, 24689376

      27447687, 27451049, 27302695, 26843664, 27181537, 27744211, 27445462

      26427905, 27106915, 27896388, 27812593, 27926113, 27487795, 27135647

      27496308, 28239335, 27452897, 26986173, 27434050, 27513114, 27114112

      27265816, 27274536, 27396624, 28090453, 27396666, 27573409, 27331069

      27379846, 27270197, 27016503, 27934468, 27595973, 27410595, 27833369

      27577758, 26966120, 27757979, 27434193, 27393421, 27032726, 27613080

      27208953, 27538461, 27581484, 27321179, 27263677, 26898279, 27573154

      27492916, 27961746, 27591842, 27868727, 27047831, 27783289, 27405242

      27970265, 27333693, 27506774, 27112686, 27379233, 27471876, 27425507

      28205874, 27544030, 27401637, 27740854, 27993298, 27193810, 27212208

      27184253, 27288230, 27399499, 27786772, 27978668, 26423085, 27873643

      27481406, 27182006, 27547732, 27889841, 27169796, 27501413, 27679488

      27518310, 27545630, 27346644, 27625010, 27360126, 27378959, 27772815

      27525909, 27945870, 27275136, 27321575, 28182503, 26336101, 27216224

      27375260, 27249544, 27174948, 27294480, 27957892, 27774539, 27664702

      27839732, 27166715, 27432355, 27257509, 27657920, 27190851, 27773602

      27774320, 27508936, 27457666, 27330161, 27339396, 27092991, 27101652

      27803665, 27396672, 27472969, 27579969, 27610269, 27302594, 27778433

      27339495, 25724089, 27739957, 28023410, 27433163, 27222121, 27851757

      28109698, 27732323, 27691809, 27503208, 26822620, 28264172, 26846077

      27189611, 27222423, 28132287, 27121566, 27282707, 27133637, 27451531

      27613247, 27560735, 27702244, 27341181, 28240153, 27479358, 27370933

      27396357, 27153641, 26827699, 27238258, 27364916, 27307868, 27791223

      27041253, 27090765, 27892488, 27034318, 27349393, 27412805, 27399762

      27302960, 27679664, 27815347, 27399985, 27241247, 26654411, 27077948

      26987877, 27354783, 27701795, 27304410, 27882176, 27119621, 26956033

      27300007, 27339165, 28106402, 27451187, 27058530, 21547051, 28025398

      27682288, 27398080, 27586895, 27679806, 27164122, 27243810, 13554903

      27993289, 27504190, 26587652, 27212837, 27274143, 27768034, 27550341

      27558861, 27060167, 27600706, 28022847, 27241221, 27131377, 26992964

      27690578, 27747407, 27305318, 27230645, 27818871, 27346709, 28057267

      27405696, 27523368, 27574335, 27526362, 27174938, 27931506, 27392187

      27221900, 27797290, 28184554, 27401618, 27410300, 26313403, 27864737

      27362190, 27439835, 24737581, 27368850, 27593587, 27751006, 23840305

      26996813, 27625050, 27657467, 27073066, 27302711, 27453225, 27984314

      27274456, 27522245, 27417186, 27469329, 27338946, 27396813, 27786699

      27285244, 27692215, 27519708, 23003564, 27339483, 27783059, 26882316

      27757567, 26527054, 27862636, 27563629, 27635508, 27508985, 26785169

      27472898, 27971575, 28413955, 27302681, 27609819, 27345450, 27788520

      27018734, 27766679, 27101527, 27906509, 27593389, 27625620, 27036408

      27358232, 27335682, 23698980, 27144533, 27585800, 27458164, 22734786

      27523800, 28169711, 27384222, 27723002, 27473800, 27310092, 27604293

      27731346, 27365993, 27005278, 27320985, 27445330, 27649707, 27709046

      27313687, 27249215, 25348956, 27065091, 26433972, 27339654, 27318988

      27333658, 27533819, 27403244, 27520900, 27534651, 27030974, 27427805

      27359368, 23310101, 27644757, 27314512, 27044575, 27223171, 27240570

      27156355, 27528204, 27989849, 27143756, 27679961, 27110878, 25943740

      27747869, 27734470, 27283960, 27682151, 27719187, 26894737, 27869283

      27652302, 27182064, 27467543, 27334353, 26843558, 27840386, 27457891

      27334316, 27372756, 27705761, 27484556, 27708711, 27753336, 27364891

      27964051, 27503318, 27423251, 27865439, 27780562, 26731697, 27358241

      27634676, 27726780, 27444727, 27441326, 27326204, 27812560, 27432338

      27577122, 27177551, 27275776, 27558557, 27375542, 26299684, 27301568

      27593263, 27258578, 27222938, 27703242, 27512439, 27508984, 27398223

      27330158, 27807441, 27079545, 27404599, 27259386, 27688692, 28039471

      27292213, 27392256, 27307934, 27617522, 27505603, 27450400, 27348707

      27460675, 27238077, 27346984, 27364947, 26943660, 27236052, 27338912

      27244337, 28021205, 28032758, 28033429, 27263276, 27579353, 27233563

      27220610, 28099592, 27433870, 27426277, 26647619, 27847259, 25929650

      27738679, 27502420, 25709124, 28045209, 27668379, 27318869, 27832643

      27302777, 28072130, 27442041, 27430219, 27614272, 27930478

      ---------------------------------------------------------------------

      OPatch succeeded.

LSINVENTORY

Crosscheck installed products, patches, and Oracle home directories and lists the inventory for a particular $ORACLE_HOME or display all installations that can be found. SYNTAX
opatch lsinventory [-all ] [-all_nodes] [-bugs_fixed <asc | desc> ] [-delay <value> ] [-detail ] [-group_by_date ] [-inactive] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-local ] [-oh <ORACLE_HOME> ] [-patch <asc | desc> ] [-patch_id <asc | desc> ] [-ptlConnect <portal connect string> ] [-ptlPassword <portal password> ] [-ptlSchema <portal schema> ] [-property_file <path to property file>] [-retry <value> ] [-translation_patch ] [-xml <xmlFile>]

OPTIONS
-all
Report the name and installation directory for each $ORACLE_HOME found.

-all_nodes
Reports the patches installed on the given Oracle Home in all nodes of the RAC system. It also prints the oracle binary's size and checksum on all nodes. This option cannot be used in conjunction with -all, -detail, -patch.

-bugs_fixed
Reports bugs fixed by installed patches in a tabular format. Besides the bugs fixed, the report also displays the installed patches, installed times, and bug descriptions. The fixed bugs are sorted per installed patch. Default display is patches in descending order based on installed time and ascending order of bugs within each patch. You can use 'asc' (or) 'desc' with this option to enforce sort order on bugs within each patch.

You can use this option with the patch (or) patch_id option to obtain sort orders with installed patches.

-delay
If -retry is specified, this option tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-detail(s)
Report installed products and other details. This option cannot be used in conjunction with all option.

-group_by_date
This option tells OPatch to group all installed patches by the date they were installed in the Oracle Home.

-inactive
This option lists all the inactive patches that have been superseded by other superset patch(es) installed in the Oracle Home.

-invPtrLoc
Used to locate the oraInst.loc file. When the installation used the invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
This option tells OPatch to display inventory information of the local node only.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-patch
Lists the patch IDs installed in the Oracle home in ascending (asc) or descending (desc) order, which is the default, based on installed time.

-patch_id
Lists the patch IDs installed in the oracle home in ascending (asc) or descending (desc) order based on patch numbers. The value defaults to ascending (asc).

-ptlConnect
This option is used to specify the connect string credentials of the portal schema.

-ptlPassword
This option is used to specify the password of the portal schema.

-ptlSchema
This option is used to specify the schema of the portal repository.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-retry
This option tells OPatch how many times it should retry in case of an inventory lock failure.

-translation_patch
Report installed translation patch(es) in a tabular format. The report displays translation patch, unique patch identifier, language code, installed time of the translation patch and base patch for any single row in the table.

-xml
This option must be followed with an xml filename, and it will generate xml output based on the current Oracle Home inventory into the filename.

PARAMETERS
This operation does not have any required parameters.

-- windows

      c:\> set oracle_home=c:\app\oracle\product\12.1.0\dbhome_1

      

      c:\>  c:\app\oracle\product\12.1.0\dbhome_1\OPatch\opatch lsinventory -all

-- linux

sudo su - oracle

      

      export ORACLE_HOME=/app/oracle/product/12.1.0/db_1

      

      cd $ORACLE_HOME/OPatch

      

      ./opatch lsinventory -details

      

      ./opatch lsinventory -bugs_fixed

LSPATCHES

List and verify patch metadata specified by patch ID (installed in ORACLE_HOME) or patch location. SYNTAX
opatch lspatches [-bugs] [-id <patch ID> ] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-oh <ORACLE_HOME> ] [ <patch location> ] [-qfile <file path> ] [-required ] [-verify]

OPTIONS
-bugs
Print bugs info for every patch.

-id
This option specifies the patch number. It must be registered in the Oracle Home inventory. It can be any numeric sequence or combined with language. Ex. 11111, 11111/zh_CN. It can't support multiple patch IDs.

-invPtrLoc
Used to locate the oraInst.loc file. When the installation uses the invPtrLoc flag, the value should indicate the path to oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-qfile
Specify the relative path to Oracle Home of the file to determine the latest patch that touches this file.
Ex. On Linux: admin/rdbms/catcpu.sql
On Windows: admin\rdbms\catcpu.sql
OPatch can tell which latest patch touches the file catcpu.sql in Oracle Home.

-required
This option will print key metadata only. This includes the following metadata: required components, prereq patches, executables to shutdown and support platforms.
This option should be accompanied by either option -id <PATCH_ID> or <PATCH_LOCATION>.

-verify
This option would verify if the specified patch ID or patch location is registered in Oracle Home inventory or not. Besides, it will verify if all patch files are ok in $ORACLE_HOME. This option should be accompanied by either option -id <PATCH_ID> or <PATCH_LOCATION>.This option doesn't support System Patch.
Ex. opatch lspatches -id 111 -verify
opatch lspatches /scratch/test/111 -verify

C:\app18\OPatch>opatch lspatches

      28267731;WINDOWS OJVM BUNDLE PATCH : 18.3.0.0.180717 (28267731)

      27908644;UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171

      27783303;Windows Database Bundle Patch : 18.3.0.0.180717 (27783303)

NAPPLY

Used to Apply a set of patches one at a time. Use -silent to apply the patches in silent mode. This command doesn't support System Patch. SYNTAX
opatch napply [patch_location] [-id comma-separated list of patch IDs] [ -all_nodes ] [-connectString <List of connect strings>] [-delay <value> ] [ -force ] [ -force_conflict ] [-idFile <path of the file that has list of patch IDs ] [-init <parameters for the init script in escaped double quotes> [-opatch_init_end] ] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [ -local ] [ -local_node <Local node name> ] [-minimize_downtime ] [-no_bug_superset ] [-no_inventory ] [-no_relink] [-no_sysmod] [-ocmrf <Response file location> ] [-oh <ORACLE_HOME> ] [ -phBaseDir <Path to the directory that contains list of patch directories> ] [ -phBaseFile <Path to the file containing the location of the patches to be applied> ] [-post <parameters for the post script in escaped double quotes> [-opatch_post_end] ] [-pre <parameters for the pre script in escaped double quotes> [-opatch_pre_end] ] [-profile_mask <Name of profile>] [ -property_file <Path to property file> ] [-ptlConnect <portal connect string>] [-ptlPassword <portal password>] [-ptlSchema <portal schema>] [ -remote_nodes <List of remote nodes (node1,node2)> ] [-retry <value> ] [-runSql] [-silent ] [-skip_subset] [-skip_duplicate] [-sqlScript <path of the sql file>] [-verbose ]

OPTIONS
-all_nodes
Apply the patch using all-node mode.

-connectString
This option can be used to specify the list of database instances on which the patch needs to be applied. The value for this option is specified as per the following syntax "SID:User:Passwd:Node". The SID is a must, others can be ignored, OPatch takes default values for it.
Ex: oracle:dba:dba:mymachine,oracle1:::
NOTE: If the system is not part of RAC setup, then to patch just the local node, provide the node name as empty string.

-delay
If -retry is specified, this options tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-force
This option is meaningful with 'silent' option and is used to override the behavior of silent under specific circumstances.

-force_conflict
If a conflict exist which prevents the patch from being applied, the -force_conflict flag can be used to apply the patch.
OPatch will remove all the conflicting patches before applying the current patch. This will override the 'silent'
behavior for conflicts and hence is meaningful only when used with 'silent' option.

-id
Use 'lsinventory' option to display all patch ids. Each one-off patch is indicated by its id. A comma separated list of patches can be given to select the patches to be applied. For translation patches, the patch id should be of the format
<Patch ID>/<Language code>.

-idFile
The input to be given is a file location that contains a list of apply patch ids separated by commas or white spaces. This option cannot to be in conjunction with 'id' option. For translation patches, the patch id should be of the format <Patch ID>/<Language code>.

-init
This option is used to pass parameters to the init script. This script is executed before prerequisite checks
are run. The value for this option have to be enclosed in double quotes. The parameters will be common parameters
which will be passed to init scripts of all patches being applied. This option should be ended by option 'opatch_init_end'.

-invPtrLoc
Used to locate the oraInst.loc file. Needed when the installation used the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
Patch the local node, then update inventory of the local node. Do not propagate the patch or inventory update to other nodes.

-local_node
This option can be used to specify to OPatch the local node name to be used for RAC mode application of the patch.

-minimize_downtime
Only applied to RAC instances. User supplies the order of nodes to be patched. This option cannot be used in conjunction with -local option with a rolling patch.

-no_bug_superset
This option tells OPatch to error out if the current patch's bugs-to-fix is a super-set (or same set) of an installed patch's bugs-fixed in the Oracle Home.

-no_inventory
Bypass the inventory for reading and updates.

-no_relink
The nolink option does not perform any make operations. This option can be used during multiple patch.
applications and perform the linking step only once. OPatch does not keep track of the make operations it did not perform. It is the job of the OPatch users to make sure the execute OPatch without this option at the end, so that compilation happens once.

-no_sysmod
This option specifies not to update the files in the system. It just updates the inventory. It also will not execute the pre and post scripts.

-ocmrf
Give OPatch the absolute path to the OCM response file to be used for OCM configuration. -silent must be used
in conjunction with -ocmrf if Oracle Home doesn't have OCM installed and configured.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-opatch_init_end
This option is used to mark the end of init options. Without this option everything after init till end of the command is passed into init. This option is meaningless without -init option.

-opatch_post_end
This option is used to mark the end of post options. Without this option everything after post till end of the command is passed into post. This option is meaningless without -post option.

-opatch_pre_end
This option is used to mark the end of pre options. Without this option everything after pre till end of the command is passed into pre. This option is meaningless without -pre option.

-phBaseDir
Used to specify a directory containing patch directories (or) zip files.

-phBaseFile
If <patch_location> is not specified, use this option to point OPatch to a file containing a list of patches
to be n-applied. Each line in the file points to a location of a patch.

-ptlConnect
This option can be used to specify the connect string of the portal schema.

-ptlPassword
This option can be used to specify the password of the portal schema.

-ptlSchema
This option can be used to specify the schema of the portal repository patch.

-post
This option is used to pass parameters to the post script.
This script is executed after application of the patch.
The value for this option have to be enclosed in double quotes. The parameters will be common parameters which will be passed to post scripts of all patches being applied.
This option should be ended by option 'opatch_post_end'.

-pre
This option is used to pass parameters to the pre script. This script is executed before application of the patch. The value for this option have to be enclosed in double quotes. The parameters will be common parameters which will be passed to pre scripts of all patches being applied. This option should be ended by option 'opatch_pre_end'.

-profile_mask
If the patch to be applied specifies WLS patch/patchset as prerequisites, OPatch will read the WLS default patch profile. To have OPatch read non-default patch profile, specify the patch profile name with this option.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-remote_nodes
This option can be used to specify to OPatch the list of remote nodes to be used for RAC mode application of the patch. The node names are comma separated and without spaces.

-report
Just prints out the actions without executing.

-retry
This option tells OPatch how many times it should retry in case of an inventory lock failure.

-runSql
This option can be used to specify OPatch to run the sql scripts and sql procedures if they are present in the given patch.

-silent
This suppresses any user-interaction.

-skip_duplicate
This skips patches to be applied that are duplicates of other patches installed in the Oracle Home. Two patches are duplicates if they fix the same set of bugs.

-skip_subset
This skips patches to be applied that are subset of other patches installed in the Oracle Home. One patch is a subset of another patch if the former fixes a subset of bugs fixed by the latter.

-sqlScript
This option can be used to specify the custom sql script to be run by OPatch after patching is completed.

-verbose
This option prints more OPatch output to the screen as well as to the log file.

Example:
'opatch napply <patch_location>' to apply all patches under <patch_location> directory

'opatch napply <patch_location> -id 1,2,3' to apply patches 1, 2, and 3 which are present under <patch_location> directory.

'opatch napply <patch_location> -skip_subset -skip_duplicate' to apply all patches under <patch_location> directory.
OPatch will skip duplicate patches and subset patches (patches under <patch_location> that are subsets of patches installed in the Oracle Home).

'opatch napply <patch_location> -id 1,2,3 -skip_subset -skip_duplicate' to apply patches 1, 2, and 3 which are under <patch_location> diretory. OPatch will skip duplicate patches and subset patches (patches under <patch_location> that are subsets of patches installed in the Oracle Home).

'opatch napply <patch_location> -idfile /tmp/list.txt' where list.txt contains a list of patch IDs to be applied. The list should be separated by a space or comma.
For example: 1 2 3.

'opatch napply <patch_location> -id 1/fr,2/de' to apply patches 1 (french patch), 1 (german patch) which are present in the <patch_location> directory.

TBD

NROLLBACK

Used to Rollback a set of patches one at a time. Use -silent to Rollback the patches in silent mode. SYNTAX
opatch nrollback -id <comma-separated list of patch IDs> [ -all_nodes ] [-connectString <List of connect strings>] [-delay <value>] -id <Comma separated list of patch IDs> [-idFile <file location containing a list of rollback IDs separated by commas or white spaces> [-init <parameters for the init script in escaped double quotes> [-opatch_init_end] ] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-local] [-local_node <Local node name>] [-no_inventory] [-no_relink] [-no_sysmod] [-oh <ORACLE_HOME> ] [-post <parameters for the post script in escaped double quotes>[ -opatch_post_end] ] [-pre <parameters for the pre script in escaped double quotes> [-opatch_pre_end] ] [-property_file <Path to property file>] [-ptlConnect <portal connect string>] [-ptlPassword <portal password>] [-ptlSchema <portal schema>] [-remote_nodes <List of remote nodes (node1,node2)>] [-retry <value>] [-runSql] [-silent] [-sqlScript <path of the sql file>] [-verbose]

OPTIONS
-all_nodes
Rollback the patch using all-nodes mode.

-connectString
This option can be used to specify the list of database instances on which the patch needs to be applied. The value for this option is specified as per the following syntax "SID:User:Passwd:Node". The SID is a must, others can be ignored, OPatch takes default values for it.
Ex: oracle:dba:dba:mymachine,oracle1:::
NOTE: If the system is not part of RAC setup, then to patch just the local node, provide the node name as empty string.

-delay
If -retry is specified, this option tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-id
Use 'lsinventory' option to display all patch ids. Each one-off patch is indicated by its id. To rollback a patch the id for that patch must be supplied. A comma separated list of patches to be rolled back must be given. For translation patches, the patch id should be of the format <Patch ID>/<Language code> (ex: 1234/fr)

-idFile
Use 'lsinventory' option to display all patch ids. Each one-off patch is indicated by its id. To rollback a patch, the id for that patch must be supplied. The input to be given is a file location that contains a list of rollback patch ids separated by commas or white spaces. For translation patches, the patch id should be of the format <Patch ID>/<Language code>. This option cannot to be in conjunction with 'id' option.

-init
This option is used to pass parameters to the init script. This script is executed before prerequisite checks are run. The value for this option have to be enclosed in double quotes. The parameters will be common parameters which will be passed to init scripts of all patches being rolled back. This option should be ended by option 'opatch_init_end'.

-invPtrLoc
Used to locate the oraInst.loc file. Needed when the installation used the invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
Roll back then update inventory of the local node. Do not propagate the patch or inventory update to other nodes.

-local_node
This option can be used to specify to OPatch the local node name to be used for RAC mode rollback of the patch.

-no_inventory
This option specifies not to update the inventory, it just updates the files in the system. If inventory is readable, then OPatch tries to read the inventory.
NOTE: -phBaseDir or -phBaseFile has to be used to specify the patch location(s).

-no_relink
Do not perform the make operations in the patch. This option can be used during multiple patch removals and perform the compilation step only once.

-no_sysmod
This option specifies not to update the files in the system. It just updates the inventory. It also will not execute the pre and post scripts.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-opatch_init_end
This option is used to mark the end of init options. Without this option everything after init till end of the command is passed into init. This option is meaningless without -init option.

-opatch_post_end
This option is used to mark the end of post options. Without this option everything after post till end of the command is passed into post. This option is meaningless without -post option.

-opatch_pre_end
This option is used to mark the end of pre options. Without this option everything after pre till end of the command is passed into pre. This option is meaningless without -pre option.

-post
This option is used to pass parameters to the post script. This script is executed after removal of the patch. The value for this option have to be enclosed in double quotes. The parameters will be common parameters which will be passed to post scripts of all patches being rolled back. This option should be ended by option 'opatch_post_end'.

-pre
This option is used to pass parameters to the pre script. This script is executed before removal of the patch. The value for this option have to be enclosed in double quotes. The parameters will be common parameters which will be passed to pre scripts of all patches being rolled back. This option should be ended by option 'opatch_pre_end'.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-ptlConnect
This option can be used to specify the connect string of the portal schema.

-ptlPassword
This option can be used to specify the password of the portal schema.

-ptlSchema
This option can be used to specify the schema of the portal repository patch.

-remote_nodes
This option can be used to specify to OPatch the list of remote nodes to be used for RAC mode rollback of the patch. The node names are comma separated and without spaces.

-report
Just prints out the actions, without executing.

-retry
This option tells OPatch how many times should retry in case of an inventory lock failure.

-runSql
This option can be used to specify OPatch to run the sql scripts and sql procedures if they are present in the given patch.

-silent
This suppresses any user-interaction and defaults any Y|N question to Y. This option is not supported on RAC yet.

-sqlScript
This option can be used to specify the custom sql script to be run by OPatch after patching is completed.

-verbose
This option prints more OPatch output to the screen as well as to the log file.

Example:
'opatch nrollback -id 1,2,3' to roll back patches 1, 2, and 3 that have been installed in the Oracle Home.
'opatch nrollback -id 1/fr,2/de to rollback patches 1 with language 'fr', 2 with language 'de' that have been installed in the Oracle Home.

TBD

PREREQ

This operation runs the prerequisite checks on an ORACLE_HOME. This command doesn't support System Patch. SYNTAX
opatch prereq <command> [-id <Comma separated list of patch IDs>] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC>] [-local_node <Local node name>] [-oh <ORACLE_HOME> ] [-ph <Path to the single patch location>] [-phBaseDir <Path to the dir containing all patches>] [-phBaseFile <Path to the file containing the location of the patches to be applied>] [-property_file <Path to property file>] [-remote_nodes <List of remote nodes (node1,node2)>] [-sid <Comma separated list of database SIDs>] [-connectString <List of connect strings>]

COMMANDS
CheckActiveFilesAndExecutables
Check if there are any file(s) that are active, which are touched by the patch to be applied or rolled back.

CheckActiveServices
Check for the services that are active.
Note: Applicable for Windows platforms only.

CheckApplicable
Check for the presence of the required components in the ORACLE_HOME and check if all the actions of the given patch(es) are applicable.

CheckApplicableProduct
Check if the patch is applicable for the given Oracle Home. If the patch is marked for stand-alone homes, then it can not be applied on normal oui-based home and vice versa. Also, a patch can be marked as a hybrid patch, where it is applicable for both homes.

CheckCentralInventoryForOH
Check if the given ORACLE_HOME is registered in the central inventory specified by the oraInst.loc file.

CheckCentralInventoryForRWSession
Check if a RW (read-write) session can be created for the given central inventory.

CheckCentralInventoryLocation
Validate the Central Inventory location. Check if it has the correct directory structure and has the inventory.xml with read permissions.

CheckComponents
Check for the presence of the required components in the ORACLE_HOME.

CheckConflictAgainstOH
Check if there are any conflicts between the patch(es) to be applied and the patch(es) in the OH.

CheckConflictAgainstOHWithDetail
Check if there are any conflicts between the patch(es) to be applied and the patch(es) in the OH, by giving out the detailed information about the conflicts/supersets.

CheckConflictAmongPatches
Check if there are any conflicts among the patch(es) to be applied.

CheckConflictAmongPatchesWithDetail
Check if there are any conflicts among the patch(es) to be applied, by giving out the detailed information about the conflicts/supersets.

CheckFileVersions
Check if the copy actions of Fusion Applications patch(es) have alleast one or more file version(s) greater than the version(s) installed in the Oracle Home.

CheckFusionAppsCompatible
Check if OUI for the Oracle Home supports patching of Fusion applications.

CheckForCRSHomeIfRAC
Check if the given Central Inventory has a CRS Home registered with it, if it is a RAC setup.

CheckForIdenticalPatchInOracleHome
Check if the given list of patch(es) are identical with respect to the patch(es) installed in the Oracle Home.

CheckForInputValues
Check if the input values provided to OPatch are enough for OPatch to proceed further.

CheckForNoOpPatches
Check if any of the patch(es) provided by the user are no-op. patches. A no-op patch. cannot be applied to the Oracle Home and can be skipped. This prereq will fail for no-op. patches.

CheckIfOHLockedForPatching
Check if the ORACLE_HOME is locked for patching by any previous unsuccessful OPatch Session.

CheckInstalledOneOffs
Check if all the patches provided by the user to rollback are present in the given Oracle Home.

CheckMinimumOPatchVersion
Check if all the patches provided by the user satisfy the requirement of minimum OPatch version for the OPatch currently being used.

CheckOneOffSuperset
Check if the given input Fusion Applications patch list are all candidates for one-off (or) singleton supersets.
This prereq does not do any checks among the input patch list.

CheckOracleHome
Check if the given ORACLE_HOME is valid. Check if it has the inventory files with proper permissions.

CheckOraInstLocation
Check if the oraInst.loc file is proper and has the read permissions.

CheckOUILocation
Check the ORACLE_HOME for the presence of OUI.

CheckOUIVersionCompatible
Check if the OUI in the ORACLE_HOME is compatible for the OPatch.

CheckPatchApplicableOnCurrentPlatform
Check if the given patch(es) is applicable on the current platform.

CheckPatchApplyDependents
Check if all the patch(es) required by the patch(es) currently being installed is present in the Oracle Home or not.

CheckPatchRollbackDependents
Check if there are any patch(es) in the Oracle Home that are depending on the patch(es) being currently rolled back.

CheckPatchShipHome
Check if the given patch to be applied has the proper structure and has the correct permissions for all the files.

CheckRACNodeList
Check if all the nodes in the RAC setup are valid, up and reachable.

CheckRemoteCommandInvocable
Check if commands can be invoked on the remote machines.

CheckRemoteCopyAndRemove
Check if files can be copied to and removed from the remote machines.

CheckRequiredLibs
Check if all the required OUI libraries are present in the given ORACLE_HOME.

CheckRollbackable
Check if the given patch(es) can be rolled back from the ORACLE_HOME.

CheckRollbackSid
Check if the given patch(es) can be rolled back from the ORACLE_HOME using the given SIDs.

CheckStandAloneHome
Check if the Oracle Home is a stand-alone home or a normal oui-based home.

CheckSystemCommandAvailable
Check if all the commands required for applying or rolling back the given patch are present in the system.

CheckSystemSpace
Check if enough system space is available for the patch(es) to be applied.

CheckUserAdminPrivilege
Check is the user is 'root'.
Note: OPatch should not be invoked by 'root', if so then this check fails.

CheckPatchingModel
Check if the patching model of all incoming patch(es) is compatible with that of the Oracle Home.

OPTIONS
-connectString
This option can be used to specify the list of database instances and remote nodes. The value for this option is specified as per the following syntax "SID:User:Passwd:Node". The SID is a must, others can be ignored, OPatch takes default values for it.
Ex: oracle:dba:dba:mymachine,oracle1:::
NOTE: If the system is not part of RAC setup, then to specify just the local node, provide the node name as empty string. This option cannot be used along with 'sid' option.

-id
This option can be used to specify the patch IDs of all the patches that are to be rollbacked from the given OH.

-invPtrLoc
Used to locate the oraInst.loc file. Needed when the installation used the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local_node
This option can be used to specify to OPatch the local node name to be used for RAC mode application of the patch.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-ph
This option can be used to specify the path to the patch location.
Ex: /tmp/101010

-phBaseDir
This option can be used to specify the path to base dir where all the patches to be applied are kept.
Note: The directory should contain only non-duplicate patches in zipped or unzipped format.

-phBaseFile
This option can be used to specify complete path to the file containing the location of the patches to be applied.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-remote_nodes
This option can be used to specify to OPatch the list of remote nodes to be used for RAC mode application of the patch. The node names are comma separated and without spaces.

-sid
This option can be used to specify the SIDs of the database instances. This option can be used only for local system operations.

TBD

QUERY

This operation loads and prints out various information about a patch. Parameter patch_location points to where a patch is located. For example, if you specify "path", there should be sub-dir. "etc/config" under "path". SYNTAX
opatch query [-all] [-is_auto_patch] [-is_translatable_patch] [-get_base_bugs] [-get_component] [-get_os] [-get_date] [-get_patch_language] [-get_patch_type] [-get_patching_model] [-get_product_family] [-has_sql] [-is_online_patch] [-is_rolling_patch] [-is_system_patch] [-jre <LOC> ] [-oh <LOC> ] [ <patch_location> ]

OPTIONS
-all
Get everything available about a patch. This is equivalent to setting all available options.This command doesn't support System Patch.

-is_auto_patch
This option says 'true' if the patch is auto-enabled, 'false' otherwise. This command doesn't support System Patch.

-is_system_patch
This option says 'true' if the patch is a System Patch, 'false' otherwise.

-is_translatable_patch
This option says 'true' if the patch is translatable, 'false' otherwise. This option doesn't support System Patch.

-get_base_bug
Get bugs fixed by the patch. This option doesn't support System Patch.

-get_component
Get components touched by the patch. This option doesn't support System Patch.

-get_date
Get patch creation date and time. This option doesn't support System Patch.

-get_os
Get platforms for which this patch could be applied. This option doesn't support System Patch.

-get_patch_type
Get the patch type. This command doesn't support System Patch.

-get_patching_model
Get the patching model. This option doesn't support System Patch.

-get_patch_language
Get the language supported by the patch. This option doesn't support System Patch.

-get_product_family
Get the product family to which the patch belongs. This option doesn't support System Patch.

-has_sql
This option says 'true' if the patch has sql related actions, 'false' otherwise. This option doesn't support System Patch.

-is_sql_patch
This option says 'true' if the patch is a sql patch, 'false' otherwise. This command doesn't support System Patch.

-is_online_patch
This option says 'true' if the patch is a online patch, 'false' otherwise. This option doesn't support System Patch.

-is_rolling_patch
This option says 'true' if the patch is a rolling patch, 'false' otherwise. This option doesn't support System Patch.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

PARAMETERS
The location of the patch to be queried. If the patch location is not specified, then the current directory is taken as the patch location.

TBD

ROLLBACK

Rollback an existing one-off patch indicated by the reference-id. This command doesn't support System Patch. SYNTAX
opatch rollback -id <ID> [-connectString <List of connect strings>] [-delay <value>] [-init <parameters for the init script in escaped double quotes> [-opatch_init_end] ] [-invPtrLoc <Path to oraInst.loc> ] [-jre <LOC> ] [-local] [-local_node <Local node name>] [-no_inventory] [-no_relink] [-no_sysmod] [-oh <ORACLE_HOME>] [-ph <Patch Location>] [-post <parameters for the post script in escaped double quotes>[ -opatch_post_end] ] [-pre <parameters for the pre script in escaped double quotes> [-opatch_pre_end] ] [-property_file <path to property file>] [-ptlConnect <portal connect string>] [-ptlPassword <portal password>] [-ptlSchema <portal schema>] [-remote_nodes <List of remote nodes (node1,node2)>] [-retry <value>] [-runSql] [-silent] [-sqlScript <path of the sql file>] [-verbose] [all_subpatches]

OPTIONS
-all_nodes
Roll back the patch using all-nodes mode.

-connectString
This option can be used to specify the list of database instances on which the patch needs to be applied. The value for this option is specified as per the following syntax "SID:User:Passwd:Node". The SID is a must, others can be ignored, OPatch takes default values for it.
Ex: oracle:dba:dba:mymachine,oracle1:::
NOTE: If the system is not part of RAC setup, then to patch just the local node, provide the node name as empty string.

-delay
If -retry is specified, this option tells OPatch how many seconds it should wait before attempting to lock inventory again in case of a previous failure.

-id
Use 'lsinventory' option to display all patch id's. Each one-off patch is indicated by its id. To roll back a patch the id for that patch must be supplied. For translation patches, Please specify <id>/<language code> (ex: 1234/fr).

-init
This option is used to pass parameters to the init script. This script is executed before prerequisite checks are run. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_init_end'.

-invPtrLoc
Used to locate the oraInst.loc file. Needed when the installation used the invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-local
Roll back then update inventory of the local node. Do not propagate the patch or inventory update to other nodes.

-local_node
This option can be used to specify to OPatch the local node name to be used for RAC mode rollback of the patch.

-no_inventory
This option specifies not to update the inventory, it just updates the files in the system. If inventory is readable, then OPatch tries to read the inventory.
NOTE: ph has to be used to specify the patch location.

-no_relink
Do not perform the make operations in the patch. This option can be used during multiple patch removals and perform the compilation step only once.

-no_sysmod
This option specifies not to update the files in the system. It just updates the inventory. It also will not execute the pre and post scripts.

-oh
The oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-opatch_init_end
This option is used to mark the end of init options. Without this option everything after init till end of the command is passed into init. This option is meaningless without -init option.

-opatch_post_end
This option is used to mark the end of post options.Without this option everything after post till end of the command is passed into post. This option is meaningless without -post option.

-opatch_pre_end
This option is used to mark the end of pre options. Without this option everything after pre till end of the command is passed into pre. This option is meaningless without -pre option.

-ph
Specify the valid patch directory area. Rollback will use the command types found in the patch directory to identify what commands are to be used for the current operating system.

-post
This option is used to pass parameters to the post script. This script is executed after removal of the patch. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_post_end'.

-pre
This option is used to pass parameters to the pre script. This script is executed before removal of the patch. The value for this option have to be enclosed in double quotes. This option should be ended by option 'opatch_pre_end'.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

-ptlConnect
This option can be used to specify the connect string of the portal schema.

-ptlPassword
This option can be used to specify the password of the portal schema.

-ptlSchema
This option can be used to specify the schema of the portal repository patch.

-remote_nodes
This option can be used to specify to OPatch the list of remote nodes to be used for RAC mode rollback of the patch. The node names are comma separated and without spaces

-report
Just prints out the actions, without executing.

-retry
This option tells OPatch how many times should retry in case of an inventory lock failure.

-runSql
This option can be used to specify OPatch to run the sql scripts and sql procedures if they are present in the given patch.

-silent
This suppresses any user-interaction and defaults any Y|N question to Y. This option is not supported on RAC yet.

-sqlScript
This option can be used to specify the custom sql script to be run by OPatch after patching is completed.

-verbose
This option prints more OPatch output to the screen as well as to the log file

-all_subpatches
This option is valid ONLY for composite patches. It allows the user to rollback all subpatches of a composite series in one shot.

PARAMETERS
Patch ID of the patch to be rolled back unless the command is invoked within a patch area. For translation patches, it will be <Patch ID>/<Language code>.

TBD

START

This command allows Fusion Middleware runtime entities to be started. This command operates through the Admin Server of the domain which needs to be accessible. In addition, the Node Manager is required to be configured and running on the machines which have the WebLogic Server instances installed and affected by this command.

OPatch will pose questions to query for information necessary for accessing the Fusion Middleware domain such as Admin Server URL, Admin Server User, Admin Server Password, Node Manager User and Node Manager Password. SYNTAX
opatch start [-domain <DOMAIN_NAME> ] [-invPtrLoc <path to oraInst.loc> ] [-oh <Reference Oracle Home path> ] [-report ] -targets <List of Targets> [-target_type <Target Type> ] [-silent ] [-property_file <Path to custom property file> ]

OPTIONS
-domain
The name of the Fusion Middleware domain for which the specified targets will be started.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-oh
The Oracle Home to work on. This takes precedence over the environment variable ORACLE_HOME.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch For FMW components, 'AdminConfigFile', 'AdminKeyFile', 'NodeManagerConfigFile' and 'NodeManagerKeyFile' location can be specified as keys with corresponding files as values. They refer to encrypted, decrypted files for Admin user, Admin password, Node Manager user and Node Manager password. Similarly, Admin Server URL (key as AdminServerURL), Domain Home (key as DomainHome) and Applications Directory (key as ApplicationsDir) can be given as keys with corresponding values. The Key, value pair is of the format 'x=y' where 'x' is OPatch understood key and each pair is separated by newline in the property file.

For encryption files, Please check 'storeUserConfig' WLST command for details.

-report
Just prints out the actions without execution.

-targets
The list of targets to be started.

-target_type
The type of target to be started. Only supported target type is 'fmwServer'. This option is *deprecated*.

-silent
Invoke the operation in silent mode. Path to custom property file may be provided which will have required inputs as name-value pairs. If required inputs are not found, OPatch will exit with error message quoting the missing inputs.

PARAMETERS
The required parameter is targets

C:\app18\OPatch>opatch start report

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_22-13-35PM_1.log

      

      Unable to lock Central Inventory. OPatch will attempt to re-lock.

      Do you want to proceed? [y|n]

      n

      User Responded with: N

      OPatchSession cannot load inventory for the given Oracle Home C:\app18. Possible causes are:

      No read or write permission to ORACLE_HOME/.patch_storage

      Central Inventory is locked by another OUI instance

      No read permission to Central Inventory

      The lock file exists in ORACLE_HOME/.patch_storage

      The Oracle Home does not exist in Central Inventory

      

      UtilSession failed: Unable to lock Central Inventory. Stop trying per user-request?

      

      OPatch failed with error code = 73

STOP

This command allows Fusion Middleware runtime entities to be stopped. This command operates through the Admin Server of the domain which needs to be accessible. In addition, the Node Manager is required to be configured and running on the machines which have the WebLogic Server instances installed and affected by this command.

OPatch will pose questions to query for information necessary for accessing the Fusion Middleware domain such as Admin Server URL, Admin Server User, Admin Server Password, Node Manager User and Node Manager Password. SYNTAX
opatch stop [-domain <DOMAIN_NAME> ] [-invPtrLoc <Path to oraInst.loc file> ] [-oh <Reference Oracle Home path> ] [-report ] -targets <List of Targets> [-target_type <Target Type> ] [-silent ] [-property_file <Path to custom property file> ]

OPTIONS
-domain
The name of the Fusion Middleware domain for which the specified targets will be stopped.

-invptrloc
Used to locate the oraInst.loc file. Needed when the installation uses the -invPtrLoc flag. This should be the path to the oraInst.loc file.

-oh
The Oracle Home to work on. This takes precedence over the environment variable ORACLE_HOME.

-property_file
The user defined property file for OPatch to use. The path to the property file should be absolute. This property file takes precedence over the one that is supplied with OPatch.

For FMW components, 'AdminConfigFile', 'AdminKeyFile', 'NodeManagerConfigFile' and 'NodeManagerKeyFile' location can be specified as keys with corresponding files as values. They refer to encrypted, decrypted files for Admin user, Admin password, Node Manager user and Node Manager password. Similarly, Admin Server URL (key as AdminServerURL), Domain Home (key as DomainHome) and Applications Directory (key as ApplicationsDir) can be given as keys with corresponding values.

The Key, value pair is of the format 'x=y' where 'x' is OPatch understood key and each pair is separated by newline in the property file.

For encryption files, Please check 'storeUserConfig' WLST command for details.

-report
Just prints out the actions without execution.

-targets
The list of targets to be stopped.

-target_type
The type of target to be stopped. Only supported target type is 'fmwServer'. This option is *deprecated*.

-silent
Invoke the operation in silent mode. Path to custom property file may be provided which will have required inputs as name-value pairs. If required inputs are not found, OPatch will exit with error message quoting the missing inputs.

PARAMETERS
The required parameter is targets

C:\app18\OPatch>opatch stop report

      Oracle Interim Patch Installer version 12.2.0.1.14

      Copyright (c) 2019, Oracle Corporation. All rights reserved.

      

      Oracle Home : C:\app18

      Central Inventory : C:\Program Files\Oracle\Inventory

      from :

      OPatch version : 12.2.0.1.14

      OUI version : 12.2.0.4.0

      Log file location : C:\app18\cfgtoollogs\opatch\opatch2019-01-17_22-12-45PM_1.log

      

      Unable to lock Central Inventory. OPatch will attempt to re-lock.

      Do you want to proceed? [y|n]

      n

      User Responded with: N

      OPatchSession cannot load inventory for the given Oracle Home C:\app18. Possible causes are:

      No read or write permission to ORACLE_HOME/.patch_storage

      Central Inventory is locked by another OUI instance

      No read permission to Central Inventory

      The lock file exists in ORACLE_HOME/.patch_storage

      The Oracle Home does not exist in Central Inventory

      

      UtilSession failed: Unable to lock Central Inventory. Stop trying per user-request?

      

      OPatch failed with error code = 73

UTIL

This operation invokes the chosen utilities on an ORACLE_HOME. This command does not support System Patch. SYNTAX
opatch util [ -help ] [ COMMAND ]

Use opatch util [ COMMAND ] -help to get help on a particular command.

COMMANDS
ApplySql
Apply sql, sql procedure related actions for patches, which are already applied using Apply or NApply operation.

CheckMinimumOpatchVersion
Check if patch is compatible with the given user input version.

CheckComponents
Check if the given patch is suitable for the Oracle Homes registered in the central inventory by components check.

Cleanup
Remove the backup for restore area of the given patch or for all the patches.

CopyListedDirs
Recursively copy all directories listed in ORACLE_HOME/.patch_storage/<ID>/rac/copy_dirs.txt to remote nodes.

CopyListedDirsTest
Recursively copy a single directory to remote nodes.

CopyListedFiles
Copy all files listed in ORACLE_HOME/.patch_storage/<ID>/rac/copy_files.txt to remote nodes.

CopyListedFilesTest
Copy a single file to remote nodes.

DisableOnlinePatch
Disable and remove the specified online patch(es) on the given database instances.

EnableOnlinePatch
Install and enable the specified online patch(es) on the given database instances.

GetPatchLevel
Return the patching level on Local Grid Home.

InstallOCM
Install and configure OCM.

IsShared
Returns true if running on shared environment, else it returns false.

LoadXML
Prompt for path/name of the XML file, then check if the XML is correct.

RemoveListedDirs
Recursively remote directories listed in ORACLE_HOME/.patch_storage/<ID>/rac/remove_dirs.txt on remote nodes.

RemoveListedDirsTest
Recursively remove a directory on remote nodes.

RemoveListedFiles
Remove files listed in ORACLE_HOME/.patch_storage/<ID>/rac/remove_files.txt on remote nodes.

RemoveListedFilesTest
Remove a single file on remote nodes.

RestoreOH
Restore the OracleHome to the previous state.

RollbackSql
Rollback sql, sql procedure related actions for patches, which are already rolled back using Rollback or NRollback operation.

RunAnyCommand
Run any command on remote nodes.

RunLocalMake
Invoke re-link on the local node. Commands are stored in ORACLE_HOME/.patch_storage/<ID>/make.txt.

RunRemoteMake
Invoke re-link on remote nodes. Commands are stored in ORACLE_HOME/.patch_storage/<ID>/rac/make_cmds.txt.

SaveConfigurationSnapshot
Save configuration snapshot of current GI home to specified file. ORACLE_HOME shall point to GI home. Default snapshot file is ORACLE_HOME/cfgtoollogs/opatch/sysconfig/configData.txt.

UpdateRemoteNodes
Propagate/Remove files/directories to/on remote nodes using files under ORACLE_HOME/.patch_storage/<ID>/rac/*.

UpdateOPatchVersion
Update the version of OPatch in the inventory of Oracle Home.

Verify
Using the defined ORACLE_HOME and given patch location via -ph, the program will check to make sure the patch was applied to the ORACLE_HOME.

Example: 'opatch util verify -ph /tmp/patchLoc'

c:\> set oracle_home=c:\app\oracle\product\12.1.0\dbhome_1

      

      c:\> cd c:\app\oracle\product\12.1.0\dbhome_1\OPatch\opatch util verify -ph /stage/patch

VERSION

Print the version of OPatch for a particular $ORACLE_HOME or display all OPatch version in the Central Inventory. SYNTAX
opatch version [-all] [-invPtrLoc <Path to oraInst.loc>] [-jre <LOC>] [-oh <ORACLE_HOME>] [-v2c <5-digit version> -oui_loc <Custom OUI Location> -ph <Patch Location> -ohs <list of Oracle Homes separated by commas] [-help] [-h]

OPTIONS
-all
This option displays versions of OPatch(es) of all Oracle Homes registered in the Central Inventory.

-invPtrLoc
Used to locate the oraInst.loc file. When the installation used the invPtrLoc flag. This should be the path to the oraInst.loc file.

-jre
This option tells OPatch to use JRE (java) from the specified location instead of the default location under Oracle Home.

-oh
The Oracle home to work on. This takes precedence over the environment variable ORACLE_HOME.

-v2c
The standard 5-digit version to compare. If this option is specified with an valid version which made by no more than 5 numbers separated by '.', those oracle homes with valid version will be break up to two parts, one is those oracle homes which have opatch version higher or equal to the value of this option, and the other is those with lower version.

-ph
The patch location from where the Minimum OPatch Version (if defined) will be picked. If a valid patch location is provided, will take the required minimum opatch version from the patch and set it as the standard opatch version to be compared to.

-ohs
List of Oracle Homes to be considered. Please provide them separated by commas.

-help (or) -h
Display valid options can be attached to this opereation.

PARAMETERS
This operation does not have any required parameters.

c:\> set oracle_home=c:\u01\orahome19\WINDOWS.X64_193000_db_home

      

      c:\> cd u01\orahome19\WINDOWS.X64_193000_db_home\OPatch>

      

      c:\u01\orahome19\WINDOWS.X64_193000_db_home\OPatch>opatch version

      

      OPatch Version: 12.2.0.1.15

      

      OPatch succeeded.

Patching the Opatch Utility

Patching OPATCH From time-to-time it may be necessary to patch the OPatch utility in order to apply the most recent patches. When you need to visit Oracle Support and look for patch 6880880. This patch page will let you select your version and operating system and download the most recent OPatch for your version.

Copy the a staging directory, unzip it to read the readme file and then follow the readme file's directions which will likely be to copy the .zip file to $ORACLE_HOME and unzip it there after first making a backup copy of the files currently in the $ORACLE_HOME/OPatch directory.