Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1031338
  • 博文数量: 159
  • 博客积分: 3063
  • 博客等级: 中校
  • 技术积分: 2703
  • 用 户 组: 普通用户
  • 注册时间: 2012-04-01 01:51
文章分类

全部博文(159)

文章存档

2013年(48)

2012年(111)

分类: 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,问题解决。

阅读(1092) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~