ORACLE EXADATA升級—從11.2.3.1.0到11.2.3.3.0–（7）升級Bundle Patch 23

1.下載最新的OPatch，p6880880_112000_Linux-x86-64.zip，解壓並檢查OPatch是否是最新的版本

[oracle@gxx2db01 bp23]$ unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0.3/grid/

[oracle@gxx2db01 bp23]$ $ORACLE_HOME/OPatch/opatch version

2.配置OCM檔案

% $ORACLE_HOME/OPatch/ocm/bin/emocmrsp

3.驗證Oracle Inventory

% $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

4.解壓BP23

% cd /u01/app/oracle/patches

% unzip p18835772_112030_Linux-x86-64.zip

% cd /u01/app/oracle/patches/18835772

# chown -R oracle:oinstall /u01/app/oracle/patches/18835772

5.進行衝突檢測

For Grid Infrastructure Home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18707883

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18906063

For Database home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18707883

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /18835772/18906063/custom/server/18906063

6.檢查SystemSpace,這裡主要是ORACLE_HOME是否有足夠空間

For Grid Infrastructure Home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18707883

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18906063

For Database home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18707883

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /18835772/18906063/custom/server/18906063

7.使用auto的方式打patch

# opatch auto /u01/app/oracle/patches/18835772

8.執行指令碼

% SQL> sqlplus / as sysdba
% SQL> @rdbms/admin/catbundle.sql exa apply

 （本文轉自“新炬網路”官網技術分享欄目）