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

Hi Dmit,

When you connect to a database and look at v$database, it will only show you
information about the current database.

On win2k you should check the following: 1. go to the services panel and make sure you have services created and started for each database
2. from the dos prompt check the listener to make sure it is listening for each
of these databases
3. assuming you are using tnsnames file check to make sure each of these databases are in the tnsnames file
4. from the dos prompt see if you can connect to each of these databases using the oracle_sid
set oracle_sid=oemrep
sqlplus user/password
select * from v$database;
exit

set oracle_sid=mydata
sqlplus user/password
select * from v$database;
exit

If all of the above are ok, you should be able to connect using the listener as well.

Good luck,
John

dmit_at_beaconhouse.edu.pk wrote:

>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: Ora NT DBA
  INET: orantdba_at_netscape.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).