PL/SQL Developer on Windows XP VM

Discussions related to using VirtualBox on Mac OS X hosts.

PL/SQL Developer on Windows XP VM

Postby freemink » 12. Apr 2009, 12:18

Hello.

I installed VirtualBox to run Windows XP on my Intel MacBook OS X 10.5.6 for one reason and
I've got everything working except the one thing I really need - and that is PL/SQL Developer.

The aim is to allow me to connect pl/sql developer to a database across vpn when I'm working
from home. I have installed all the necessary components (Oracle client, etc) on the virtual XP.
I connect to the VPN from the OS X host (checkpoint vpn-1 secureclient).

From (virtual) XP I can ping and ssh to the database server. I can connect from the command
line using sqlplus. But from PL/SQL developer I keep getting "TNS: Connect timeout occured".
tnsnames.ora looks fine - I can tnsping the database.

Running "netstat 5" from Dos terminal it looks like there is a name resolution problem:
Code: Select all   Expand viewCollapse view
...
Active Connections
 TCP    xp-pc:1064        hit-nxdomain.opendns.com:1521     SYN_SENT

I would have hoped to see
 TCP    xp-pc:1064        tahiti:1521     SYN_SENT


I've tried evrything I can think off, and would really appreciate some help.

Oh yeah - I also tried to install the vpn client on the virtual machine, but couldn't get that to
connect either!

Thanks in advance,
Darrell.
freemink
 
Posts: 4
Joined: 12. Apr 2009, 11:48
Primary OS: Mac OS X Leopard
VBox Version: OSE other
Guest OSses: Windows XP

Re: PL/SQL Developer on Windows XP VM

Postby stefan.becker » 12. Apr 2009, 19:31

First try dsabling firewalls on host and guest.
stefan.becker
Volunteer
 
Posts: 7612
Joined: 7. Jun 2007, 21:53

Re: PL/SQL Developer on Windows XP VM

Postby freemink » 12. Apr 2009, 19:42

Windows XP (guest) Firewall is off. No firewall on MacBook OS X (host).
freemink
 
Posts: 4
Joined: 12. Apr 2009, 11:48
Primary OS: Mac OS X Leopard
VBox Version: OSE other
Guest OSses: Windows XP

Re: PL/SQL Developer on Windows XP VM

Postby vbox4me2 » 12. Apr 2009, 19:56

Try connecting the Guest via Host interface/bridge, the Guest will be like a real pc on your LAN where vpn and pl/sql should work.
vbox4me2
Volunteer
 
Posts: 5218
Joined: 21. Nov 2008, 20:27
Location: Rotterdam

Re: PL/SQL Developer on Windows XP VM

Postby freemink » 13. Apr 2009, 00:53

Tried connecting using a Bridged Connection (I was using NAT before) but still no luck.

I have to connect using the host wireless connection as ethernet port on my macbook seems
to have stopped working (I only noticed today as I'm on wireless most of the time). Anyway,
the manual suggests that connecting using host wireless should work - albeit with a few
restrictions.

When I try to setup the vpn connection it can't connect - just stays on the 'Connecting ...'
step when I run the Site Wizard - until it timesout. Searching the forums it looks like setting
up Checkpoint VPN (SecureRemote / SecureClient) is not trivial. In fact I don't think I've come
across any messages confirming checkpoint vpn can be installed on mac/windows??

If Checkpoint VPN could be installed, then I'm sure pl/sql developer woud work.
But if I can't get vpn working, then that puts me back to using NAT mode, where most
of the apps I need are working fine, but pl/sql developer can't connect.

Any more advice gratefully received .....

Thanks,
Darrell
freemink
 
Posts: 4
Joined: 12. Apr 2009, 11:48
Primary OS: Mac OS X Leopard
VBox Version: OSE other
Guest OSses: Windows XP

Re: PL/SQL Developer on Windows XP VM

Postby vbox4me2 » 13. Apr 2009, 12:20

I have gotten vpn to work with NAT so it is possible, it can be a router problem or the way your Host reacts, you will have to fiddle using a bridge to get something to work between the Guest and your internet access point, after that vpn should work as well. Maybe some other mac user has more info.
vbox4me2
Volunteer
 
Posts: 5218
Joined: 21. Nov 2008, 20:27
Location: Rotterdam

RESOLVED: PL/SQL Developer on Windows XP VM

Postby freemink » 13. Apr 2009, 13:42

Hi,

Thanks for the help. I have just managed to get it working:

I run Windows XP in NAT mode (I couldn't get vpn software to work in the guest so I needed to rely
on the host vpn connection).

Anyway, reinstalled Oracle Instant Client and pl/sql developer, and spent a bit of time making sure
that sqlnet.ora and tnsnames.ora were correct, and that pl/sql developer could see them etc. Then
it just worked. After about 12 hours of fiddling around it boiled down to reading the documentation
properly!

Some details here:
http://www.allroundautomations.com/thre ... #Post33787

Now I can enjoy relax and enjoy my day off!
freemink
 
Posts: 4
Joined: 12. Apr 2009, 11:48
Primary OS: Mac OS X Leopard
VBox Version: OSE other
Guest OSses: Windows XP


Return to VirtualBox on Mac OS X Hosts

Who is online

Users browsing this forum: No registered users and 16 guests