1-Lastest version For Optach.
2-PSU Patch that you want to apply.
Steps:
$ORACLE_HOME/OPatch/opatch versionOutput will be:
Invoking OPatch 11.2.0.1.7
OPatch Version: 11.2.0.1.7
OPatch succeeded
1-you need to Update latest version For Optach, to do this :
cd $ORACLE_HOME
cp -r Optach/ /u01/backup/Optach
**make sure you in ORACLE_HOME
rm -rf $ORACLE_HOME/Optach
unzip Optach_that_you_download_from_MOS inside $ORACLE_HOME.
Patch Number :6880880
2-Check Optach After Doing Above Steps :
$ORACLE_HOME/OPatch/opatch versionOutput will be:
Invoking OPatch 11.2.0.3.0
OPatch Version: 11.2.0.3.0
OPatch succeeded
3-Apply PSU Patch By Doing the Following, for example :
unzip p13923374_11203_.zip
cd 13923374
opatch apply
Answer the question that you been asked by Oracle
4- Post Installation Steps :
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
Which patch do we need to apply first CPU or PSU
LikeLike
“Oracle Critical Patch Updates (CPU) will now contain both the PSU and CPU, so the DBA may choose to apply just the CPU or apply all patches in the PSU patch bundle (which includes additional fixes)”Read this document 1446582.1 Once a PSU is applied, only PSUs can be applied in future quarters until the database is upgraded to a new base version
LikeLike
Hi mustafa hope you are doing well.In some Docs i saw they started database in UPGRADE mode and done View Recompilation after @catbundle.sql psu apply..Is these 2 steps required or optional…Thank's in advance
LikeLike
Confirm whether we need to apply same PSU on grid home as well or we need to download seperate PSU?
LikeLike
Nice post..Will you please let me know what are the Pre-requisite for patching.Thanks
LikeLike
Salam Mohammed, It's already mentioned in the first two lines in this post 🙂
LikeLike