RE: How to know if another database is running on the same machine?
You can Lsnrctl Will return a list of "running" databases on the server. Bob > Sent: Thursday, May 02, 2002 10:18 AM > To: Multiple recipients of list ORACLE-L > Subject: 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. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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).
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" <[EMAIL PROTECTED]> 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: [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).
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 [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).