Saturday, 23 December 2017

STEPS FOR APPLYING PATCHSET


11. release version
2.components
0.application
1.patchs
0.platform

Differences between PSU , CPU and SPU and how to install
========================================================

#Critical Patch Update (CPU) --> Release of security fixes each quarter instead the cumulative database security patch for the quarter.

#Patch Set Updates (PSU) --> Cumulative patches that include both the security fixes and priority fixes.  They are "version upgrades"
modifying the las number of version (11.2.0.1.1, 11.2.0.1.2,...).

#Security Patch Update (SPU) --> It is the new terminology of CPU (From October 2012) . SPU's can't be applied if any PSU's have been
 applied, unless your database is upgraded with a new base version.


==> How to apply opatch tool to upgrade patch. ***PSU APPLY***
______________________________________________________________

==backup existing opatch folder

1.go to oracle home location and move existing opatch opatch_old(old opatch)

2.unzip the patch set under oracle home folder

3.set path variables in bash_profile

    Export path=$path:/usr/ccs/bin

4.bring down the database and listener

5.execute opatch apply from softwares location


==> Post Installation instruction
=============================

6.connect to sysdba with /nolog

$ sqlplus /nolog

Sql> connect /as sysdba

Sql> startup

7.sql> @catbundle.sql (psu will be apply)

sql> quit

8.check opatch lsinventory from OS level "under $

cd $ORACLE_HOME/OPatch"

==================completion of PSU apply=====================================

No comments:

Post a Comment