oracle版本:oracle rac 11.2.0.3之前打了11.2.0.3.9的补丁集,rac装上还没正式用,所以就干脆再打到最新的11.2.0.3.11补丁集。
先交代环境:
操作系统:aix 7.1
oracle版本:oracle rac 11.2.0.3
之前打了11.2.0.3.9的补丁集,rac装上还没正式用,所以就干脆再打到最新的11.2.0.3.11补丁集。
今日在前段时间新装的两套rac打最新的psu,同样使用opatch auto的方式来打psu,但是其中一套rac是连同rac和grid一起patch,,而另一套是只patch grid的补丁集。很郁闷,两套rac的crsconfig_params是基本一样的,两套rac的相关配置都是我一手安装配置的,为什么会有如此多偏差?
如下是rac和grid一同patch的那套rac:
root@hdb01:/oraapp/oracle/backup>/oraapp/grid/gridhome/opatch/opatch auto /install/psu -ocmrf /home/grid/grid.rsp
executing /oraapp/grid/gridhome/perl/bin/perl /oraapp/grid/gridhome/opatch/crs/patch11203.pl -patchdir /install -patchn psu -ocmrf /home/grid/grid.rsp -paramfile /oraapp/grid/gridhome/crs/install/crsconfig_params
this is the main log file: /oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-07-56.log
this file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-07-56.report.log
2014-09-28 15:07:56: starting clusterware patch setup
using configuration parameter file: /oraapp/grid/gridhome/crs/install/crsconfig_params
stopping rac /oraapp/oracle/product/11.2.0/dbhome_1 ...
stopped rac /oraapp/oracle/product/11.2.0/dbhome_1 successfully
patch /install/psu/17592127/custom/server/17592127 apply successful for home /oraapp/oracle/product/11.2.0/dbhome_1
patch /install/psu/18522512 apply successful for home /oraapp/oracle/product/11.2.0/dbhome_1
stopping crs...
stopped crs successfully
patch /install/psu/17592127 apply successful for home /oraapp/grid/gridhome
patch /install/psu/18522512 apply successful for home /oraapp/grid/gridhome
starting crs...
crs-4123: oracle high availability services has been started.
starting rac /oraapp/oracle/product/11.2.0/dbhome_1 ...
started rac /oraapp/oracle/product/11.2.0/dbhome_1 successfully
opatch auto succeeded.
root@db01:/oraapp/oracle/backup>su - grid
如下是只patch 了 grid的那套rac:
root@odb01:/install/psu>/oraapp/grid/gridhome/opatch/opatch auto /install/psu -ocmrf /home/grid/grid.rsp
executing /oraapp/grid/gridhome/perl/bin/perl /oraapp/grid/gridhome/opatch/crs/patch11203.pl -patchdir /install -patchn psu -ocmrf /home/grid/grid.rsp -paramfile /oraapp/grid/gridhome/crs/install/crsconfig_params
this is the main log file: /oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-08-19.log
this file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oraapp/grid/gridhome/cfgtoollogs/opatchauto2014-09-28_15-08-19.report.log
2014-09-28 15:08:19: starting clusterware patch setup
using configuration parameter file: /oraapp/grid/gridhome/crs/install/crsconfig_params
stopping crs...
stopped crs successfully
patch /install/psu/17592127 apply successful for home /oraapp/grid/gridhome
patch /install/psu/18522512 apply successful for home /oraapp/grid/gridhome
starting crs...
crs-4123: oracle high availability services has been started.
opatch auto succeeded.
root@odb01:/install/psu>
通过查看mos文档:(doc id 1479651.1)得知,hdb中是有数据库存在的(即通过dbca等形式创建数据库的),而odb上并没有数据库db的存在。
ps:这时突然想起来,前段时间确实在hdb上建立过数据库,并做了一些数据迁移做测试。。。(愚钝啊)
opatch的时候oracle在发现没有数据库database注册到ocr中,因此只是patch了grid。
如下:通过mos提供的命令发现hdb上crs中确实有ora.hdb.db的存在:
grid@hdb01:/home/grid>crsctl stat res -p -w type = ora.database.type|egrep '^name|^oracle_home'
name=ora.hdb.db
oracle_home=/oraapp/oracle/product/11.2.0/dbhome_1
oracle_home_old=
name=ora.hdb.db
oracle_home=/oraapp/oracle/product/11.2.0/dbhome_1
oracle_home_old=
grid@hdb01:/home/grid>
而在odb上,次命令下去无任何输出,查看一下/etc/oratab文件,确实未发现除asm之外的其他数据库:
grid@odb01:/home/grid>crsctl stat res -p -w type = ora.database.type|egrep '^name|^oracle_home'
grid@srmbodb01:/home/grid>
可以通过以下命令来另外给rac patch 补丁:
as root user, execute the following command:
opatch auto -oh -ocmrf
oracle 单实例 从32位 迁移到 64位 方法
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
本文永久更新链接地址:
