• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 703
  • Last Modified:

It's a dozy. How can I connect to an Oracle DB which is contained in a virtualized Ubuntu 10.10 instance on my Mac?

Here is the situation, I've installed Oracle XE onto a virtualized Ubunto 10.10 instance on my Macbook Pro.  The database is up and running, but I can't seem to connect to it from the main server instance (OS X).  

Of course, I'm trying to connect to 127.0.0.1 on the Mac to the 127.0.0.1 ip address of the Ubuntu instance.

Help!
0
eikonomega
Asked:
eikonomega
2 Solutions
 
slightwv (䄆 Netminder) Commented:
127.0.0.1 is the loopback adapter. It can only see itself.

You need to set the ubuntu server to an IP address that your Mac can see and visa versa.

Once you can ping back and forth, then set up the oracle listener.ora to listen on the ubuntu ip address.
0
 
swadhinrayCommented:
Check if you are able to ping the virtual PC name from command prompt.

open your mac and check with is the ip and open virtual machine and check it should show you a different IP,

Then set the virtual IP in your TNS entry and check if you are able to access your VM DB.
0
 
bgoeringCommented:
If you set your vm to bridged networking it will obtain an ip address on the same network segment as the mac book's adapter (assuming you have a dhcp server on that segment). If you don't have a dhcp server still set networking to bridged and give it a static ip address on the same subnet as the mac book - then you will be able to connect to Oracle at that address.

Good Luck
0
 
swadhinrayCommented:
as bgoering said try to set networking to bridged then it will provide you the subnet ip
0
 
roylongCommented:
what virtualisation application are you using to virtualise the Ubuntu?  If you specify which app (VMware Fusion, Parallels...) I can send instructions on how to set up your networking within your Ubuntu instance to allow access.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now