Strange TNSNAMES.ORA problem

I'm using OCI on Mac OS X and I've run into a strange problem with my TNSNAMES.ORA file.

My TNSNAMES.ORA file has one entry INV4II and it works fine. However, it will only work if that is the name of the entry. If I use any other name for that entry I get the dreaded ORA-12154. For example:

TNSNAMES.ORA -> INV4II Application -> INV4II :: works fine
TNSNAMES.ORA -> INV4DEV Application -> INV4DEV :: ORA-12154
TNSNAMES.ORA -> INV4DEV Application -> INV4II :: ORA-12154
TNSNAMES.ORA -> INV4II Application -> INV4DEV :: ORA-12154

It's almost like that name is referenced somewhere else and so changing tnsnames.ora isn't sufficient. But I cannot find any other file anywhere (client or server) that that contains INV4II.

I'm a bit confused, and any help would be appreciated.

Adam Ruth Received on Wed Feb 04 2004 - 22:04:16 CET