Re: [Q] DBNAME length > 4 characters ?

On Sun, 08 Dec 1996 10:28:26 -0500, Huy Vu <huyv_at_usa.net> wrote:

>I would like to know if it is acceptable or not to have the instance
>name length longer than 4 characters?
>
It is but Oracle recommend against it. This is due to the filename length restrictions on som 'old' UNIX system where you could not have filename longer than 14 characters (some NCR boxes had this I know for sure). Hence a SID of "ALONGSID" (the maximum is 8 characters) would have a file - that you couldnt do ANYTHING about called: sgadefalongsid.ora - which is 18 characters and would be truncated. Hence preventing your database from starting.

>Oracle version 7.1.4 and 7.1.6
>O/S : Irix 5.3 and Aix 4.1.4
>
>And is it possible or not to rename a instance with oracle?
>
It sure is.
The March/April 1996 issue of the Oracle Magazine carries an article explaining in detail how to do it. The article is TOO LONG to copy here (if at all legal) but you can get it at:

http://165.121.1.131/archives/26dba.html

>Thank you for any help.
>
>=======================================================================
>Huy Vu Mitech Computer Systems inc. Email: huyv_at_usa.net
> Tel: (514)340-9951 ext:315 Fax: (514) 340-9956
>=======================================================================

Kein problem old bean.

Regards,

Rick H.

DBA Extraordinairre. Received on Tue Dec 10 1996 - 00:00:00 CET