make cx_Oracle bind to a specific I P address or network interface?

Daniel Lenski <[email protected]> Wed, 20 Apr 2016 00:42:43 +0000 (UTC)
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <[email protected]>
Hi all,

Is there a way to make sure that cx_Oracle uses a specific network
interface or IP address for its connections to Oracle server? This
would be something comparable to "ssh -b BIND_ADDRESS".

The reason I need this is because I'm using a split VPN tunnel to
connect to a client's Oracle server, and I get errors when I tried
to connect using the non-VPN network interface. Because I'm mostly
developing and testing as a non-privileged user, adding a route that
forces the client server connections to a specific interface isn't ideal.

I thought this might be an Oracle client library reponsibility, and
looked through the Oracle 11g environment variables in the documentation, 
however I don't see anything relevant: 
https://docs.oracle.com/cd/E11882_01/server.112/e10839/admin_ora.htm#UNXAR116

Any suggestions on how to make cx_Oracle use a specific interface?

Thanks,
Dan


------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z