Sunday, October 03, 2010

OPatch

OPatch Apply

Pre-implementation
1.  download the patch  
2.  unzip

Outage
1. Stop the listener
2. Stop all instances on the ORACLE_HOME on which patch is going to be applied
4. Set your environment to the ORACLE_HOME.
5. cd   patch number directory
6. Set your path to include the OPatch directory


     export PATH=$ORACLE_HOME/OPatch:$PATH

     Note : Check the OPatch version. Get the latest Version from Metalink
7. Apply the patch  
  On linux  
     option # 1   
         opatch apply –local
     option # 2   
         opatch napply –local –skip_subset –skip_duplicate

 on solaris 
      opatch apply –local OPatch.SKIP_VERIFY=true

8. Verify that all is well

     opatch lsinventory

9. Start all the instances
10. Wait until all instances have started.
11. Start the listener
12. check connectivity

Hope this help. Regards Rupam