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 Connection Error: Status : Failure -Test failed: IO Error: The Network Adapter could n

OracleUser0815Jul 29 2013

Hi, I'm running the following setup:

Mac OS X 10.8.4

Virtual Box 4.2.16 r86992

Oracle Developer Days (don't know the version, just downloaded it)

SQL Developer 3.2.20.09

Networking is host-only, I tried bridged but that doesn't make a difference for the problem at hand. I can ping my virtual box just fine, telnet to port 1521 looks good too:

$ ping 192.168.56.101

PING 192.168.56.101 (192.168.56.101): 56 data bytes

64 bytes from 192.168.56.101: icmp_seq=0 ttl=64 time=0.449 ms

^C

--- 192.168.56.101 ping statistics ---

1 packets transmitted, 1 packets received, 0.0% packet loss

round-trip min/avg/max/stddev = 0.449/0.449/0.449/0.000 ms

$ telnet 192.168.56.101 1521

Trying 192.168.56.101...

Connected to 192.168.56.101.

Escape character is '^]'.

asdf

asdf

Connection closed by foreign host.

When I create a new connection with sql developer, with the same hostname / IP (192.168.56.101), Port 1521 (didn't change that) and SID orcl, basic connection type, it can't even connect, throwing the error mentioned in the subject:

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

I have looked at various threads in the forums here but I'm still stymied why the connection seems to be ok, yet sql developer has problems with it. If I create an ssh tunnel so sql developer only has to connect to localhost it works:

ssh -L 1521:192.168.56.101:1521 -l oracle 192.168.56.101

Message was edited by: 2a2e67cd-b5b2-4229-9fa6-21f5dfe0760d

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2013
Added on Jul 29 2013
0 comments
1,142 views