RedHat Linux6.4,Oracle 11.2.0.4,单机,ASM
由于此单机环境使用了ASM,因此就必然安装了grid,在安装不定时,那就需要对grid和database都要进行不定安装。
1、更新opatch程序
从mos上下载最新的opatch补丁程序;
2、生成ocm配置文件
执行到$GRID_HOME/OPatch/ocm/bin/emocmrsp
3、关闭数据库和dbconsole
SQL> shutdown immediate
$ emctl stop dbconsole
4、对GRID进行升级
[root@md01 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /home/grid/21523375/ -oh /u01/app/11.2.0/grid/ -ocmrf /home/grid/ocm.rsp
5、对Database进行升级
[root@md01 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto /home/oracle/21523375 -oh /u01/app/oracle/product/11.2.0/dbhome_1 -ocmrf /home/oracle/ocm.rsp
6、更新database数据字典
sqlplus /nolog
conn /as sysdba
@?/rdbms/admin/catbundle.sql psu apply
注意:
确保已解压的补丁目录可同时被oracle和grid用户访问,否则会报如下类似错误,提示什么opatch版本不对,其实我是升级来的,看来opatch的错误信息很具有误导性。
[root@md01 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto /home/grid/21523375/ -oh /u01/app/oracle/product/11.2.0/dbhome_1/ -ocmrf /home/grid/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/patch11203.pl -patchdir /home/grid -patchn 21523375 -oh /u01/app/oracle/product/11.2.0/dbhome_1/ -ocmrf /home/grid/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2015-11-29_21-55-23.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2015-11-29_21-55-23.report.log
2015-11-29 21:55:23: Starting Oracle Restart Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
The opatch minimum version check for patch /home/grid/21523375/21352635 failed for /u01/app/oracle/product/11.2.0/dbhome_1
The opatch minimum version check for patch /home/grid/21523375/21352649/custom/server/21352649 failed for /u01/app/oracle/product/11.2.0/dbhome_1
Opatch version check failed for oracle home /u01/app/oracle/product/11.2.0/dbhome_1
Opatch version check failed
ERROR: update the opatch version for the failed homes and retry
opatch auto failed.
还有,在执行对GRID和DB的补丁升级后,可能在你重新打开数据库时会遇到如下问题:
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260088 bytes
Variable Size 331350920 bytes
Database Buffers 729808896 bytes
Redo Buffers 5517312 bytes
ORA-00205: error in identifying control file, check alert log for more info
这是由于$ORACLE_HOME/bin/oracle 可执行文件的权限发生了变化,通过如下命令进行修复即可:
[root@md01 bin]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[root@md01 bin]# chmod 6751 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle