PSU PATCH ON 12C ORACLE DATABASE
--------------------------------------------------------
Patching: To fix bugs in previous database software releases in the oracle database software
Two types Of Patches
---------------------------
Critical Patch Update(CPU) ,now known as Security Patch Update(SPU)
Patch set Upadte (PSU) will aplly these patches using OPatch tool
Opatch is the ----> Oracle Patching Tool
will download from metalink.oracle.com
support.oracle.com
How Frequently will release ----->quarterly
will backup level0 before patching( full database backup)
we need downtime to apply the patching first will apply in development then will proceed in production
backout time----->plan---->atleast ---->1hr --4 hrs
Finding Version of Database
----------------------------------
sql>select banner from v$version; (db version)
sql>select parameter compatible;
9i,10g,11g,12c,18c,19c
we can list ----> $ OPatch ls inventory
Significance of Version
-----------------------------
12.1.0.1.0-------> Release 1 ------>12cR1
12.2.0.1.0-------> Release 2 ------>12cR2
9.1.0.1.0--------->Release 1
9.2.0.1.0---------->Release2
i-------->Internet from 8i ,9i
g-------->grid---->To manage Resources Automatically
c-------->Cloud multitenant feature
12-------->Main Release Number
1---------> Maintanance Release Number
0--------->Application Release Number
1--------->Patch set Number
0--------->Platform Release number
How do i apply in PSU patch in oracle database
---------------------------------------------------------
1)Download the patch from Oracle support Portal
2)Validate the Patch Version
3)Copy the zip to ORACLE_HOME
4)Remove the existing OPatch directory
5)Unzip the Zip File
6)Copy and Unzip the PATCH zip file
7)Check the conflict again ORACLE_HOME
Lets Start the Process how to apply psu patch on 12 c database
---------------------------------------------------------------------------
$ ORACLE_HOME/OPatch/opatch version
OPatch version :12.1.0.1.3
$ ls -lrt
cp p24006101-121020_linux_x86_64.zip $ ORACLE_HOME
$ cd $ ORACLE_HOME
ls -lrt
OPatch
$ mv OPatch OPatch_27jul2020
$unzip p24006101-121020_linux_x86_64.zip
$ ORACLE_HOME/OPatch/opatch version
OPatch version ----->12.2.0.1.8
OPatch succeded
$ ps - ef |grep smon
ora--->smon-->proddb
$ ps - ef |grep tns
LISTENER--->proddb
$lsnrctl stop LISTENER_PRODB
$sqlplus '/as sysdba'
shut immediate
exit
$ ps -ef |grep ORA
cd / u03
ls -ltr
$unzip p24006101-121020_linux_x86_64.zip
(The moment you unzip the file we 24006101 directory created like this they will ask like wheter you want to ready the apply the patch db is to shutdown and whether the patch applied to local machine or not Opatch ls inventory it shows the what time what patch will applied 11 g we used cat bundle in sql here 12 c os prompt os level dba_registry_sqlplus database version)
ls -ltr
24006101
cd 24006101
$ ORACLE_HOME/OPatch/opatch apply (it will ask like interactive i mentioned in above)
--->y
---->y
--->y
Composite Patch 2406101 sucessfull applied
$ ORACLE_HOME/OPatch/opatch ls inventory
sqlplus '/as sysdba'
startup
exit
$cd $ ORACLE_HOME/OPatch
$ ./datapatch - verbose
to list the patches applied
$cd ORACLE_HOME/OPatch
$ ./OPatch lsinventory
patch 24006101 apply sucess at databasee level
sqlplus '/as sysdba'
sql>select * from dba_registry_sqlplus;
$lsnrctl start
Note : Info on psu patch update it may be differ from your environment like production,testing,development,and directories
THANK YOU FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOE ME
