Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Virtual PC / December 2004



Tip: Looking for answers? Try searching our database.

Access to Oracle running on OSX from application running on VPC

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Preston - 23 Nov 2004 17:07 GMT
I am a new user of VPC. I have a couple of products I use which only
run on Windows so I use VPC.  One of these products talks to Oracle
databases. If the Oracle database is on some remote client then
everything works, no problem.

I also have an Oracle 10g database running on the same MAC as VPC and
I am struggling to make the conenction work. The Oracle database on
the mac runs fine and does all it should (jDeveloper, SQLPlus etc all
work well on the MAC and the listener starts and runs and I can
connect to the database from other user accounts created on the MAC).

I have downloaded "instant client for windows XP" from Oracle and
installed it and it works. I have configured a set up file
(tnsnames.ora) which maps the IP address and port of the Oracle
database against a database name. This works because I can use SQLPlus
from the DOS prompt on VPC to connect to a remote server running
Oracle. However, when I put in the IP address of my MAC I get an error
message that no Oracle listener is running, so it finds the IP address
but doesn't see Oracle at that address.

So question is:   is the IP address of my MAC (127.0.0.1) being copied
by VPC so that when I ping 127.0.0.1 (from the DOS prompt) I am
actually pinging the VPC machine and not the host MAC?? That would
explain why it thinks there is no listener. So how do I give the VPC
it's own IP address so that I can be sure I see the MAC on IP address
127.0.0.1 ???

I think my question is erally about getting VPC to see an IP address
as the host MAC and not as itself.  Any help appreciated.
Robin Walker - 23 Nov 2004 19:46 GMT
> So question is:   is the IP address of my MAC (127.0.0.1) being copied
> by VPC so that when I ping 127.0.0.1 (from the DOS prompt) I am
> actually pinging the VPC machine and not the host MAC?? That would
> explain why it thinks there is no listener. So how do I give the VPC
> it's own IP address so that I can be sure I see the MAC on IP address
> 127.0.0.1 ???

Within the VPC guest OS, 127.0.0.1 means "myself", i.e. the Windows system,
not the host Mac.

How do you have the virtual network card of the VPC bound to the host, in
terms of the various options that VPC offers?

Signature

Robin Walker
rdhw@cam.ac.uk

Paul Preston - 25 Nov 2004 17:01 GMT
Robin

thanks for your reply.  I took the defaults at installation which has
the enable networking box checked and the shared networking button
checked.  Any other options you need to know about?

BTW I am running on a Powerbook so actual network card is all built
in.  I am usually not connected to an ethernet network (but sometimes
am).

Thanks

Paul

> > So question is:   is the IP address of my MAC (127.0.0.1) being copied
> > by VPC so that when I ping 127.0.0.1 (from the DOS prompt) I am
[quoted text clipped - 8 lines]
> How do you have the virtual network card of the VPC bound to the host, in
> terms of the various options that VPC offers?
Ted Thibodeau Jr - 29 Dec 2004 19:23 GMT
[[ This message was both posted and mailed: see
  the "To," "Cc," and "Newsgroups" headers for details. ]]

> Robin
>
> thanks for your reply.  I took the defaults at installation which has
> the enable networking box checked and the shared networking button
> checked.  Any other options you need to know about?

This is the problem.

The Mac and the VPC instance each need to have their own IP addresses
-- the VPC instance cannot share the Mac's address.

When you've changed this setting, you should be able to ping from each
to the other, e.g., --

  Mac   192.168.1.1
  VPC   192.168.1.2

When that works, you should find that the Oracle connections from VPC
to Mac work fine.

Note -- 127.0.0.1 translates to "myself", which in the VPC instance is
the VPC instance, and in the Mac is the Mac -- in neither case will
127.0.0.1 refer to the "other" machine.

Good luck,

Ted

Signature

A: Yes.                                       http://learn.to/attribute

| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tthibodeau@openlinksw.com
OpenLink Software, Inc.      //              http://www.openlinksw.com/
                                http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs              http://www.openlinksw.com/weblogs/virtuoso/
                              http://www.openlinksw.com/blog/~kidehen/
   Universal Data Access and Virtual Database Technology Providers
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.