RAC Remove Resource
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Sun, 7 Jun 2009 11:24:23 -0700 (PDT)
Message-ID: <89059.51599.qm_at_web51302.mail.re2.yahoo.com>
Hi I am in situation where I had to remove the Database Resource like Service/Instance/Database and has to recreate them. I am able to remove the Service/Instance/Database but when checking it is still showing one of the Instance resource and hence cluster output shows that cluster is unhealthy When I remove them, there was no error but one was still not removed oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl remove instance -d testdb -i testdb1 -f PRKO-2007 : Invalid instance name: testdb1 oracle_at_testdbp4:> crs_unregister ora.testdb.testdb1.inst oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl add database -d testdb -o /oracle/product/10.2.0.3 oracle_at_testdbp4:> srvctl add instance -d testdb -i testdb1 -n testdbp4 PRKR-1008 : adding of instance testdb1 on node testdbp4 to cluster database testdb failed. CRS-0211: Resource 'ora.testdb.testdb1.inst' has already been registered. PRKO-2010 : Error in adding instance to node: testdbp4 oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.db OFFLINE OFFLINE ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl add instance -d testdb -i testdb2 -n testdbp5 oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.db OFFLINE OFFLINE ora.testdb.testdb1.inst OFFLINE OFFLINE ora.testdb.testdb2.inst OFFLINE OFFLINE So I had created new Resource for testdb database even testdb1 was there already and then even I can add other instance but not the testdb1 oracle_at_testdbp4:> crsctl check crs CSS appears healthy CRS does not appear to be healthy EVM appears healthy Any suggestion to remove it Thanks Sanjay
Date: Sun, 7 Jun 2009 11:24:23 -0700 (PDT)
Message-ID: <89059.51599.qm_at_web51302.mail.re2.yahoo.com>
Hi I am in situation where I had to remove the Database Resource like Service/Instance/Database and has to recreate them. I am able to remove the Service/Instance/Database but when checking it is still showing one of the Instance resource and hence cluster output shows that cluster is unhealthy When I remove them, there was no error but one was still not removed oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl remove instance -d testdb -i testdb1 -f PRKO-2007 : Invalid instance name: testdb1 oracle_at_testdbp4:> crs_unregister ora.testdb.testdb1.inst oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl add database -d testdb -o /oracle/product/10.2.0.3 oracle_at_testdbp4:> srvctl add instance -d testdb -i testdb1 -n testdbp4 PRKR-1008 : adding of instance testdb1 on node testdbp4 to cluster database testdb failed. CRS-0211: Resource 'ora.testdb.testdb1.inst' has already been registered. PRKO-2010 : Error in adding instance to node: testdbp4 oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.db OFFLINE OFFLINE ora.testdb.testdb1.inst OFFLINE OFFLINE oracle_at_testdbp4:> srvctl add instance -d testdb -i testdb2 -n testdbp5 oracle_at_testdbp4:> crsstat |grep testdb ora.testdb.db OFFLINE OFFLINE ora.testdb.testdb1.inst OFFLINE OFFLINE ora.testdb.testdb2.inst OFFLINE OFFLINE So I had created new Resource for testdb database even testdb1 was there already and then even I can add other instance but not the testdb1 oracle_at_testdbp4:> crsctl check crs CSS appears healthy CRS does not appear to be healthy EVM appears healthy Any suggestion to remove it Thanks Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 07 2009 - 13:24:23 CDT