rac升级opatch包

原创

mb611a2e88042f6 2021-08-17 11:50:08 博主文章分类：Oracle ©著作权

文章标签 oracle linux sed root用户 perl 文章分类 运维

©著作权归作者所有：来自51CTO博客作者mb611a2e88042f6的原创作品，请联系作者获取转载授权，否则将追究法律责任

补丁包

ORACLE的补丁包查找

id为1454618.1的文档直接加载进入。

OPatch下载地址：

https://updates.oracle.com/download/6880880.html

网上指南：

http://www.mamicode.com/info-detail-1161159.html

Opatch包

p21523375_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip

复制到ORACLE目录下

/home/oracle/opatch_toad/

1. 重命名原有的Opatch包

使用root 用户

到grid的ORACLE_HOME目录下，

执行如下

#mv Opatch Opatchbk

到oracle的ORACLE_HOME目录下，

执行如下

#mv Opatch Opatchbk

PS:可以通过 ./patch version查看opatch补丁如下：

[grid@rac1 OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

1. 更新GRID用户的OPATCH

使用root用户

cd opatch_toad/

unzip p6880880_112000_Linux-x86-64.zip

mv OPatch /opt/oracle/grid_home/OPatch

ll /opt/oracle/grid_home/ | grep OPatch

chown -R grid:oinstall /opt/oracle/grid_home/OPatch

使用grid用户测试

[grid@rac1 OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

1. 更新ORACLE用户的OPATCH

同上

使用root用户

unzip p6880880_112000_Linux-x86-64.zip

mv OPatch /opt/oracle/db_base/db_home/OPatch

ll /opt/oracle/db_base/db_home/ | grep OPatch

chown -R oracle:oinstall /opt/oracle/db_base/db_home/OPatch

使用ORACLE用户测试

[oracle@rac1 OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

分别在节点1和节点2分别生成ocm.rsp文件

su - oracle

cd /home/oracle/

/opt/oracle/db_base/db_home/OPatch/ocm/bin/emocmrsp

开始升级GI PSU软件包
1. GRID用户升级

#chown -R grid:oinstall /home/grid/opatch_toad/p21523375_112040_Linux-x86-64.zip

#su - grid

#cd /home/grid/opatch_toad/

# unzip p21523375_112040_Linux-x86-64.zip

1. 1. 兼容性测试

使用GRID用户

[grid@rac1 grid_home]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/21523375/21352649 -oh $ORACLE_HOME

Oracle Interim Patch Installer version 11.2.0.3.12

PREREQ session

Oracle Home : /opt/oracle/grid_home

Central Inventory : /opt/oracle/oraInventory

from : /opt/oracle/grid_home/oraInst.loc

OPatch version : 11.2.0.3.12

OUI version : 11.2.0.4.0

Log file location : /opt/oracle/grid_home/cfgtoollogs/opatch/opatch2016-03-30_00-46-06AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@rac1 grid_home]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/21523375/21352635 -oh $ORACLE_HOME

[grid@rac1 grid_home]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/21523375/21352642 -oh $ORACLE_HOME

1. 1. 开始升级执行

使用root用户进行升级执行(集群需要启动)

[root@rac1 grid_home]# /opt/oracle/grid_home/OPatch/opatch auto /home/grid/21523375 -oh /opt/oracle/grid_home -ocmrf /home/oracle/ocm.rsp

Executing /opt/oracle/grid_home/perl/bin/perl /opt/oracle/grid_home/OPatch/crs/patch11203.pl -patchdir /home/grid -patchn 21523375 -oh /opt/oracle/grid_home -ocmrf /home/oracle/ocm.rsp -paramfile /opt/oracle/grid_home/crs/install/crsconfig_params

This is the main log file: /opt/oracle/grid_home/cfgtoollogs/opatchauto2016-03-30_01-15-03.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/opt/oracle/grid_home/cfgtoollogs/opatchauto2016-03-30_01-15-03.report.log

2016-03-30 01:15:03: Starting Clusterware Patch Setup

Using configuration parameter file: /opt/oracle/grid_home/crs/install/crsconfig_params

Stopping CRS...

Stopped CRS successfully

patch /home/grid/21523375/21352635 apply failed for home /opt/oracle/grid_home

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

1. 1. 检查升级情况

[grid@rac1 OPatch]$ ./opatch lsinv

Oracle Interim Patch Installer version 11.2.0.3.12

Oracle Home : /opt/oracle/grid_home

Central Inventory : /opt/oracle/oraInventory

from : /opt/oracle/grid_home/oraInst.loc

OPatch version : 11.2.0.3.12

OUI version : 11.2.0.4.0

Log file location : /opt/oracle/grid_home/cfgtoollogs/opatch/opatch2016-03-30_01-28-16AM_1.log

Lsinventory Output file location : /opt/oracle/grid_home/cfgtoollogs/opatch/lsinv/lsinventory2016-03-30_01-28-16AM.txt

-------------------------------------------------------------------------------

Local Machine Information::

Hostname: rac1

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes

Local node = rac1

Remote node = rac2

--------------------------------------------------------------------------------

OPatch succeeded.

1. ORACLE用户升级

#cd /home/oracle/opatch_toad/

# unzip p21523375_112040_Linux-x86-64.zip

1. 1. 检查

[oracle@rac1 opatch_toad]$ /opt/oracle/db_base/db_home/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/opatch_toad/21523375/21352635 -oh $ORACLE_HOME

1. 1. 安装执行

使用root用户

[root@rac1 oracle]# /opt/oracle/db_base/db_home/OPatch/opatch auto /home/oracle/opatch_toad/21523375/ -oh /opt/oracle/db_base/db_home -ocmrf /home/oracle/ocm.rsp