分类： Oracle
2013-07-04 13:37:50
使用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，问题解决。
