I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the Virtual Machine)
$ sqlplus /nolog SQL*Plus: Release 126.96.36.199.0 Production on Sat Apr 21 14:32:48 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn myusername/mypassword Connected. SQL> select count(1) from my_table; COUNT(1) ---------- 73 SQL>
However, when I try to connect using JDeveloper from the Host Machine, I am getting
Status : Failure - Test failed: IO Error: The Network Adapter could not established the connection.
I tried connecting to other databases from our intranet from the JDeveloper of the Host Machine and they do succeed. Also, I tried turning off the iptables of the Virtual Machine (just in case).
sudo /etc/init.d/iptables stop
So far though, nothing works.
EDIT: Update: I have just installed sqlplus on my host machine (note to others: instantclient 10.2.0.4.0 64bit does not work on mac. Use the 32-bit instead even if your mac is 64 bit like mine.), and I tried connecting to my oracle db in my virtual machine and it succeeded! However, I still cannot connect using JDeveloper.