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
<NIRMALK@qtel <[EMAIL PROTECTED]>
.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:[EMAIL PROTECTED]]
> 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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
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).