今天帮客户规划安装一套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.
-10-11 16:05:43: Parsing the host name
-10-11 16:05:43: Checking for super user privileges
-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
资源全部正常。
