oracle 11g rac不停机手动打psu步骤（linux 7）

此步骤适用补丁版本为：GIPSU:31305209

操作系统版本为：Linux 6/linux 7

所有节点grid用户解压 psu补丁包

[grid@tj2 ~]$ cd /oracle
[grid@tj2 oracle]$ unzip p20485808_112040_Linux-x86-64.zip 
[grid@tj1 oracle]$ ll /oracle/20485808/
total 116
drwxr-xr-x 5 grid oinstall  4096 Oct  6 18:27 20420937   ocw
drwxr-xr-x 6 grid oinstall  4096 Oct 10 21:20 20299013   db
drwxr-xr-x 5 grid oinstall  4096 Oct  6 18:48 20299019   acfs
-rw-r–r– 1 grid oinstall   549 Oct 11 10:04 bundle.xml
-rw-rw-r– 1 grid oinstall 36598 Oct 10 21:44 PatchSearch.xml
-rw-rw-r– 1 grid oinstall 57956 Oct 14 16:42 README.html
-rw-r–r– 1 grid oinstall     0 Oct 11 10:04 README.txt
 
[oracle@oraclen01 ~]$ srvctl stop home -o /oracle/app/oracle/product/11.2.0/db_1 -s /home/oracle/crsstatus -n oraclen01
[oracle@oraclen02 ~]$ srvctl stop home -o /oracle/app/oracle/product/11.2.0/db_1 -s /home/oracle/crsstatus -n oraclen02

                gino     ocw      acfs     dbpsu
11.2.0.4.4GIPSU 20485808 20420937 20299019 20299013
 
11.2.0.4.6GIPSU 20485808 20420937 20299019 20299013

11.2.0.4.20GIPSU 31305209 29938455 29509309  31103343

方法一：自动应用

/u01/app/11.2.0.4/grid/OPatch/opatch auto /home/grid/31305209 -oh /u01/app/11.2.0.4/grid

/u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch auto /home/grid/31103343 -oh /u01/app/oracle/product/11.2.0.4/db_1

方法二：手动应用

1、解锁crs home，关闭database

/u01/app/11.2.0.4/grid/perl/bin/perl  /u01/app/11.2.0.4/grid/crs/install/rootcrs.pl -unlock

/u01/app/oracle/product/11.2.0.4/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0.4/db_1 -s /home/oracle/status4 -n hisdb04

2、更新gi补丁

export LANG=en_US
[grid@oraclen01 oracle]$ /u01/app/11.2.0.4/grid/OPatch/opatch napply -oh /u01/app/11.2.0.4/grid -local /home/grid/31305209/29938455
                         
[grid@oraclen01 oracle]$ /u01/app/11.2.0.4/grid/OPatch/opatch napply -oh /u01/app/11.2.0.4/grid -local /home/grid/31305209/29509309
                       
[grid@oraclen01 oracle]$ /u01/app/11.2.0.4/grid/OPatch/opatch apply -oh /u01/app/11.2.0.4/grid -local /home/grid/31305209/31103343

3、更行db补丁

[oracle@oraclen01 ~]$ /home/oracle/31305209/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0.4/db_1

[oracle@oraclen01 ~]$ /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0.4/db_1 -local /home/oracle/31305209/29938455/custom/server/29938455
[oracle@oraclen01 ~]$ /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0.4/db_1 -local /home/oracle/31305209/31103343
 
[oracle@oraclen01 ~]$ /home/oracle/31305209/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0.4/db_1

4、重新链接 Oracle 升级到补丁版本启动

[root@oraclen01 ~# /u01/app/11.2.0.4/grid/rdbms/install/rootadd_rdbms.sh
[root@oraclen01 ~# /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/crs/install/rootcrs.pl -patch

[grid@oraclen01 oracle]$/u01/app/oracle/product/11.2.0.4/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0.4/db_1 -s /home/oracle/status4 -n hisdb04

权限错误，修改权限

cd /u01/app/oracle/product/11.2.0.4/db_1/bin
chown oracle.asmadmin oracle
chmod 6751 oracle

5、其它节点重复以上步骤

数据库应用补丁并检查应用情况

?/rdbms/admin/catbundle.sql psu apply
检查PSU补丁情况。
SQL> select action,comments from registry$history;