Connect string appears to be case sensitive!!!

Here's the setup :

zeus server : Solaris 2.5, Oracle 7.3.4

apollo server : Solaris 7, Oracle 8.1.6

duke server : Digital Unit ?, Oralce 8.0.5

We moved database PROD from zeus to apollo, so a 7.3.4 database became a 8.1.6 database.

On zeus (7.3.4) we try to connect to PROD (8.1.6) we get this behavior:

Using an upper-case connect string :

% sqlplus gollum_at_PROD

	SQL*Plus: Release 3.3.4.0.1 - Production on Thu May 11
	 09:47:09 2000

	Copyright (c) Oracle Corporation 1979, 1996.  All rights
	 reserved.

	Enter password:
	ERROR: ORA-12505: TNS:listener could not resolve SID given in
	 connect 	descriptor


	Enter user-name:

Using a lower-case connect string :

% sqlplus gollum_at_prod

	SQL*Plus: Release 3.3.4.0.1 - Production on Thu May 11
	 09:48:23 2000

	Copyright (c) Oracle Corporation 1979, 1996.  All rights
	 reserved.

	Enter password:

	Connected to:
	Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
	With the Partitioning option
	JServer Release 8.1.6.0.0 - Production

	PROD >

On our duke server (8.0.5) as well as from a PC (7.3.4 client) we have no problems connecting with a lower or upper case connect string.

I have removed references to PROD from listener.ora and oratab on zeus, where it used to reside but am wondering if this problem might be related to the fact that PROD used to be on zeus and this server is the only one that has this case sensitivity issue (probably grasping at straws here).

For all servers (zeus, duke, PC) the connect string for PROD is the same (but they are different TNSNAMES.ORA, duh).

Any suggestions? Received on Thu May 11 2000 - 00:00:00 CDT