[cx-oracle-users] Strange TNS issue with new build of cx_Oracle.so

[Michael S. <mic...@ho...>]

Hi
Here's the platform(s)
 
Sun Sparc running Solaris
Sun Opteron running Solaris
 
Database(s) Oracle 9i and Oracle 10g (10.1) and(10.2) 
 
Python version 2.4.2 on Sparc, version 2.5.0 on Opteron
 
I've downloaded the cx_Oracle version 4.4 source code.
I'm trying to build this for Oracle 10g in a (10.2) environment.
 
I have TNS_ADMIN, ORACLE_HOME both set.
LD_LIBRARY_PATH gets set based on the platform.
 
Because we need to have python support 9i, 10g and probably 11i in a couple of months, 
we keep the cx_Oracle.so in a different directory than the site-packages subdirectory and then include it in my PYTHONPATH and LD_LIBRARY_PATH.
 
When I start up python (2.4.2) on Sparc, this works fine and everyone is happy.
When I start up python (2.5.0) on Opteron, I can import cx_Oracle, but when I try to get a connection using the 
cx_Oracle.Connection() method, I get a TNS error.
 
If I use the cx_Oracle.makedsn() and then use the cx_Oracle.connect(), I can get a connection.
(This method bypasses the check in the local tnsnames.ora file)
 
So what am I missing?
 
Whatwould cause cx_Oracle to fail its TNS check?
 
TIA
 
-Mike
_________________________________________________________________
It’s a talkathon – but it’s not just talk.
http://www.imtalkathon.com/?source=EML_WLH_Talkathon_JustTalk