Skip to Main Content
  • Questions

  • How to make SID longer than 8 characters?

Breadcrumb

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.

Regards,
Keane

and Tom said...

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


http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5004.htm#sthref6240

Rating

  (2 ratings)

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

Comments

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.
Keane
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.

https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/CREATE-DATABASE.html
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.