本文共 6162 字，大约阅读时间需要 20 分钟。
一、安装前准备
1.环境描述 OS：[root@rac1 ~]# cat /etc/centos-releaseCentOS Linux release 7.5.1804 (Core)
数据库版本
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0 - ProductionNLSRTL Version 11.2.0.4.0 - Production
Opatch
p6880880_112000_Linux-x86-64.zip
Patch
p29255947_112040_Linux-x86-64.zip
上传路径
[root@rac1 /opt/soft]# ll总用量 1217668-rw-rw-r-- 1 root root 267 1月 28 2017 bundle.xml-rw-r--r-- 1 root root 1133472011 12月 31 17:30 p29255947_112040_Linux-x86-64.zip-rw-r--r-- 1 root root 113112960 12月 31 16:40 p6880880_112000_Linux-x86-64.zip-rw-rw-r-- 1 root root 151314 4月 20 2019 PatchSearch.xml-rw-rw-r-- 1 root root 91426 1月 28 2017 README.html-rw-rw-r-- 1 root root 50482 1月 28 2017 README.txt[root@rac1 /opt/soft]#
注意：根据readme提示需要 Opatch 版本在 11.2.0.3.21 及以上，升级前安装目录空闲空间必须有30 G 以上，这两个条件必须同时满足才可成功。
2.更新Opatch版本 两个节点使用grid和oracle分别更新Opatch版本 节点一grid [root@rac1 /opt/soft]# su - grid[root@rac1 /opt/soft]# mv /u01/app/11.2.0/grid/OPatch/ /u01/app/11.2.0/grid/OPatch_bak[root@rac1 /opt/soft]# unzip /opt/soft/p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid/[root@rac1 /opt/soft]# chown -R grid:oinstall /u01/app/11.2.0/grid/OPatch
节点一oracle
[root@rac1 /opt/soft]# mv /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch_bak[root@rac1 /opt/soft]# unzip /opt/soft/p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/dbhome_1/[root@rac1 /opt/soft]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/OPatch
验证
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch versionOPatch Version: 11.2.0.3.21OPatch succeeded.[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch versionOPatch Version: 11.2.0.3.21OPatch succeeded.
节点二操作相同（略）
二、GI打补丁 1.检查inventory有效性 [grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOMEOracle 临时补丁程序安装程序版本 11.2.0.3.21版权所有 (c) 2021, Oracle Corporation。保留所有权利。Oracle 主目录 ：/u01/app/11.2.0/grid主产品清单：/u01/app/oraInventory 来自 ：/u01/app/11.2.0/grid/oraInst.locOPatch 版本 ：11.2.0.3.21OUI 版本 ：11.2.0.4.0日志文件位置：/u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2021-01-15_17-15-05下午_1.logLsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2021-01-15_17-15-05下午.txt--------------------------------------------------------------------------------Local Machine Information::Hostname: rac1ARU platform id: 226ARU platform description:: Linux x86-64已安装的顶级产品 (1):Oracle Grid Infrastructure 11g 11.2.0.4.0此 Oracle 主目录中已安装 1 个产品。已安装的产品 (89):中间略...........此 Oracle 主目录中未安装任何临时补丁程序。--------------------------------------------------------------------------------OPatch succeeded.
2.生成ocm.rsp文（一定要注意ocm文件的属性和权限，grid和oracle用户要能访问）
[root@rac1 ~]# cd /u01/app/11.2.0/grid/OPatch/ocm/bin/ [root@rac1 ~]# ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - ProductionCopyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.Provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle Support Email address/User Name.Visit http://www.oracle.com/support/policies.html for details.Email address/User Name: ---回车You have not provided an email address for notification of security issues.Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes ---YESThe OCM configuration response file (ocm.rsp) was successfully created.
3.解压patch压缩包并赋予权限
[root@rac1 /opt/soft]# unzip p29255947_112040_Linux-x86-64.zip[root@rac1 /opt/soft]# chown -R grid:oinstall 29255947/[root@rac1 /opt/soft]# chmod -R 775 29255947/
4.执行命令打补丁
[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /opt/soft/29255947/ -oh /u01/app/11.2.0/grid/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
其他节点同样执行2、3、4步骤（略）
三、DB打补丁 1.root用户执行，每个节点分别执行 [root@rac1 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto /opt/soft/29255947/ -oh /u01/app/oracle/product/11.2.0/dbhome_1/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
2.Oracle用户更新数据库字典表信息（一个节点执行就行）
[root@rac1 ~]# su - oraclecd $ORACLE_HOME/rdbms/admin$ sqlplus / as sysdbaSQL>@catbundle.sql psu applySQL> @utlrp.sqlSQL > @dbmsjdev.sqlSQL > exec dbms_java_dev.disable$ rman catalog username/password@aliasRMAN> UPGRADE CATALOG;
3.检查数据库版本
Oracle用户 [oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory[oracle@rac1 ~]$ sqlplus / as sysdbacol action_time for a32col action for a10col namespace for a10col version for a10col BUNDLE_SERIES for a10col comments for a30set line 300select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS-------------------------------- ---------- ---------- ---------- ---------- ---------- ------------------------------18-JAN-21 02.41.08.784663 PM APPLY SERVER 11.2.0.4 190416 PSU PSU 11.2.0.4.190416
四、rollback
[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /opt/soft/29255947/ -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp unable to get oracle owner for --有这个报错是因为是中文环境，算是opatch的bug[root@rac1 ~]# echo $LANGzh_CN.UTF-8[root@rac1 ~]# export LC_ALL=en_US.UTF8[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /opt/soft/29255947/ -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
一个节点执行
[oracle@rac1 ~]$ cd $ORACLE_HOME/rdbms/adminSQL> @catbundle_PSU_RACDB11G_ROLLBACK.sqlSQL> @utlrp.sql
验证
SQL> select * from dba_registry_history;ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS-------------------------------- ---------- ---------- ---------- ---------- ---------- ------------------------------18-JAN-21 02.41.08.784663 PM APPLY SERVER 11.2.0.4 190416 PSU PSU 11.2.0.4.19041618-JAN-21 04.03.24.660823 PM ROLLBACK SERVER 11.2.0.4 190416 PSU PSU 11.2.0.4.190416
转载地址：http://mxthz.baihongyu.com/