Showing posts with label Patching Oracle Database. Show all posts
Showing posts with label Patching Oracle Database. Show all posts

Tuesday, July 18, 2023

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


Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...