How many characters can an oracle sid be

The system identifier SID for each database must begin with an alphabetic character, and is limited by the installer to 12 alphanumeric characters in length.

Thanks a lot for the explanation. Your blog cleared many doubts I was having. Just one little thing. Can the instance name be altered while the instance is running?

However you can change it in pfile and restart the instance using that pfile. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Hong Wang's Oracle Blog. Create a free website or blog at WordPress. Search Search for: Go.

Database , Oracle. This is for 11gR2. Share this: Twitter Facebook. Like this: Like Loading Worked in both application development and production support.

Rob and Tom said The reason is in support of 8. ORA, etc. We use 4, you use 4 and we can get 8 character filenames. See your OS guide for the max's on your OS. Rating 6 ratings Is this answer out of date? 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.

Questions Number of characters in SID. Question and Answer. A reader, January 02, - pm UTC. Besides the 8. January 02, - pm UTC. We only use part of it in the key -- so, longer sids could result in the same key being generated for two sids under the same oracle home. So, using just the first four and the fact that a sid must be unique, avoids any issues with regards to the key generation.