Re: make cx_Oracle bind to a specific IP address or network interface?

Anthony Tuininga <[email protected]> Tue, 19 Apr 2016 18:59:48 -0600
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CAE1XR-4RM94jsKrxy=Chfa+=_ncMemqOJ_jA7zOz2CEXf1Xr8A@mail.gmail.com>
Hi Dan,

Not sure if this will help or not....but it is worth a shot. :-)

http://stackoverflow.com/questions/27032429/how-to-bind-a-raw-socket-to-a-specific-interface-using-python-in-linux-centos

Anthony

On Tue, Apr 19, 2016 at 6:42 PM, Daniel Lenski <[email protected]> wrote:

> 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
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

------------------------------------------------------------------------------
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

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users