环境描述
11.2.0.3.0


1.下载补丁


psu 20760997 (11.2.0.3.15)


unzip p20760997_112030_Linux-x86-64.zip 


2.下载最新 oppach


6880880


unzip p6880880_112000_Linux-x86-64.zip 


替换 Opatch


3.关监听,关数据库


lsnrctl stop listener ;




SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.




4.验证


[oracle@mestest OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/20760997/
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-08-28_23-23-48PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.


5.验证


[oracle@mestest OPatch]$ ./opatch prereq CheckActiveFilesAndExecutables -ph /u01/20760997/
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-08-28_23-35-16PM_1.log


Invoking prereq "checkactivefilesandexecutables"


Prereq "checkActiveFilesAndExecutables" for patch 13343438 passed.


Prereq "checkActiveFilesAndExecutables" for patch 13696216 passed.


Prereq "checkActiveFilesAndExecutables" for patch 13923374 passed.


Prereq "checkActiveFilesAndExecutables" for patch 14275605 passed.


Prereq "checkActiveFilesAndExecutables" for patch 14727310 passed.


Prereq "checkActiveFilesAndExecutables" for patch 16056266 passed.


Prereq "checkActiveFilesAndExecutables" for patch 16619892 passed.


Prereq "checkActiveFilesAndExecutables" for patch 16902043 passed.


Prereq "checkActiveFilesAndExecutables" for patch 17540582 passed.


Prereq "checkActiveFilesAndExecutables" for patch 18031683 passed.


Prereq "checkActiveFilesAndExecutables" for patch 18522512 passed.


Prereq "checkActiveFilesAndExecutables" for patch 19121548 passed.


Prereq "checkActiveFilesAndExecutables" for patch 19769496 passed.


Prereq "checkActiveFilesAndExecutables" for patch 20299017 passed.


Prereq "checkActiveFilesAndExecutables" for patch 20760997 passed.


OPatch succeeded.


如果报错可以执行   slibclean 清理一下模块内存


6.应用补丁前备份一下数据库软件


 tar -cvf /u01/db11.tar /u01/app/oracle/product/11.2.0/dbhome_1


7.应用补丁


./opatch apply /u01/20760997/


还要打个   OJVM PSU


8.看一下补丁日志


cat /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_MESTEST_APPLY_2017Aug28_23_45_46.log | more


9.回滚补丁


./opatch rollback -id 20760997


10.看一下回退日志


cat /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/20760997_Aug_28_2017_23_54_23/rollback2017-08-28_23-54-23PM_1.log | more