本文转载:http://hi.baidu.com/glm002340_sz/blog/item/a908513b8929915fac4b5ff4.html

 

CRS-0215: Could not start resource 'ora.DB.DB2.inst'
2011-10-13 14:19

1- stop nodeapps 
2- As root, 
vi the script $ORA_CRS_HOME/bin/racgvip and change the value of 
variable FAIL_WHEN_DEFAULTGW_NOT_FOUND=0 . 
3- start nodeapps and you should see the resources ONLINE  

You can simply change the parameter one by one on each node...
1. alter system set cluster_database=false scope=spfile sid='<firstinstanceid>';
2 Bounce the instance.
srvctl start nodeapps -n db2
srvctl stop nodeapps -n db2

crs_stat

crs_start ora.db2.ASM2.asm

crs_start all

crsctl check crs

/u01/crs/oracle/product/10.2/crs/bin/srvctl start instance -d DB -i DB2

 

$srvctl setenv database -d DB -T TNS_ADMIN=$ORACLE_HOME/network/admin/

./srvctl setenv nodeapps -n db2 -t TNS_ADMIN=/u01/app/oracle/product/10.2.0/db_1/network/admin/
$ srvctl start database -d DB

以上方法试过无用,/etc/init.d/oracleasm listdisks 没有结果,/etc/init.d/oracleasm enable

 提示Initializing the Oracle ASMLib driver:                     [FAILED]

  rpm -q oracleasm-`uname -r` 提示包没有安装,检查内核版本,发现版本升级了,晕,难怪ASM不正常了,下载相应版本的ASM安装后

/etc/init.d/oracleasm enable 提示正常,/etc/init.d/oracleasm listdisks 显示正常.

srvctl start nodeapps -n db2 实例和ASM的服务不正常,强行启动。

./crs_start ora.db2.ASM2.asm -f

./crs_start ora.DB.DB2.inst -f

./crs_stat -t显示都正常

分别访问各个节点,查询数据,一切正常。