11g RAC 自动升级 PSU

原创

钱若梨花落 2022-09-26 13:32:47 博主文章分类：oracle ©著作权

文章标签 oracle sql linux 文章分类 运维

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

[oracle@uudb1 ~]$ cd $ORACLE_HOME
[oracle@uudb1 db_1]$ cd OPatch/
[oracle@uudb1 OPatch]$ ls
crs docs emdpatch.pl jlib ocm opatch opatch.bat opatchdiag opatchdiag.bat opatch.ini opatch.pl opatchprereqs oplan
[oracle@uudb1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[oracle@uudb1 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.

[grid@uudb1 ~]$ cd $ORACLE_HOME
[grid@uudb1 grid]$ cd OPatch/
[grid@uudb1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[grid@uudb1 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.
[grid@uudb1 OPatch]$

[oracle@uudb2 ~]$ cd $ORACLE_HOME
[oracle@uudb2 db_1]$ cd OPatch/
[oracle@uudb2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[oracle@uudb2 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.

[grid@uudb2 ~]$ cd $ORACLE_HOME
[grid@uudb2 grid]$ cd OPatch/
[grid@uudb2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[grid@uudb2 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.

----升级---节点1
[oracle@uudb1 OPatch]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[oracle@uudb1 OPatch]$ cp /soft/p6880880_112000_Linux-x86-64.zip ./..
[oracle@uudb1 OPatch]$ cd ..
[oracle@uudb1 db_1]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@uudb1 db_1]$ chmod 755 OPatch
[oracle@uudb1 db_1]$ cd OPatch
[oracle@uudb1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

--root用户
[root@uudb1 soft]# cd /u01/11.2.0
[root@uudb1 11.2.0]# pwd
/u01/11.2.0
[root@uudb1 11.2.0]# chown grid.oinstall grid/

[root@uudb1 soft]# cp p6880880_112000_Linux-x86-64.zip /u01/11.2.0/grid/
[root@uudb1 soft]# chown grid.oinstall /u01/11.2.0/grid/p6880880_112000_Linux-x86-64.zip

--grid 用户
[grid@uudb1 grid]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[grid@uudb1 grid]$ unzip p6880880_112000_Linux-x86-64.zip

---升级节点2
[oracle@uudb2 OPatch]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[oracle@uudb2 OPatch]$ cd ..
[oracle@uudb2 db_1]$ cp /soft/p6880880_112000_Linux-x86-64.zip ./
[oracle@uudb2 db_1]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@uudb2 db_1]$ chmod 755 OPatch
[oracle@uudb2 db_1]$ cd OPatch
[oracle@uudb2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.
[oracle@uudb2 OPatch]$

---root用户
[root@uudb2 ~]# cd /u01/11.2.0
[root@uudb2 11.2.0]# ll -d grid/
drwxr-xr-x 68 root oinstall 4096 Mar 14 11:56 grid/
[root@uudb2 11.2.0]# chown grid.oinstall grid/
[root@uudb2 11.2.0]# cp /soft/p6880880_112000_Linux-x86-64.zip /u01/11.2.0/grid/
[root@uudb2 11.2.0]# chown grid.oinstall /u01/11.2.0/grid/p6880880_112000_Linux-x86-64.zip

--grid
[grid@uudb2 OPatch]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[grid@uudb2 OPatch]$ cd $ORACLE_HOME
[grid@uudb2 grid]$ unzip p6880880_112000_Linux-x86-64.zip

[grid@uudb2 grid]$ chmod 755 OPatch -R
[grid@uudb2 grid]$ cd OPatch
[grid@uudb2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.
[grid@uudb2 OPatch]$

----

----下载对应PSU+SPU 补丁包
--下载路径
http://www.oracle.com/technetwork/topics/security/alerts-086861.html

p28429134_112040_Linux-x86-64.zip

---生成对应文件/tmp/ocm.rsp
--两个节点分别生成这个文件
grid 用户
生成ocm.rsp文件
cd /u01/11.2.0/grid/OPatch/ocm/bin
./emocmrsp -output /tmp/ocm.rsp
chmod 775 /tmp/ocm.rsp

grid用户--检查
cd $ORACLE_HOME/OPatch
./opatch lsinventory -detail -oh /u01/11.2.0/grid

root用户---两个节点
cd /soft
unzip p28429134_112040_Linux-x86-64.zip

修改补丁目录权限(两个节点)
cd /soft/
chown -R grid:oinstall 28429134/
chmod 755 28429134/

root用户执行,分别在两个节点执行，先执行节点1、在执行节点2

grid 用户家目录 auto PSU解压路径 -ocmrf grid用户生成ocm.rsp文件的路径

/u01/11.2.0/grid/OPatch/opatch auto /soft/gpsu/28429134 -ocmrf /tmp/ocm.rsp

[root@uudb1 gpsu]# /u01/11.2.0/grid/OPatch/opatch auto /soft/gpsu/28429134 -ocmrf /tmp/ocm.rsp
Can't locate Switch.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /u01/11.2.0/grid/OPatch/crs/auto_patch.pl line 2734.
BEGIN failed--compilation aborted at /u01/11.2.0/grid/OPatch/crs/auto_patch.pl line 2734.

--上面报错解决办法
yum install -y perl-Switch

---节点1执行
/u01/11.2.0/grid/OPatch/opatch auto /soft/28429134 -ocmrf /tmp/ocm.rsp

[root@uudb1 soft]# /u01/11.2.0/grid/OPatch/opatch auto /soft/28429134 -ocmrf /tmp/ocm.rsp
Executing /u01/11.2.0/grid/perl/bin/perl /u01/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -ocmrf /tmp/ocm.rsp -paramfile /u01/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/11.2.0/grid/cfgtoollogs/opatchauto2019-03-14_15-29-56.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/11.2.0/grid/cfgtoollogs/opatchauto2019-03-14_15-29-56.report.log

2019-03-14 15:29:56: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /soft/28429134/27735020/custom/server/27735020 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /soft/28429134/28204707 apply successful for home /u01/app/oracle/product/11.2.0/db_1

Stopping CRS...
Stopped CRS successfully

patch /soft/28429134/27735020 apply successful for home /u01/11.2.0/grid
patch /soft/28429134/28204707 apply successful for home /u01/11.2.0/grid
patch /soft/28429134/28204939 apply successful for home /u01/11.2.0/grid

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

---节点2执行

/u01/11.2.0/grid/OPatch/opatch auto /soft/28429134 -ocmrf /tmp/ocm.rsp

[root@uudb2 soft]# /u01/11.2.0/grid/OPatch/opatch auto /soft/28429134 -ocmrf /tmp/ocm.rsp
Executing /u01/11.2.0/grid/perl/bin/perl /u01/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -ocmrf /tmp/ocm.rsp -paramfile /u01/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/11.2.0/grid/cfgtoollogs/opatchauto2019-03-14_15-44-28.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/11.2.0/grid/cfgtoollogs/opatchauto2019-03-14_15-44-28.report.log

2019-03-14 15:44:28: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

Stopping CRS...
Stopped CRS successfully

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

----执行相应脚本
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

dba_registry_history

---编译无效对象
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

16:02:26 SYS@uudb1(usdb1)> /

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
---------------------------------------- -------------------- -------------------- ------------------------------ -------------- ------------------------------ --------------------------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
14-MAR-19 02.18.42.983164 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
14-MAR-19 03.56.26.646656 PM APPLY SERVER 11.2.0.4 181016 PSU PSU 11.2.0.4.181016

16:02:26 SYS@uudb1(usdb1)>

SQL > @dbmsjdev.sql
SQL > exec dbms_java_dev.disable

SQL> col ACTION_TIME for a40
SQL> col NAMESPACE for a20
SQL> col COMMENTS for a50
SQL> col action for a20
SQL> col id for 9999999999999

*******可能报错*********

节点2 alter 日志
Mon Feb 22 11:55:37 2021
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/asm-data1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9

启动报错
startup;
ORA-00205: error in identifying control file, check alert log for more info

--解决办法：

[oracle@uudb1 ~]$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239826248 Feb 22 11:30 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@uudb1 ~]$

[root@uudb2 ~]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 239826248 Feb 22 11:38 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@uudb2 ~]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@uudb2 ~]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwxr-x--x 1 oracle asmadmin 239826248 Feb 22 11:38 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@uudb2 ~]# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@uudb2 ~]$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239826248 Feb 22 11:38 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@uudb2 ~]$

日积月累