How to know if another database is running on the same machine?

From: Abdul Aleem <dmit_at_beaconhouse.edu.pk>
Date: Wed, 01 May 2002 22:18:18 -0800
Message-ID: <F001.00455E18.20020501221818@fatcity.com>

Hi!

On my win2k server I configured two databases one for data (MYData) and the other for EM Repository OEMREP. The tools do not seem to be able to connect to the database having data. The error reported is that TNS couldn't identify SID.

The v$database shows only the OEMREP database (Could be because the other one is not accessible or perhaps the view shows the one that is active).

How do I know whether the other database is there or not and how to make it accessible?

TIA! Aleem
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
  INET: dmit_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 02 2002 - 01:18:18 CDT