To patch each RAC database home and GI home, enter an opatch auto command in the following format:
#opatch auto <path to GI PSU>
To patch only the GI home, enter a command in the following format:
#opatch auto <path to GI PSU> -oh <GI_HOME>
To patch one or more RAC database homes, enter a command in the following format:
#opatch auto <path to GI PSU> -oh <path to RAC database1 home>[,<path of RAC database2 home>]
To roll back the GI PSU patch from the GI home, enter a command in the following format:
#opatch auto <path to GI PSU> -rollback -oh <path to GI home>
To roll back the patch from the RAC database home, enter a command in the following format:
#opatch auto <path to GI PSU> -rollback -oh <path to RAC database home>
To roll back the patch from the GI home and each RAC database home, enter a command in the following format:
#opatch auto -rollback <path to GI PSU>
For more information about opatch auto, see My Oracle Support Note 293369.1
Opatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run.
What is OCM (Oracle Configuration Manager)
The Oracle Configuration Manager (OCM) is a tool which proactively monitor the customers Oracle environment and provide this information to My Oracle Support (MOS). The Data collected from the customer environment is uploaded to Oracle Customer Configuration Repository and replicates this to My Oracle Support so that customer/support can view it. Additinaly MOS analyzes the Data collected and informs respective customer about alerts and advise health checks.
For more information refer Note:369619.1
Creating a ocm response file ($ORACLE_HOME/OPatch/ocm/bin/emocmrsp)
Create the response file and keep OCM turn OFF
% export ORACLE_HOME=/u01/app/oracle/11.2/db1
% $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /u02/unconfig.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: <<<< Press Enter/Return key and don’t provide any input >>>>
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y <<< type Y/Yes >>>
The OCM configuration response file (/u02/unconfig.rsp) was successfully created. <<
One-off Patch Conflict Detection and Resolution
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9655006
#opatch auto <UNZIPPED_PATCH_LOCATION> -oh <path to RAC database home1>[,<path to RAC database home2>,..]
Loading Modified SQL Files into the Database
SQL> @catbundle.sql psu apply
View the log files in $ORACLE_HOME/cfgtoollogs/catbundle location.
ext3 – Yahoo
ext4 – Google
Popularly used hints:
`SELECT /*+ GATHER_PLAN_STATISTICS */
SELECT /*+ INDEX */
SELECT /*+ OPTIMIZER_FEATURES_ENABLE */
SELECT /*+ FIRST_ROWS */
INSERT /*+ APPEND */
Links for further reading on hints :