Re: basic question about db_name and sid

SID identifies instance, whereas db_name identifies database.

It is possible that two or more instances point to one database.

HTH, Krishna

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 25, 2002 6:04 PM

> First, it is true that you can have a different SID than your database
name.
> This is usually not recommended because it causes a lot of confusion, but
it
> is possible and there may be some reason out there to have them different.
In
> that case I wouldn't be the one who can tell you why.
>
> The SID is actually the "System Identifier" which is made up of Oracle's
> Memory and Processes. When you separate the two (SID / DB NAME) The DB
NAME
> is the name of the collection of all of the physical files (ex. Datafiles,
> Redo log files, control files).
>
> Technically, the component that find the database are the initSID.ora
file.
> This is where the "Control File" parameters are specified. Then the Log
file
> and Datafile definitions and locations are stored inside the Control file.
>
>
> -Scott Stefick
>
>
> >===== Original Message From ORACLE-L_at_fatcity.com =====
> >the "SID" is a string that identifies where to find the database.
> >It is not necessarily the same as the database name.
> >(here is the url from where i read this
> >http://datavision.sourceforge.net/DataVision/create.html)
> >
> >first, is it true that sid need not be the same as the db name ?
> >because in a typical oracle install you are asked to write "sid"
> >and it actually becomes the db_name as well. right ?
> >
> >secondly what does this mean "sid is a string that identifies where
> >to find the database" ?
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> >http://mailplus.yahoo.com
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: john
> > INET: john_g123_9_at_yahoo.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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: sstefick
> INET: sstefick_at_harper.cc.il.us
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Krishna Rao Kakatur
  INET: master_dba_at_hotmail.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).