PL/SQL Developer on Windows XP VM

[freemink]

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

...
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.

[stefan.becker]

First try dsabling firewalls on host and guest.

[freemink]

Windows XP (guest) Firewall is off. No firewall on MacBook OS X (host).

[vbox4me2]

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.

[freemink]

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

[vbox4me2]

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.

[freemink]

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!