DESCRIPTION This operation is used to Apply a set of patches at a time. Use -silent to apply the patches in silent mode. SYNTAX opatch napply [patch_location] [-id comma-separated list of patch IDs] [ -all_nodes ] [-connectString ] [-delay ] [ -force ] [-idFile [-opatch_init_end] ] [-invPtrLoc ] [-jre ] [ -local ] [ -local_node ] [-minimize_downtime ] [-no_bug_superset ] [-no_inventory ] [-no_relink] [-no_sysmod] [-ocmrf ] [-oh ] [ -phBaseDir ] [ -phBaseFile ] [-post [-opatch_post_end] ] [-pre [-opatch_pre_end] ] [ -property_file ] [-ptlConnect ] [-ptlPassword ] [-ptlSchema ] [ -remote_nodes ] [-retry ] [-runSql] [-silent ] [-sqlScript ] [-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 If a conflict exist which prevents the patch from being applied, the -force flag can be used to apply the patch. OPatch will remove all the conflicting patches before applying the current patch. In case of conflict among the patches to be applied, the non conflicting patches will be applied. -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. -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 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'. -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. -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 ' to apply all patches under directory 'opatch napply -id 1,2,3' to apply patches 1, 2, and 3 which are present under directory 'opatch napply -skip_subset -skip_duplicate' to apply all patches under directory. OPatch will skip duplicate patches and subset patches (patches under that are subsets of patches installed in the Oracle Home) 'opatch napply -id 1,2,3 -skip_subset -skip_duplicate' to apply patches 1, 2, and 3 which are under diretory. OPatch will skip duplicate patches and subset patches (patches under that are subsets of patches installed in the Oracle Home) 'opatch napply -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