Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot remove database from cluster using srvctl (SORTED)

595268Oct 15 2007 — edited Oct 15 2007

Hi all,

I have just gone through the process of renaming the database name and instance names of
a 2 node RAC cluster. I can get both instances up and running ok but haven't registered them yet,

However, I cannot remove the old database name as I get the following

$ srvctl remove database -d orcl1
Remove the database orcl1? (y/[n]) y
PRKP-1022 : The database orcl1 is still running.
$

If I run a status I get this

$ srvctl status database -d orcl1
Instance orcl11 is not running on node linux1
Instance orcl12 is not running on node linux2
$

crs_stat shows them as follows

# crs_stat
NAME=ora.orcl1.db
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.orcl1.orcl11.inst
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.orcl1.orcl12.inst
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.orcl1.orcltest.cs
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.orcl1.orcltest.orcl11.srv
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.orcl1.orcltest.orcl12.srv
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

Do I need to do a crs_unregister or something first ?

Any ideas ? Clusterware is 10.2.0.3, databases are 10.2.0.1 on Red Hat AS4 Linux

Many thanks

UPDATE
======

Found that if I did a crs_stop ora.orcl1.db I was then allowed to do the srvctl remove !

Thanks anyway

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2007

Added on Oct 15 2007

#performance-availability, #real-application-clusters

3 comments

3,078 views