Oracle-L: Re: SID and DB

From: <Rajesh.Rao_at_jpmchase.com>
Date: Fri, 25 Oct 2002 06:18:52 -0800
Message-ID: <F001.004F39C3.20021025061852@fatcity.com>

Simply speaking, consider SID to be the name for the various background process (DBWR, LGWR, et all) and the memory structures (SGA, PGA). A SID needs to be associated with a database, which would be the DB_NAME. The SID and DB_NAME need not be the same. They have to be different in an Oracle Parallel Server environment, where you can have two SID's say ORA1 and ORA2 associated with the same database, say ORA.

Raj

                                                                                                                    
                    ora ak                                                                                          
                    <ora_magic_at_ya        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    hoo.com>             cc:                                                                        
                    Sent by:             Subject:     SID and DB_NAME                                               
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    October 24,                                                                                     
                    2002 11:23 PM                                                                                   
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L

I know this novice question for dba's but just wanted to refresh this ,

what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID and in what circumstances SID and DB_NAME can be different .

TIA oramagic

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Fri Oct 25 2002 - 09:18:52 CDT

Re: SID and DB_NAME