Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> clean up ocr?

clean up ocr?

From: herta <herta.vandeneynde_at_gmail.com>
Date: Tue, 26 Jun 2007 07:27:17 -0000
Message-ID: <1182842837.948869.213310@o61g2000hsh.googlegroups.com>


environment: Oracle EE 10.2.0.3 on SLES10

I'm setting up Data Guard largely following the instructions in http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrimaryRACPhysicalStandby.pdf

In doing so, I ran into a few issues, due to which I had to start over a couple of times. Data Guard is up and running now, but I'm having problems adding the standby database (back) into the cluster, because it claims the database already exists. Oracle's solution, "choose a different name for the database being created" is not practicable in this case, as it would upset our naming schemes, and hence cause scripting issues.

Is there a way to clean the entries for this database from the ocr?

Kind regards,

Herta

$ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database pa99nb because a database named pa99nb already exists.

$ srvctl remove database -d pa99nb
Remove the database pa99nb? (y/[n]) y
$ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database pa99nb because a database named pa99nb already exists.

$ crs_stat | grep pa99nb ; echo $?
1

$ ocrdump -stdout | grep -i pa99nb
[DATABASE.LOG.pa99nb]
[DATABASE.LOG.pa99nb.INSTANCE]
[DATABASE.DATABASES.pa99nb]

ORATEXT : pa99nb
[DATABASE.DATABASES.pa99nb.ORACLE_HOME]
[DATABASE.DATABASES.pa99nb.DOMAIN]
[DATABASE.DATABASES.pa99nb.SPFILE]
[DATABASE.DATABASES.pa99nb.DB_NAME]
[DATABASE.DATABASES.pa99nb.ROLE]
[DATABASE.DATABASES.pa99nb.START_OPTIONS]
[DATABASE.DATABASES.pa99nb.ENABLED]
[DATABASE.DATABASES.pa99nb.POLICY]
[DATABASE.DATABASES.pa99nb.PRIOR_POLICY]
[DATABASE.DATABASES.pa99nb.SERVICE]
[DATABASE.DATABASES.pa99nb.CONFIG_VERSION]
[DATABASE.DATABASES.pa99nb.ENVIRONMENT]
[DATABASE.DATABASES.pa99nb.INSTANCE]
Received on Tue Jun 26 2007 - 02:27:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US