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.