VMware Communities > VMTN > Desktop Products > VMware Fusion > Discussions
Up to Discussions in VMware Fusion
Actions

Incoming Links

This Question is Answered

2 "helpful" answers available (6 pts)
4 Replies Last post: Jan 23, 2008 2:12 PM by jkil
Reply

Host Access to Database on VM

Oct 31, 2007 4:57 AM

Click to view CharleyD's profile Lurker CharleyD 2 posts since
Oct 30, 2007

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

Tags: fusion, host-only, oracle, windows_xp
Reply Re: Host Access to Database on VM Oct 31, 2007 5:43 AM
Click to view etung's profile Champion etung 6,549 posts since
Oct 15, 2006 VMware
To confirm, you can ping the guest from the host? Dumb question: is there a firewall on the guest?
Reply Re: Host Access to Database on VM Oct 31, 2007 6:17 AM
in response to: etung
Click to view CharleyD's profile Lurker CharleyD 2 posts since
Oct 30, 2007
The firewall was on. Dumb mistake. Thanks.
Reply Re: Host Access to Database on VM Jan 15, 2008 7:55 PM
in response to: etung
Click to view kbs05's profile Lurker kbs05 1 posts since
Jan 15, 2008
This also worked for me. It's amazing how many headaches silly mistakes can cause.
Reply Re: Host Access to Database on VM Jan 23, 2008 2:12 PM
in response to: kbs05
Click to view jkil's profile Lurker jkil 2 posts since
Jan 23, 2008
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.
Up to Discussions in VMware Fusion