ORA-12154 ?!!?!?

From: MattJ83 <mattjones_at_hotmail.co.uk>
Date: 23 Oct 2006 09:01:56 -0700
Message-ID: <1161619316.268776.176060@m73g2000cwd.googlegroups.com>

Im getting a bit of a headache......

Im getting this nasty error:
DBI connect('server','database',...) failed: at ./code.pl line 22 couldn't connect to database: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach)

its a perl script that i have written. It seems to work fine on server #1 but not on server #2.
The env settings are different between these servers. but only in the PATH settings. Server #1 doesn't even have a ORACLE_HOME setting but it works.

I have checked the TNSnames_file on the server with one that is working. They are really big so haven't gone through them all but the bits I am interested in (relating to the database) are there and i have done random checks and they seem identical.

Anyone got any idea about this? Its driving me insane! Received on Mon Oct 23 2006 - 11:01:56 CDT