+ Reply to Thread
Results 1 to 8 of 8

Thread: SID length

  1. 03-01-2001 03:18 PM #1
    wren01
    wren01 is offline Junior Member
    Join Date
    Jan 2001
    Posts
    71

    Question

    anybody have idea how long SID can be. Is there any limit on length?
    Reply With Quote Reply With Quote
  2. 03-01-2001 03:22 PM #2
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    Yes there is a limit , It cannot be more than 8 characters.
    Reply With Quote Reply With Quote
  3. 03-01-2001 03:28 PM #3
    wren01
    wren01 is offline Junior Member
    Join Date
    Jan 2001
    Posts
    71
    is 8 a problem?
    Reply With Quote Reply With Quote
  4. 03-01-2001 03:30 PM #4
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    in NT Yes. There are some issues...Oracle recommends 4 letter Instance but, not db name.
    Reddy,Sam
    Reply With Quote Reply With Quote
  5. 03-01-2001 03:31 PM #5
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    TRUE Reddy.
    Reply With Quote Reply With Quote
  6. 03-01-2001 03:56 PM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    in NT it's 4 because of file name issues

    normally init.ora is initSID.ora if SID was 5 letters we would get init12345.ora which is not 5.3 format (MS-DOS standard file format) and causes problems
    Reply With Quote Reply With Quote
  7. 03-02-2001 07:24 PM #7
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    BTW, in 8i the maximum length of SID can be 64 characters (not 8 or 4).

    I myself still folow my personal rule: SID=4 characters long, DB_NAME is the same as SID. Old habits, I guess....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  8. 03-03-2001 02:47 PM #8
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Jmodic,

    TRUE. It makes me comfortable to have all the database/instances in one format/naming convention, espectially if you have 10`s and 100's of databases like we do.
    Reddy,Sam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width