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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
