Monday, August 5, 2013

DBCA error - Choose a different database name.

DBCA error - Choose a different database name.

Error :

DBCA errored when trying to create a database in a RAC cluster.
There is already a server pool existing with name *****.  Choose a different database name.

Case:

Trying to recreate the database with the same name after doing a ‘Delete Database’ of the same name.



Do the following to cleanup entries in server pool.

> crsctl status serverpool
NAME=Free
ACTIVE_SERVERS=

NAME=Generic
ACTIVE_SERVERS=myhost01 myhost02

NAME=ora.PREMYDB
ACTIVE_SERVERS=myhost01 myhost02


The SRVCTL remove command removes the configuration, for the object from the Oracle Clusterware. Environment settings for the object are also removed.

> srvctl remove srvpool -g ora.PREMYDB
PRKO-3161 : Server pool ora.PREMYDB is internally managed as part of administrator-managed database configuration and therefore cannot be removed directly via srvpool object.

Use CRSCTL

> crsctl delete serverpool -h
Usage:
  crsctl delete serverpool <spName> [...] [-i]
where
    spName [...]    One or more server pool names to be deleted
    -i              Fail if request cannot be processed immediately


> crsctl delete serverpool ora.PREMYDB

Proceed with creating the database. You should no longer get the above error.


2 comments:

  1. How do you handle this error?
    CRS-2554: Server pool 'ora.ABC.SVC' cannot be unregistered as it is referenced by resource 'ora.abc.svc'

    ReplyDelete
    Replies
    1. PRCS-1007 PRCR-1086 - Resources in OCR Are not Cleaned up Completely (Doc ID 1108023.1)

      Delete