TOAD Oracle connection through SOCKS Proxy Server

Toad for Oracle & DevOps Toolkit
1

I’m currently working on a project that requires me to connect to an Oracle Database through a SOCKS 5 Proxy Server. I’m able to do so with SQL Developer by changing the ide.conf to include java -DsocksProxyHost= settings. However, I would rather use TOAD and I’m having trouble figuring out how to do so or finding info on the Web.

Anyone know how to do it? I’m figuring, either it’s really easy and that’s why I can’t find any info, or it’s not a common feature.

Thanks for the help.

2

Hi Robert,

SQL Developer uses JDBC. Toad uses the OCI to connect to the database. SQL Plus
uses the OCI too. I don’t know anything about SOCKS 5 Proxy Servers, so I
don’t know if it is possible or not through the OCI, but if you can get
SQL Plus to connect to it, the same trick should work in Toad.

-John

3

I was able to get SQL Developer to work with JDBC by using Java specific settings for the JDBC connection through a SOCKS firewall.

Unfortunately, I can’t apply those same settings to the OCI connection. Maybe this question isn’t for TOAD, but for how to connect the OCI through a SOCKS 5 firewall.

I guess I just made the assumption that TOAD had the capability. I noticed the DBVisualizer (another JDBC Based DB Client) has the SOCKS settings in their user configuration. So maybe this is an OCI issue.

4

may be something useful here -

5

Yeah, that was the first link that I had found. However, by default, unless you are using Java/JDBC thin client, there doesn’t seem to be a way to connect an oracle client through a SOCKS firewall.

Looks like there is a couple of options:

  1. Use “socksify”, a command line tool for connecting through a firewall. However, that will only work with SQL Plus. I was successfully able to do this.

  2. Use a Java/JDBC thin driver based Oracle Client and use the Java JVM SOCKS firewall system environment settings. I was successfully able to do this.

  3. Set up SSH on the Oracle Server on the other side of the firewall, and utilize PUTTY to tunnel the SSH traffic from the OCI client to the Oracle Server. I haven’t been able to get this to work.

  4. I have read that you can set up an Oracle Connection Manager to handle the connection through the SOCKS firewall. I haven’t attempted to do this, seems to be heavy handed for this particular setup.

Looks like I won’t be able to use TOAD for now.

Thanks for the help.