Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Running dbca to create a new single node database.

Posted on 2011-02-18
4
Medium Priority
?
1,186 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 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
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 …
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Suggested Courses

722 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