ITPub博客

首页 > 数据库 > Oracle > ORACLE EXADATA升级—从11.2.3.1.0到11.2.3.3.0–(7)升级Bundle Patch 23

ORACLE EXADATA升级—从11.2.3.1.0到11.2.3.3.0–(7)升级Bundle Patch 23

Oracle 作者:shsnchyw 时间:2015-01-15 14:47:48 0 删除 编辑

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

 (本文转自“新炬网络”官网技术分享栏目)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29960155/viewspace-1402865/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-10-16

  • 博文量
    147
  • 访问量
    268239