From sujatha.madan@cmc.cwo.net.au Wed, 19 Sep 2001 16:57:49 -0700 From: Sujatha Madan Date: Wed, 19 Sep 2001 16:57:49 -0700 Subject: RE: DB Names in multiple oracle installs Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, Thanks to all that replied!!! Cheers, Sujatha -----Original Message----- Sent: Wednesday, 19 September 2001 11:55 PM To: Multiple recipients of list ORACLE-L They could have the same database name but different SIDs. But I think that you're right. I think that he means SID. They can have a different ORACLE_HOME in the listner.ora file and a different connect siring in the TNSNAMES.ORA file (along with a different ORACLE_HOME). I'm not sure if that would be enough to differentiate them though. If you're in a UNIX environment there's still the question of ORACLE_SID. Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L .com.qa> cc: Sent by: Subject: RE: DB Names in multiple oracle root@fatcity. installs com 09/19/2001 07:18 AM Please respond to ORACLE-L You CANN'T(if not anyone correct me). Even if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. > -----Original Message----- > From: Sujatha Madan [SMTP:sujatha.madan@cmc.cwo.net.au] > Sent: Tuesday, September 18, 2001 4:05 AM > To: Multiple recipients of list ORACLE-L > Subject: DB Names in multiple oracle installs > > Hi, > > Is it possible to call two databases the same name if they are residing on > the same machine, in different oracle homes? ... One database is version > 8.0.6 and the other is 8.1.7. > > Thanks > > Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: NIRMALK@qtel.com.qa 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6@csc.com 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: sujatha.madan@cmc.cwo.net.au 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@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).