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
Replacing NAT adapter with Bridged adapter
-
socratis
- Site Moderator
- Posts: 27329
- Joined: 22. Oct 2010, 11:03
- Primary OS: Mac OS X other
- VBox Version: VirtualBox+Oracle ExtPack
- Guest OSses: Win(*>98), Linux*, OSX>10.5
- Location: Greece
Re: Replacing NAT adapter with Bridged adapter
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?
Do NOT send me Personal Messages (PMs) for troubleshooting, they are simply deleted.
Do NOT reply with the "QUOTE" button, please use the "POST REPLY", at the bottom of the form.
If you obfuscate any information requested, I will obfuscate my response. These are virtual UUIDs, not real ones.
Do NOT reply with the "QUOTE" button, please use the "POST REPLY", at the bottom of the form.
If you obfuscate any information requested, I will obfuscate my response. These are virtual UUIDs, not real ones.
Re: Replacing NAT adapter with Bridged adapter
@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
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