2) set JAVA_HOME environment variable.
OPatch requires JDK 1.4 or higher to work properly. JRE is installed using JDK.

$ export JAVA_HOME=/home/jdk/bin/java

3) set proper lsinventory using Opatch using following command.

$ OPatch lsinventory

4) Go to unzipped directory of patch using following command.

cd $ORACLE_HOME/OPatch

5) apply interim or one-off patch of Oracle.

$ /opatch apply /u01/patch/8708077

It will be applied your given one-off interim patch.

Log file of Opatch utility of Oracle:

OPatch maintains logs for all apply, rollback, and lsInventory operations. The log files are located in /cfgtoollogs/opatch directory. Each log file will be tagged with the timestamp of the operation. Log files are named as opatch__.log. Each time OPatch is executed a new log file is created.

Sample:
opatch_09-22-2009_20-05-00.log

How to rollback one-off interim patch whenever find problem:

$ opatch rollback /u01/patch/8708077

OR

$ OPatch/opatch rollback -id

For more detail and troubleshooting of opatch please refer oracle documentation or wait to publish another post.

Subscribe

Get Oracle DBA Job Quickly

About US

This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.