oracle9i rac for aix,oracle 11gR2 rac for aix 第二个节点运行root.sh不成功问题处理

今天帮客户规划安装一套11gR2 rac for aix 数据库,在安装grid集群软件时,第一个节点运行

root.sh成功,运行第二个节点root.sh不成功,主要原因是忘记更改两个节点磁盘的

reserve_policy=no_reserve属性,即没修改成并发属性。

第二个节点root.sh报错如下：

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

2010-10-11 16:05:43: Parsing the host name

2010-10-11 16:05:43: Checking for super user privileges

2010-10-11 16:05:43: User has super user privileges

Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params

Creating trace directory

User grid has the required capabilities to run CSSD in realtime mode

LOCAL ADD MODE

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

Adding daemon to inittab

CRS-4123: Oracle High Availability Services has been started.

ohasd is starting

CRS-2672: Attempting to start 'ora.gipcd' on 'blade12'

CRS-2672: Attempting to start 'ora.mdnsd' on 'blade12'

CRS-2676: Start of 'ora.gipcd' on 'blade12' succeeded

CRS-2676: Start of 'ora.mdnsd' on 'blade12' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'blade12'

CRS-2676: Start of 'ora.gpnpd' on 'blade12' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'blade12'

CRS-2676: Start of 'ora.cssdmonitor' on 'blade12' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'blade12'

CRS-2672: Attempting to start 'ora.diskmon' on 'blade12'

CRS-2676: Start of 'ora.diskmon' on 'blade12' succeeded

CRS-2676: Start of 'ora.cssd' on 'blade12' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'blade12'

CRS-2676: Start of 'ora.ctssd' on 'blade12' succeeded

DiskGroup DATA creation failed with the following message:

ORA-15018: diskgroup cannot be created

ORA-15031: disk specification '/dev/rhdisk1' matches no disks

ORA-15025: could not open disk '/dev/rhdisk1'

ORA-27041: unable to open file

Configuration of ASM failed, see logs for details

Did not succssfully configure and start ASM

CRS-2500: Cannot stop resource 'ora.crsd' as it is not running

CRS-4000: Command Stop failed, or completed with errors.

Command return code of 1 (256) from command: /oracle/app/grid/product/11.2.0/bin/crsctl stop resource ora.crsd -init

Stop of resource "ora.crsd -init" failed

Failed to stop CRSD

CRS-2673: Attempting to stop 'ora.asm' on 'blade12'

CRS-2677: Stop of 'ora.asm' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'blade12'

CRS-2677: Stop of 'ora.ctssd' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'blade12'

CRS-2677: Stop of 'ora.cssdmonitor' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'blade12'

CRS-2677: Stop of 'ora.cssd' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'blade12'

CRS-2677: Stop of 'ora.gpnpd' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'blade12'

CRS-2677: Stop of 'ora.gipcd' on 'blade12' succeeded

CRS-2673: Attempting to stop 'ora.mdnsd' on 'blade12'

CRS-2677: Stop of 'ora.mdnsd' on 'blade12' succeeded

Initial cluster configuration failed.  See /oracle/app/grid/product/11.2.0/cfgtoollogs/crsconfig/rootcrs_blade12.log for details

解决方法:

修改磁盘的reserve_policy=no_reserve属性，第二个节点启动crs集群，切换到grid用户，手工启动asm实例

$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    blade12

ora....ER.lsnr ora....er.type ONLINE    ONLINE    blade14

ora....N1.lsnr ora....er.type ONLINE    ONLINE    blade14

ora.asm        ora.asm.type   ONLINE    ONLINE    blade12

ora....SM2.asm application    ONLINE    ONLINE    blade12

ora....12.lsnr application    OFFLINE   OFFLINE

ora....e12.gsd application    OFFLINE   OFFLINE

ora....e12.ons application    ONLINE    ONLINE    blade12

ora....SM1.asm application    ONLINE    ONLINE    blade14

ora....14.lsnr application    ONLINE    ONLINE    blade14

ora....e14.gsd application    OFFLINE   OFFLINE

ora....e14.ons application    ONLINE    ONLINE    blade14

ora....e14.vip ora....t1.type ONLINE    ONLINE    blade14

ora.eons       ora.eons.type  ONLINE    ONLINE    blade12

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

ora....network ora....rk.type ONLINE    ONLINE    blade12

ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE

ora.ons        ora.ons.type   ONLINE    ONLINE    blade12

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    blade14

发现少了第二个节点的vip资源，通过以下方式手工注册第二个节点VIP资源

blade12[root]#./srvctl add vip -n blade12  -A 172.17.7.247/255.255.255.192/en0 -k 1

blade12[root]#./srvctl start vip -n blade12

blade12[root]#./srvctl start listener -n blade12

ora.DATA.dg    ora....up.type ONLINE    ONLINE    blade12

ora.DGDATA.dg  ora....up.type ONLINE    ONLINE    blade12

ora....OVER.dg ora....up.type ONLINE    ONLINE    blade12

ora....ER.lsnr ora....er.type ONLINE    ONLINE    blade12

ora....N1.lsnr ora....er.type ONLINE    ONLINE    blade14

ora.OCRBAK.dg  ora....up.type ONLINE    ONLINE    blade12

ora.asm        ora.asm.type   ONLINE    ONLINE    blade12

ora....SM2.asm application    ONLINE    ONLINE    blade12

ora....12.lsnr application    ONLINE    ONLINE    blade12

ora....e12.gsd application    ONLINE    ONLINE    blade12

ora....e12.ons application    ONLINE    ONLINE    blade12

ora....e12.vip ora....t1.type ONLINE    ONLINE    blade12

ora....SM1.asm application    ONLINE    ONLINE    blade14

ora....14.lsnr application    ONLINE    ONLINE    blade14

ora....e14.gsd application    ONLINE    ONLINE    blade14

ora....e14.ons application    ONLINE    ONLINE    blade14

ora....e14.vip ora....t1.type ONLINE    ONLINE    blade14

ora.eons       ora.eons.type  ONLINE    ONLINE    blade12

ora.gsd        ora.gsd.type   ONLINE    ONLINE    blade12

ora.gzyj.db    ora....se.type ONLINE    ONLINE    blade14

ora....network ora....rk.type ONLINE    ONLINE    blade12

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    blade14

ora.ons        ora.ons.type   ONLINE    ONLINE    blade12

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    blade14

资源全部正常。