BUG ALERT!!!! on SID names

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1997/02/27
Message-ID: <5f51d1$pc6$2@news.inc.net>#1/1

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. Received on Thu Feb 27 1997 - 00:00:00 CST