本文转载:
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 ONLINEYou 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 db2crs_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显示都正常 分别访问各个节点,查询数据,一切正常。
|