Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SID Naming Conventions?

Re: SID Naming Conventions?

From: Craig J. Fischer <fischercj_at_bv.com>
Date: 1997/03/21
Message-ID: <3332DD86.4AF9@bv.com>#1/1

Joel Garry wrote:
>
> In article <332FE7CC.50B3_at_bv.com> "Craig J. Fischer" <fischercj_at_bv.com> writes:
> >What are some conventions for naming SIDs? I'm a DBA for a couple
> >different Oracle installations, and whatever conventions have been used
> >in the past (by me and by others) are becoming useless.
> >
> >Some specific questions I have are:
> >1) Is there any reason to stick to 4-character SID names for databases
> >that won't end up on anything less than Unix or NT platforms?
>
> Because you can't say that you will _never_ access them from any other
> platforms?
>
> --
> Joel Garry joelga_at_rossinc.com Compuserve 70661,1534
> These are my opinions, not necessarily those of Ross Systems, Inc. <> <>
> %DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push. \ V /
> panic: ifree: freeing free inodes... O

If you're using SQL*Net V2, what difference does the SID make? The connect descriptor is not tied to the SID, at least on the client (we're using Names), so my SID could be "thisisalongsid" and my connect descriptor could be "longsid".

Craig Fischer
fischercj_at_bv.com Received on Fri Mar 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US