virtualbox.org

Hi,

I have virtualbox installed on my host windows 8.1 machine. I have 2 VMs created - 1 for DB tier and 1 for Oracle E-business suite application tier. I have 2 adapters enabled - host-only and NAT. I am unable to connect to the database (running on my VM) via SQL Developer(running on my host - windows).

I am unable to fix the issue using port-forwarding and considering trying to use a bridged adapter.

If I leave the host-only adapter as-is and replace NAT adapter with bridged adapter, would it fix the issue? Also, would it cause any issues with accessing the e-business suite application?

Do let me know if more details are needed.

Thanks in advance
AV

If you have the host-only adapter enabled and configured properly you should be able to talk to your host. There should be no need for NAT (with or without port forwarding) or Bridged, unless you want to have internet connectivity. Maybe you have your firewall enabled on your host and it is blocking any connection attempts?

@socratis : Hi, thanks for responding. Yes, I had enabled NAT adapter to be able to connect to internet from within guest OS. My host-only adapter was configured correctly .

Issue was with port number I was specifying in SQLDeveloper. I was trying to use default port 1521 with port-forwarding settings. Turns out I needed to add the port-pool-value (in my case 42) to 1521=1563.

This fixed the issue and I am able to connect to the database on guest OS from sqldeveloper on host OS with the following SQLDeveloper settings.

Hostname : <ip-address-of-guest>
Port : (1521 + port-pool-value)
SID : <sid-of-db>

Regards
AV