Accessing Oracle on VirtualBox from Host Virtual Machine

[dev.arrya]

Hello,

I have a Host system of windows 8, installed the Virtual Box Latest edition.
The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.
The VM is set to HOST ONLY network setting.

Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.
the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect the
SQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect.

PLEASE I need help, now please do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.

[Perryg]

Check firewall on the guest to see if the proper ports are allowed.

[dev.arrya]

No Perryg, that didnt help

[Perryg]

Then it must be a configuration issue and could be on the host client or the guest settings for sql. VirtualBox emulates the network and since you can ping the guest from the host it has done what it is designed to do. I think you should contact the Oracle forums and ask them how to configure the sql settings.