Re: [cx-oracle-users] Strange TNS issue with new build of cx_Oracle.so
Brought to you by:
atuining
From: Anthony T. <ant...@gm...> - 2008-07-10 19:58:22
|
First, what TNS error? Second, check to see what the makedsn() returns and compare with what is stored in your tnsnames.ora file. I can think of no reason why the new version of cx_Oracle would have a problem compared to the old version. Anthony On Thu, Jul 10, 2008 at 9:02 AM, Michael Segel <mic...@ho...> wrote: > 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. Check out the i'm Talkathon. > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |