Linux 11g rac PSU

531968912發表於2016-04-25

PSU補丁:p22191577_112040_Linux-x86-64.zip
OPATCH工具:p6880880_112000_LINUX.zip

解壓OPATCH工具 覆蓋到/u01/11.2.0/grid/和/u01/app/oracle/product/11.2.0/db_1這兩個目錄。(兩上節點都執行)

生成OCM file(grid使用者)
/u01/11.2.0/grid/OPatch/ocm/bin
./emocmrsp

先升GI:兩個節點執行:
root執行:
unzip p22191577_112040_Linux-x86-64.zip
chown -R grid:oinstall 22191577
chmod -R 775 22191577
/u01/11.2.0/grid/OPatch/opatch auto /soft/orcapp/22191577 -oh /u01/11.2.0/grid/ -ocmrf /u01/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

再升DB 兩個節點執行:
root執行:
chown -R oracle:oinstall 22191577
chmod -R 775 22191577
/u01/11.2.0/grid/OPatch/opatch auto /soft/orcapp/22191577 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/11.2.0/grid/OPatch/ocm/bin/ocm.rsp


grid使用者檢視GI版本:

/u01/11.2.0/grid/OPatch/opatch lsinventory

oracle使用者檢視DB版本:
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory

更新dba_registry_history檢視資訊

[oracle@rac1 ~]$ sqlplus / as sysdba

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

確認升級後的dba_registry_history檢視:

檢視補丁

col ACTION_TIME for a10
col ACTION for a10
col NAMESPACE for a10
col VERSION for a10
col COMMENTS for a40
set linesize 250
select * from dba_registry_history;

su - oracle
opatch lsinv


For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:

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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25462274/viewspace-2087606/,如需轉載,請註明出處,否則將追究法律責任。

相關文章