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

v$database will always show one and only one database - the database to which the instance you are running the query against is attached. As for how to find out on Windows, I'll leave that to someone who knows Windows better than I.

Don Granaman
[OraSaurus]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 02, 2002 6:48 AM

> 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

for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_cox.net

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).