Skip to Main Content
  • Questions
  • How to make SID longer than 8 characters?


Question and Answer

Chris Saxon

Thanks for the question, Keane.

Asked: December 25, 2006 - 9:55 pm UTC

Last updated: June 12, 2024 - 9:46 am UTC

Version: 10.2.0

Viewed 1000+ times

You Asked

Hi Tom,

When I was using 10g EM to clone an instance, it restricted me to creating database name and sid to be larger than 8 characters. The oracle is installed in NT. Is there a way to bypass the restriction? Thanks a lot.


and Tom said...

that is the only supported length, it must be 8 or less.


  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment


I have found my answer

Keane, January 02, 2007 - 8:30 pm UTC

Hi, are you saying sid must be 8 characters or less for oracle 10.2.0? if yes, then you are wrong. I used DBCA to create a new database with sid longer than 8 chars.

Anyway thanks for your time.
Tom Kyte
January 05, 2007 - 7:47 am UTC

did you not read the referenced document, from the 10.2 documentation set.

I'll say it again:

just because something let you - you will have problems with other tools that expect just 8. It is not something I would recommend or do

The sid is in general never exposed, I would seriously recommend you keep it at 8.

8 character limit

Tim R, June 11, 2024 - 5:02 pm UTC

Tom is absolutely correct. I am using legacy code still written for Tecnomatix 2402 (latest release) and the 8 character limit is the issue. Not Oracle per say, but the utility connecting to the SID value. the POINT: Stick to Tom's recommended 8 character SID ALWAYS...
-TR - EliteDigitalSolutions 6-11-2024
Chris Saxon
June 12, 2024 - 9:46 am UTC

Thanks for sharing. Even in Oracle Database 23ai, the limit for database names is still 8 bytes.