Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1207
  • Last Modified:

Running dbca to create a new single node database.

I created a standalone database on the 4th node of a RAC cluster using Oracle dbca tool.
I then deleted the database using dbca and tried to create the same database using the Oracle RAC option to have the database created on a single node of a 4 node cluster.
I'm now getting the error that the database name already exists in the server pool and it's forcing me to create it with a different name.
I have to have the same database name created. Is there any file that dbca is using that I need to update to have the name removed from the server pool?
0
sharanoble
Asked:
sharanoble
  • 2
1 Solution
 
Sathish David Kumar NCommented:
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
Hi

Check this doc also, see that instance has been removed fully.

http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/adddelunix.htm
0
 
sharanobleAuthor Commented:
This was resolved by using the following commands:

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

  oracle : ln98093.ent.agt.ab.ca : @crs : /ora/fs0000/app/oracle/product/11.2.0.1/cfgtoollogs/oui
$ crsctl delete serverpool ora.IVSDV

  oracle : ln98093.ent.agt.ab.ca : @crs : /ora/fs0000/app/oracle/product/11.2.0.1/cfgtoollogs/oui
$  crsctl status serverpool
0
 
sharanobleAuthor Commented:
Talked to a work colleague about it.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now