Host Access to Database on VM

[CharleyD]

I am running a Windows XP virtual machine using VMWare Fusion 1.0 Build 51348 on a MacBook Pro host running OS X 10.4.10. I have set the network for that vm to Host-Only since I do not need external access. Normally the host is using an expresscard to Verizon broadband. The ifconfig -a command displays

vmnet8: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500

inet 172.16.110.1 netmask 0xffffff00 broadcast 172.16.110.255

ether 00:50:56:c0:00:08

vmnet1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500

inet 172.16.183.1 netmask 0xffffff00 broadcast 172.16.183.255

ether 00:50:56:c0:00:01

There is a Oracle database running on the Windows vm and I would like to access that database using JDBC development tools on the Host. I can ping the addresses indicated in the vmnet8 and vmnet1 but when I attempt a JDBC connection to the database it fails. I have verified that the database is configured for external access and that the other JDBC settings are correct.

Is this possible? If so has anyone done it who can give me some advice on setting it up?

Thanks

[admin · Accepted solution]

To confirm, you can ping the guest from the host? Dumb question: is there a firewall on the guest?

[CharleyD]

The firewall was on. Dumb mistake. Thanks.

[kbs05]

This also worked for me. It's amazing how many headaches silly mistakes can cause.

[jkil]

I am having difficulty accessing the Oracle DB running in XP under Fusion using SQL Developer running on the host. Here are some details.

Guest network device set to NAT

Firewall turned off on the Guest

Guest ipconfig=

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . : localdomain

IP Address. . . . . . . . . . . . : 192.168.254.128

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.254.2

-

---

Host ifconfig -a :

vmnet8: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500

inet 192.168.254.1 netmask 0xffffff00 broadcast 192.168.254.255

ether 00:50:56:c0:00:08

vmnet1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500

inet 192.168.105.1 netmask 0xffffff00 broadcast 192.168.105.255

ether 00:50:56:c0:00:01

-

---

Host name within SQL Developer is set to 192.168.254.128, in addition I've set correctly the service name, user and password etc.,

Thanks for the help.