RE: DB Names in multiple oracle installs

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).