11g r2 rac 11.2.0.2升级11.2.0.2.3 [PSU patch 12419353]

最新推荐文章于 2020-07-06 10:48:49 发布

原创最新推荐文章于 2020-07-06 10:48:49 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

本文提供了Oracle 11.2 PSU（Patch Set Update）11.2.0.2.3的手动安装步骤，包括停止服务、卸载ACFS文件系统、使用OPatch应用补丁等关键操作，并记录了安装过程中遇到的问题及其解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

下载的补丁号为12419353(里面包含DB的11.2.0.2.3）

在这里选择手动打

操作前记得下载最先的opatch工具替换原$ORACLE_HOME/OPatch这个文件夹的内容(包含grid,oracle)

首先选择1节点

停止服务

#库服务

su - grid

srvctl stop database -d racdb

#集群服务资源

su - root

crsctl stop crs

#UNMOUNT ACFS文件系统

#查询服务名

[grid@racnode1 ~]$ crs_stat |grep acfs
NAME=ora.registry.acfs
TYPE=ora.registry.acfs.type

#UNMOUNT

crsctl stop res ora.registry.acfs -n racnode1

su - root

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
/u01/app/11.2.0/grid/crs/install/roothas.pl -unlock --单实例情况

su - grid

/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/patc/12419353

/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/patc/12419331

su - oracle

/home/grid/patc/12419353/custom/server/12419353/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/dbhome_1

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/dbhome_1 -local /home/grid/patc/12419353/custom/server/12419353

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/dbhome_1 -local /home/grid/patc/12419331

然后是2节点

#集群服务资源

su - root

crsctl stop crs

#UNMOUNT ACFS文件系统

#查询服务名

[grid@racnode1 ~]$ crs_stat |grep acfs
NAME=ora.registry.acfs
TYPE=ora.registry.acfs.type

#UNMOUNT

crsctl stop res ora.registry.acfs -n racnode2

su - root

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
/u01/app/11.2.0/grid/crs/install/roothas.pl -unlock --单实例情况

su - grid

/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/patc/12419353

/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/patc/12419331

su - oracle

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/dbhome_1 -local /home/grid/patc/12419331

最后执行（可选1节点)

#启动集群相关资源

su - root

crsctl start crs

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

#RMAN因没有安装CATALOG未执行

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

验证升级结果
select * from sys.registry$history

BUNDLE_SERIES
------------------------------
PSU 11.2.0.2.3

 [oracle@racnode1 OPatch]$  ./opatch lsinventory --修复的BUG

出现问题及解决

(1)

由于在2节点时忘停止服务执行过程中用CTRL+C中断服务

UtilSession failed: Lock file left by a different patch, OPatch will not try re-using the lock file.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-01-22_11-12-31AM_1.log

OPatch failed with error code 73

询问了MA CLEAN解决

cd $ORACLE_HOME/.patch_storage

ls -l

rm patch_locked

(2)

ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
ins_srvm.mk:31: warning: ignoring old commands for target `libsrvm11.so'
ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'
ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'
ins_srvm.mk:74: warning: overriding commands for target `libsrvmhas11.so'
ins_srvm.mk:37: warning: ignoring old commands for target `libsrvmhas11.so'

--MOS记录可以安全忽略