CRS-0215解决一例

Normal 0 0 2 false false false EN-US ZH-TW X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:表格內文; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-font-kerning:1.0pt;}

轉載：http://hi.baidu.com/lyqiu19/blog/item/ba23a7cad8da181493457e46.html

使用srvctl命令启动集群，结果发现数据库没有启动起来，nodeapps与asm倒是正常启动了：
oracle:/home/oracle>srvctl start database -d ba1db
PRKP-1001 : Error starting instance ba1db1 on node badb1
CRS-0215: Could not start resource 'ora.ba1db.ba1db1.inst'.

oracle:/home/oracle>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora....b1.inst application    0/5    0/0    ONLINE    OFFLINE
ora.ba1db.db   application    0/0    0/1    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    badb1
ora....B1.lsnr application    0/5    0/0    ONLINE    ONLINE    badb1
ora.badb1.gsd  application    0/5    0/0    ONLINE    ONLINE    badb1
ora.badb1.ons  application    0/3    0/0    ONLINE    ONLINE    badb1
ora.badb1.vip  application    0/0    0/0    ONLINE    ONLINE    badb1

但是，通过sqlplus手工启动，数据库是可以正常启动的，看来这些db启动服务哪里又出问题了。
尝试单独启动instance服务：
oracle:/home/oracle>crs_start ora.ba1db.ba1db1.inst
Attempting to start `ora.ba1db.ba1db1.inst` on member `badb1`
Start of `ora.ba1db.ba1db1.inst` on member `badb1` failed.
CRS-1006: No more members to consider

CRS-0215: Could not start resource 'ora.ba1db.ba1db1.inst'.

这回多了个提示信息：CRS-1006: No more members to consider。
让人模糊。
实例没有启动，看看imon日志吧：
cd $ORACLE_HOME/log/badb1/racg/
vi imon_ba1db.log

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:48 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-01565: error in identifying file '+DATA/ba1db/spfileba1db.ora'

2011-05-23 15:24:49.663: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]: ORA-17503: ksfdopn:2 Failed to open file +DATA/ba1db/spfileba1db.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/ba1db/spfileba1db.ora
ORA
ORA-01078: failure in processing system parameters

2011-05-23 15:24:49.663: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]: SQL> Disconnected

2011-05-23 15:24:49.663: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]: clsrcexecut: env _USR_ORA_PFILE=/oracle/product/10.2.0/crs/racg/tmp/ora.ba1db.ba1db1.inst.ora

2011-05-23 15:24:49.663: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]: clsrcexecut: cmd = /oracle/product/10.2.0/db_1/bin/racgeut -e _USR_ORA_DEBUG=0 -e ORACLE_SID=ba1db1 540 /oracle/product/10.2.0/db_1/bin/racgmdb -s open

2011-05-23 15:24:49.663: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]: clsrcexecut: rc = 1, time = 1.230s

2011-05-23 15:24:50.946: [    RACG][1126189408] [7490][1126189408][ora.ba1db.ba1db1.inst]:
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:49 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected

2011-05-23 15:24:57.154: [    RACG][2540903680] [7490][2540903680][ora.ba1db.ba1db1.inst]: racgimon exiting

再看imonba1db.log文件：

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:48 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-01565: error in identifying file '+DATA/ba1db/spfileba1db.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ba1db/spfileba1db.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/ba1db/spfileba1db.ora
ORA
ORA-01078: failure in processing system parameters
SQL> Disconnected

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:49 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected

再看看ora.ba1db.ba1db1.inst.log文件：

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:27 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-01565: error in identifying file '+DATA/ba1db/spfileba1db.ora'
ORA-17'

2011-05-23 15:24:28.984: [    RACG][2540903680] [7311][2540903680][ora.ba1db.ba1db1.inst]: end for resource = ora.ba1db.ba1db1.inst, action = start, status = 1, time = 2.280s

2011-05-23 15:24:47.402: [ COMMCRS][1084229984]clsc_connect: (0x5da6c0) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=ora_racg_ba1db_badb1))

2011-05-23 15:24:49.665: [    RACG][2540903680] [7484][2540903680][ora.ba1db.ba1db1.inst]: clsrcremaction: clsrcrpcreq message returned: 1 '
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 23 15:24:48 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-01565: error in identifying file '+DATA/ba1db/spfileba1db.ora'
ORA-17'

2011-05-23 15:24:49.665: [    RACG][2540903680] [7484][2540903680][ora.ba1db.ba1db1.inst]: end for resource = ora.ba1db.ba1db1.inst, action = start, status = 1, time = 2.260s

都提示同一个错误：ORA-01565: error in identifying file '+DATA/ba1db/spfileba1db.ora'
看来spfile应该是罪魁祸首了。
下面来检查集群spfile设置：
cd $ORACLE_HOME/dbs
oracle:/oracle/product/10.2.0/db_1/dbs>ls
ab_+ASM1.dat  hc_+ASM1.dat  hc_ba1db1.dat  init+ASM1.ora  initba1db1.ora  initdw.ora  init.ora  orapw+ASM1  orapwba1db1  snapcf_ba1db1.f
oracle:/oracle/product/10.2.0/db_1/dbs>cat initba1db1.ora
SPFILE='+DATA/ba1db/parameterfile/spfile.269.730842125'
指向ASM中的一个文件。
再查看数据库服务中的配置：

oracle:/oracle/product/10.2.0/db_1/dbs>srvctl config database -d ba1db -a
badb1 ba1db1 /oracle/product/10.2.0/db_1
DB_NAME: ba1db
ORACLE_HOME: /oracle/product/10.2.0/db_1
SPFILE: +DATA/ba1db/spfileba1db.ora
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY:  AUTOMATIC
ENABLE FLAG: DB ENABLED

果然不一样，修改spfile='+DATA/ba1db/parameterfile/spfile.269.730842125'。

oracle:/oracle/product/10.2.0/db_1/dbs>srvctl modify database -d ba1db -p +DATA/ba1db/parameterfile/spfile.269.730842125
oracle:/oracle/product/10.2.0/db_1/dbs>srvctl config database -d ba1db -a
badb1 ba1db1 /oracle/product/10.2.0/db_1
DB_NAME: ba1db
ORACLE_HOME: /oracle/product/10.2.0/db_1
SPFILE: +DATA/ba1db/parameterfile/spfile.269.730842125
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY:  AUTOMATIC
ENABLE FLAG: DB ENABLED
oracle:/oracle/product/10.2.0/db_1/dbs>srvctl start database -d ba1db
oracle:/oracle/product/10.2.0/db_1/dbs>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora....b1.inst application    0/5    0/0    ONLINE    ONLINE    badb1
ora.ba1db.db   application    0/0    0/1    ONLINE    ONLINE    badb1
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    badb1
ora....B1.lsnr application    0/5    0/0    ONLINE    ONLINE    badb1
ora.badb1.gsd  application    0/5    0/0    ONLINE    ONLINE    badb1
ora.badb1.ons  application    0/3    0/0    ONLINE    ONLINE    badb1
ora.badb1.vip  application    0/0    0/0    ONLINE    ONLINE    badb1
oracle:/oracle/product/10.2.0/db_1/dbs>

ok，问题解决。