Solved

Running dbca to create a new single node database.

Posted on 2011-02-18
4
1,149 Views
Last Modified: 2013-11-23
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
Comment
Question by:sharanoble
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 20

Expert Comment

by:Sathish David Kumar N
ID: 34932834
0
 
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 34933015
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
 

Accepted Solution

by:
sharanoble earned 0 total points
ID: 35039073
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
 

Author Closing Comment

by:sharanoble
ID: 35081109
Talked to a work colleague about it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question