Oracle11gR2 单机环境 GI PSU补丁安装

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