Re: Q: Length of SID name on Unix systems

Hi Don,

Internally, Oracle allows 9 bytes for the database name and 16 bytes for the instance name. These are null terminated strings, so the available length is one less. For the instance name, all characters, even beyond 15 are significant for distinguishing instances, but if an instance name exceeds 15 characters Oracle gives up and does not record its name internally at all. This is fine in a single instance configuration, but I would not be confident to try it in an OPS environment, although logic says that it should be OK.

Anyone else?

Regards, Steve Adams

>We are bringing up Oracle on a SUN Solaris box
>
>It looks like the ORACLE_SID is limited to 4 characters. Is that
>true? That seems REALLY short, especially since we are going to have
>a number of instances running.
>
>Don
Received on Thu Oct 02 1997 - 00:00:00 CEST