Oracle DB Patching Steps

Hint:- first shutdown database and listener 

1. copy patch zip and latest opatch utility  to desired directory 

2. unzip patch zip file 

3. cp opatch_zip file to $ORACLE_HOME/   

4. cd $ORACLE_HOME/ 

5. mv OPatch OPatch_old 

6. unzip opatch_zip 

7. you will see new OPatch directory in $ORACLE_HOME/

8. cd OPatch/ 

9. run  ./opatch version 

10. cd to patch_zip directory 

11. cd 32435354/ 

12. 32435354~]$  $ORACLE_HOME/OPatch/opatch apply 

13. if unwanted happens then rollback changes using below 

32435354~]$  $ORACLE_HOME/OPatch/opatch rollback  -id 32435354

14. In the Final step run datapatch utility after starting database and listener 

$ORACLE_HOME/OPatch/datapatch -verbose 

if possible open all pdbs (pluggable databases)

select * from v$pdbs;

alter pluggable database all open;

alter pluggable database pdb_name save state;

alter pluggable database all save state ;

GRID PATCHING :-

cd patch_directory then execute below:-

make sure you've exported all oracle environment variables ORACLE_HOME,ORACLE_SID,PATH, 

LD_LIBRARY_PATH,etc. 

$ORACLE_HOME/OPatch/opatchauto apply -oh $ORACLE_HOME

$ORACLE_HOME/OPatch/opatchauto apply  /path/to/patch_directory  -oh  $ORACLE_HOME