RE: DB Names in multiple oracle installs

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_at_qtel        <ORACLE-L_at_fatcity.com>

                    .com.qa>             cc:

                    Sent by:             Subject:     RE: DB Names in
multiple oracle      
                    root_at_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_at_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_at_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_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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tday6_at_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_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: sujatha.madan_at_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_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).