Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BUG ALERT!!!! on SID names
In article <5f51d1$pc6$2_at_news.inc.net>, sds_at_dataplusnet.com says...
>
>Running Oracle 7.1.6 on AIX 4.1.4 and tried to create another instance.
>Couldn't create because after a connect internal(ORACLE_SID=smtest) in sqldba, I was
>connected to an existing instance(nwtest).
>
>Went around with Oracle Support for 4 days and they finally said:
>
>'Oracle hashes the SID name to a number and uses the number to make the connection.
>Apparently 'smtest' and 'nwtest' hash to the same number!!!!.
>
>The fix is to change the sid name to something other than smtest.
>
Oracle got back again and said this is fixed in 7.2 and up. Received on Fri Feb 28 1997 - 00:00:00 CST