Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer cannot connect over VPN, only LAN

2692840Aug 5 2014 — edited Aug 6 2014

Oracle SQL Developer 4.0.2.15 is unable to connect to Oracle database over the Cisco VPN tunnel. Connection test displays "Status : Failure - Test failed: IO Error: The Network Adapter could not establish the connection." Trying to connect the message adds Vendor Code 17002

Oracle server is running RAC and database 11.2.0.4. SQL Developer can successfully connect if client is directly on the LAN.

Other things tested on VPN:

TELNET on port 1521 works

TNSPING is successful

Oracle SCAN FQDN is resolving propely  via ping and nslookup

Connections used to work fine prior to Oracle RAC reinstall. After new fresh of RAC/Database installation, VPN connections started failing. The same configuration was used as in previous install.

Server OS is Windows 2008 Enterprise R2.

I've researched the issue extensively, I saw similar threads regarding VPN, but no solutions worked.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Aug 5 2014
1 comment
1,973 views