Solved

Running dbca to create a new single node database.

Posted on 2011-02-18
4
1,162 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
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…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses

623 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