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.
