RE: How remove database from catalog if server dies

Follow the method for unregistering 9i databases? Connect as the repository owner and run as sqlplus:

Declare

L_dbkey number;

L_dbid number;

begin

  select db_key,dbid

   into l_dbkey,l_dbid;

  from rc_database

  where name = 'dbname';

  dbms_rcvcat.unregisterdatabase(l_dbkey,l_dbid);

End;

Hope this helps.

Tom    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Wednesday, July 01, 2009 1:26 PM
To: oracle-l-freelists; oracle-db-l
Subject: How remove database from catalog if server dies  

Assume database A is on server A and server A dies. How can I unregister database A from the recovery catalog if the database no longer exists?    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l