oracle11单机190416补丁安装

Oracle 11GR2 RAC 最新补丁 190416 安装指导
https://mp.weixin.qq.com/s?__biz=MzU2NzQ0MTAwMQ==&mid=2247484420&idx=1&sn=88ac6bbe272542c1a1dd0c3e5752b411&scene=21#wechat_redirect
https://cloud.tencent.com/developer/article/1462096

【补丁】Oracle11gR2补丁更新（PSU）
https://cloud.tencent.com/developer/article/1816705?from=article.detail.1665260

[oracle@localhost ~]$export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@localhost ~]$unzip p29255947_112040_Linux-x86-64.zip -d /home/oracle/patch
[oracle@localhost ~]$cd /home/oracle/patch/29255947/29141056
[oracle@localhost ~]$opatch apply
#输入两次y安装补丁
Composite patch 29141056 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-08-25_14-14-50PM_1.log

OPatch completed with warnings.

[oracle@localhost ~]$opatch napply /home/oracle/patch/29255947/29141201/custom/server -local -oh /u01/app/oracle/product/11.2.0/dbhome_1/ -id 29141201
#输入两次y安装补丁
OPatch succeeded.
复制

#更新数据库字典表
[oracle@localhost ~]$cd $ORACLE_HOME/rdbms/admin
[oracle@localhost ~]$sqlplus / as sysdba
SQL> startup
SQL> @catbundle.sql psu apply
SQL> @utlrp.sql
SQL> @dbmsjdev.sql
SQL> exec dbms_java_dev.disable
复制

#检查升级版本
$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'
sqlplus / as sysdba
col action_time for a32
col action for a10col namespace for a10
col version for a10col BUNDLE_SERIES for a10
col comments for a30
set lin 300
select * from dba_registry_history; 
ACTION_TIME                      ACTION     NAMESPACE  VERSION            ID BUNDLE_SER COMMENTS
-------------------------------- ---------- ---------- ---------- ---------- ---------- ------------------------------
*************************************省略内容*******************************************
col ACTION_TIME for a35
col COMMENTS for a30
select ACTION_TIME,COMMENTS from registry$history;
ACTION_TIME                    COMMENTS
------------------------------ ------------------------------
24-AUG-13 12.03.45.119862 PM   Patchset 11.2.0.2.0
19-JAN-16 12.10.26.734097 AM   Patchset 11.2.0.2.0
26-JAN-19 10.45.57.188831 AM   PSU 11.2.0.4.180116
26-JAN-19 11.52.32.664077 AM   PSU 11.2.0.4.19041611.2.0.4.190416
复制

#冲突检查
unzip p30298532_112040_<platform>.zip
cd 30298532
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
复制

#补丁卸载
#部分情况下需要卸载补丁，流程：

opatch rollback -id 29255947(补丁号)

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID>_ROLLBACK.sql
复制