| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Max length of SID in Oracle 8
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C080C7.4B543170
Content-Type: text/plain;
charset="iso-8859-1"
eight total. so, in Unix....eight
in NT, since the service stuff prepends "ORCL", so......ORCL<sid>....four
make sense?
-----Original Message-----
From: Adams, Matthew (GEA, 088130) [mailto:MATT.ADAMS_at_APPL.GE.COM]
Sent: Wednesday, January 17, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Max length of SID in Oracle 8
The "Getting started" book is clearly wrong. I have created many databases with a SID of 8 characters.
Not sure what the limit is.
> -----Original Message-----
> From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com]
> Sent: Wednesday, January 17, 2001 2:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Max length of SID in Oracle 8
>
>
> Well I thought I found the answer. The "Getting started" book
> clearly states
> 4 characters.
> What is your source for 8 characters? I am referring to the
> SID not dbname.
>
> Thanks
> Rick
>
> > -----Original Message-----
> > From: William_Gioioso_at_vanguard.com
> [SMTP:William_Gioioso_at_vanguard.com]
> > Sent: Wednesday, January 17, 2001 2:39 PM
> > To: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk
> > Subject: Re: Max length of SID in Oracle 8
> >
> > The length is 8 characters.
> >
> >
> >
> >
> >
> >
> > "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> on
> 01/17/2001 02:33:44
> > PM
> >
> > To: ORACLE-L_at_fatcity.com, oracledba_at_quickdoc.co.uk
> > cc: (bcc: William Gioioso/IT/VGI)
> > Subject: Max length of SID in Oracle 8
> >
> >
> > Hi DBAs,
> >
> > I cannot seem to find what the max length of SID is. Is it
> still 4? I was
> > thinking in one of the newer version
> > it increased in size.
> >
> > Thanks
> > Rick Cale, Science Applications International Corp.
> > Phone:865-481-2198, fax:865-481-8555
> > e-mail: caler_at_saic.com
> >
> >
> > --------
> > Think you know someone who can answer the above question?
> Forward it to
> > them!
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >
> >
> >
> >
> >
> >
> > --------
> > Think you know someone who can answer the above question?
> Forward it to
> > them!
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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: Adams, Matthew (GEA, 088130) INET: MATT.ADAMS_at_APPL.GE.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). ------_=_NextPart_001_01C080C7.4B543170 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: Max length of SID in Oracle 8</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>eight total. so, in Unix....eight</FONT> <BR><FONT SIZE=2>in NT, since the service stuff prepends "ORCL", so......ORCL<sid>....four</FONT> </P> <P><FONT SIZE=2>make sense?</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Adams, Matthew (GEA, 088130) [<A HREF="mailto:MATT.ADAMS_at_APPL.GE.COM">mailto:MATT.ADAMS_at_APPL.GE.COM</A>]</FONT> <BR><FONT SIZE=2>Sent: Wednesday, January 17, 2001 3:13 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: Max length of SID in Oracle 8</FONT> </P> <BR> <P><FONT SIZE=2>The "Getting started" book is clearly wrong. I have</FONT> <BR><FONT SIZE=2>created many databases with a SID of 8 characters.</FONT> </P> <P><FONT SIZE=2>Not sure what the limit is.</FONT> </P> <P><FONT SIZE=2>----</FONT> <BR><FONT SIZE=2>Matt Adams - GE Appliances - matt.adams_at_appl.ge.com</FONT> <BR><FONT SIZE=2>Those that do not archive the past are</FONT> <BR><FONT SIZE=2>condemned to retype it.</FONT> <BR><FONT SIZE=2> - Practical Unix Security by Garfinkle & Spafford</FONT> </P> <P><FONT SIZE=2>> -----Original Message-----</FONT> <BR><FONT SIZE=2>> From: Cale, Rick T (Richard) [<A HREF="mailto:RICHARD.T.CALE_at_saic.com">mailto:RICHARD.T.CALE_at_saic.com</A>]</FONT> <BR><FONT SIZE=2>> Sent: Wednesday, January 17, 2001 2:47 PM</FONT> <BR><FONT SIZE=2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>> Subject: RE: Max length of SID in Oracle 8</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Well I thought I found the answer. The "Getting started" book </FONT> <BR><FONT SIZE=2>> clearly states</FONT> <BR><FONT SIZE=2>> 4 characters.</FONT> <BR><FONT SIZE=2>> What is your source for 8 characters? I am referring to the </FONT> <BR><FONT SIZE=2>> SID not dbname.</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Thanks</FONT> <BR><FONT SIZE=2>> Rick</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> > -----Original Message-----</FONT> <BR><FONT SIZE=2>> > From: William_Gioioso_at_vanguard.com </FONT> <BR><FONT SIZE=2>> [SMTP:William_Gioioso_at_vanguard.com]</FONT> <BR><FONT SIZE=2>> > Sent: Wednesday, January 17, 2001 2:39 PM</FONT> <BR><FONT SIZE=2>> > To: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk</FONT> <BR><FONT SIZE=2>> > Subject: Re: Max length of SID in Oracle 8</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > The length is 8 characters.</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> on </FONT> <BR><FONT SIZE=2>> 01/17/2001 02:33:44</FONT> <BR><FONT SIZE=2>> > PM</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > To: ORACLE-L_at_fatcity.com, oracledba_at_quickdoc.co.uk</FONT> <BR><FONT SIZE=2>> > cc: (bcc: William Gioioso/IT/VGI)</FONT> <BR><FONT SIZE=2>> > Subject: Max length of SID in Oracle 8</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > Hi DBAs,</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > I cannot seem to find what the max length of SID is. Is it </FONT> <BR><FONT SIZE=2>> still 4? I was</FONT> <BR><FONT SIZE=2>> > thinking in one of the newer version</FONT> <BR><FONT SIZE=2>> > it increased in size.</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > Thanks</FONT> <BR><FONT SIZE=2>> > Rick Cale, Science Applications International Corp.</FONT> <BR><FONT SIZE=2>> > Phone:865-481-2198, fax:865-481-8555</FONT> <BR><FONT SIZE=2>> > e-mail: caler_at_saic.com</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > --------</FONT> <BR><FONT SIZE=2>> > Think you know someone who can answer the above question? </FONT> <BR><FONT SIZE=2>> Forward it to</FONT> <BR><FONT SIZE=2>> > them!</FONT> <BR><FONT SIZE=2>> > to unsubscribe, send a blank email to </FONT> <BR><FONT SIZE=2>> oracledba-unsubscribe_at_LAZYDBA.com</FONT> <BR><FONT SIZE=2>> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com</FONT> <BR><FONT SIZE=2>> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl</FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > </FONT> <BR><FONT SIZE=2>> > --------</FONT> <BR><FONT SIZE=2>> > Think you know someone who can answer the above question? </FONT> <BR><FONT SIZE=2>> Forward it to</FONT> <BR><FONT SIZE=2>> > them!</FONT> <BR><FONT SIZE=2>> > to unsubscribe, send a blank email to </FONT> <BR><FONT SIZE=2>> oracledba-unsubscribe_at_LAZYDBA.com</FONT> <BR><FONT SIZE=2>> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com </FONT> <BR><FONT SIZE=2>> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl</FONT> <BR><FONT SIZE=2>> -- </FONT> <BR><FONT SIZE=2>> Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>> -- </FONT> <BR><FONT SIZE=2>> Author: Cale, Rick T (Richard)</FONT> <BR><FONT SIZE=2>> INET: RICHARD.T.CALE_at_saic.com</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>> San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>> --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>> (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>> also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Adams, Matthew (GEA, 088130)</FONT> <BR><FONT SIZE=2> INET: MATT.ADAMS_at_APPL.GE.COM</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>Received on Wed Jan 17 2001 - 14:51:41 CST
 |
 |