RE: How remove database from catalog if server dies

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Wed, 1 Jul 2009 13:36:29 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF023CA91C_at_EXCNYSM0A1AJ.nysemail.nyenet>


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


L_dbkey number;

L_dbid number;


  select db_key,dbid

   into l_dbkey,l_dbid;

  from rc_database

  where name = 'dbname';



Hope this helps.


[] 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

Received on Wed Jul 01 2009 - 12:36:29 CDT

Original text of this message