Solved

Running dbca to create a new single node database.

Posted on 2011-02-18
4
1,123 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
  • 2
4 Comments
 
LVL 20

Expert Comment

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

Expert Comment

by:praveencpk
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 is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
diffSum example 4 37
map related example 6 49
couple of eclipse 5 38
how to add new optional parameter to JSP 1 42
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
The viewer will learn how to implement Singleton Design Pattern in Java.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

803 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