I have latest Oracle Sql Developer 3.2.1 installed, and I cannot connect to databases. I typed correct SID, port number, user and password and it won't connect saying: "The Network Adapter could not establish the connection. Vendor code: 17002"
Do I need oracle client installed on my machine to connect to remote server using sql developer?
I am tunelling the connection using putty SSH to remote machine, and I put localhost as host in connection details in sql developer, but it works on another computer. I have also JDK 1.7.0_06 installed, and while starting sql developer I get warning that this product is supported with minimum version of 1.6.0_04 and less than 1.7. May this be problem?
Vendor code 17002 generally means a major network problem like invalid host or port number. Using ssh tunneling complicates the troubleshooting. It may be best to try to replicate the other machine setup as far as possible, including ssh setup, name resolution and sql developer configuration.
These are the normal troubleshooting steps.
Given a SQL Developer connection definition of DBSERVER, 1521, ORCL...
Can you ping DBSERVER?
Can you telnet to DBSERVER on port 1521 (telnet DBSERVER 1521). If you don't have windows telnet you can use a putty telnet session.
I assume somewhere in your tunnelling setup you have something like locahost:1521 mapping to DBSERVER:1521. In that case you can replace localhost in the troubleshooting steps.