online patching apply and rollback

Make sure the patch is online patchable. See read me document for the patch in MOS.

It is always good to install patches offline. If your instance cannot be down and you need to fix a bug urgently use online patch first and rollback online patch when you get a maintenance window and reapply using offline mode

first check pre reqs

[DDWH1]oracle@xxx2:/home/oracle/sv/patch/16444583> /u01/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Apply patch

oracle@xxx2:/home/oracle/sv/patch/16444583> /u01/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch apply online -connectString DBNAME:sys:password

If its a rac after password put anotehr colon and add hostname.

Make sure you get instance name right case sensitive

Do a ps -ef |grep pmon and paste the exact name there. Else it says instance is down or not found.


For roll back:

oracle@xxx2:/home/oracle/sv/patch/16444583> /u01/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch rollback -id 16444583 -connectString DBNAME:sys:password


To apply offline

Shutdown all services
goto patch folder and

opatch apply


check in lsinventory

if its a online patch it will mention after the patch number