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