Skip to Main Content

Breadcrumb

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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer

Connor McDonald

Thanks for the question, Christian.

Asked: July 24, 2017 - 2:40 pm UTC

Answered by: Connor McDonald - Last updated: July 25, 2017 - 1:09 am UTC

Category: Database Administration - Version: Oracle 8 - 12

Viewed 10K+ times! This question is

Whilst you are here, check out some content from the AskTom team: FORALL and ROLLBACKs

You Asked

Hi,

What is the maximum length an Oracle SID can be? I've read some documentation stating it can be between 8 and 16 characters, depending on version, but also some documentation warns of errors if trying to create a SID of greater than 8 characters. Is there is definitive answer to this please?

Thanks.

C

and we said...

From the 12.2 documentation:

"It is common practice to set the SID to be equal to the database name. The maximum number of characters for the database name is eight. For more information, see the discussion of the DB_NAME initialization parameter in Oracle Database Reference."

So even if you find a platform that does more than 8, I would never go more than that.

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

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database