Monday, November 5, 2012

Oracle 11g Online Patching

In 11g a new feature is the Online Patching of an Oracle Home with no DB Instance Shutdown.You will know that a patch can be from its README file.



cd 11111111

$ORACLE_HOME/OPatch/opatch apply online -connectString mySID:sys:syspass

The previous commands will apply online the 11111111 to SID : mySID

If you have another SID running on the same home then you must issue the following command to enable the patch.

$ORACLE_HOME/OPatch/opatch util enableonlinepatch -connectString mySID2:sys:syspass -id 11111111

In order to uninstall an online patch run from a single instance :

$ORACLE_HOME/OPatch/opatch rollback -id 11111111 -connectString mySID:sys:syspass 

In order to uninstall an online patch run from multiple instances :

$ORACLE_HOME/OPatch/opatch rollback -id 11111111 -connectString mySID:sys:syspass,mySID2:sys:syspass 


If you do not know in how many SIDs an online patch has been applied issue the command to remove it from the first instance and then opatch will report if its has been applied to other instances. In this situation, cancel the opatch session (answer n in the question if you want to proceed) and run the command for all the instances as decsribed above.

No comments:

Post a Comment