Oracle11g RAC PSU更新檔安裝

GI版本: 11.2.0.4

DB版本: 11.2.0.4

Opatch: Opatch_11.2.0.3.27.zip

GI PSU: p31718723_112040_Linux-x86-64_GI.zip

OCW：29938455

ACFS：29509309

DB PSU：31537677

grid使用者$ORACLE_HOME目錄

/u01/app/11.2.0/grid

oracle使用者$ORACLE_HOME目錄

/u01/app/oracle/product/11.2.0/db_home

1、節點1應用GI更新檔

#root使用者執行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

$grid使用者執行
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29938455
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29509309
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/31537677           

2、節點2應用GI更新檔

#root使用者執行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

$grid使用者執行
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29938455
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29509309
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/31537677           

3、節點1應用database更新檔

$oracle使用者執行
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/29938455/custom/server/29938455
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/31537677
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home           

4、節點2應用database更新檔

$oracle使用者執行
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/29938455/custom/server/29938455
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/31537677
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home           

5、節點1重新整理參數配置

#root使用者執行
/u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch           

6、節點2重新整理參數配置

#root使用者執行
/u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch           

7、節點1、節點2更新資料庫資料字典

[oracle@rac1:/home/oracle]$sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 14 14:41:08 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL> @?/rdbms/admin/catbundle.sql psu apply

執行完後查詢PSU更新資訊：

SQL> set line 150 
SQL> col ACTION_TIME for a30 
SQL> col ACTION for a8
SQL> col NAMESPACE for a8 
SQL> col VERSION for a10
SQL> col BUNDLE_SERIES for a5 
SQL> col COMMENTS for a20
SQL> select * from dba_registry_history; 

ACTION_TIME                    ACTION   NAMESPAC VERSION            ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
13-APR-21 02.26.05.666106 PM   APPLY    SERVER   11.2.0.4            0 PSU   Patchset 11.2.0.2.0
14-APR-21 02.39.37.788345 PM   APPLY    SERVER   11.2.0.4       201020 PSU   PSU 11.2.0.4.201020