Good day,
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 11.2.0.1.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.
Any ideas?
Thanks,
Franz See
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.
sudo netstat --tcp --udp --listening --program | grep 1521
– Wesley Apr 21 '12 at 6:47