RE: Can an ORACLE_SID be set > 8 chars?

On what version?

I specifically remember SID being limited to 8 chars (5 actually) for 9i RAC using DBCA, and I think that 10g dbca limits sid to 8 chars as well.

I'm sure if you use 'create database' command it could be altered, I'd have to check the doc but I think that it's documented as 8 byte limit.

regards

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fmhabash_at_gmail.com Sent: Wednesday, October 29, 2008 5:05 PM To: oracle-l_at_freelists.org
Subject: Can an ORACLE_SID be set > 8 chars?

Hi all,
I have always set mine to a max of 8 chars. Today, by mistake, I set it up to 11 and it worked just fine. My research pointed to some evidence that an oracle_sid can actually be set up to 15 chars. Can anyone confirm this at all?

Thank you

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 29 2008 - 14:09:04 CDT