connect to oracle through socks proxy

My application (linux and windows) connects to oracle through OCI interface. Is it possible to connect to oracle through socks proxy? or some other similar proxy method? Sim开发者_Python百科ple ssh tunnel is not enough as I need to access multiple services (including oracle) through single port.

Edit: I have tried configuring the proxy as suggested in the answer, but it did not work. And I could not find anywhere information, that oracle can work through socks5 proxy.

I got the same issue to get solved. Anyway the solution above cannot work. You need to tell the client to just USE the proxy for connection initialization, but the target to connect to is supposed to be the oracle database server IP and port. Other forums read there is no such possibility via tnsnames.ora. But you're supposed to be able to achieve that using the Connection Manager. Haven't found out yet how to even download and install it though...

As I see Oracle doesn't support socks proxy.

To work around this for my self I did following:

1. Install proxifier www.freecap.ru
2. Start PL/SQL Developer from freecap

As I can see - this method not always work. PL/SQL Developer was able to connect to database only on 3-4 try. But after successful connect - it's seems stable enough for work.

Second option - is to use Java based tools like SQL Developer. For Java there is system options for using SOCKS5 out of the box. -DsocksProxyHost=localhost -DsocksProxyPort=8081

there is official doc about SOCKS in java

Yes, this is possible. Your client tnsnames.ora file (or EZConnect string) should specify the proxy host as the database host, and the proxy listening port as the port. The SERVICE_NAME or SID is whatever the SQL*Net listener on the other side of the proxy is expecting.

[Edit] If your proxy host is listening and forwarding on 1522, you should be able to:

telnet proxyhost 1522

and see:

Trying xx.xxx.xx.xxx...
Connected to proxyhost.domain.
Escape character is '^]'.