Can't connect from VirtualBox virtual machine

[freemink]

Hi,

I'm running Windows XP within VirtualBox on a Mac OS X host. On the Mac I connect to my company using vpn.

So, on the Windows (virtual machine) I can ping, and tnsping, and ssh, into the database server I'm trying to reach. I have Oracle client installed and pl/sql developer.

I followed the "Oracle Net Configuration Assistant -> Local Net Service Name configuration" as detailed here:http://www.allroundautomations.com/threads/ubbthreads.php?ubb=showflat&Number=30309#Post30309

I can connect using sqlplus with:

sqlplus user/password@//tahiti:1521/tahicr01

tnsnames.ora looks okay, windows hosts file is okay,
pl/sql developer has the oracle_home set correctly.

But when I try to connect PL/SQL Developer I get:
ORA-12154: TNS: Could not resolve the connect identifier

Any help appreciated,
Thanks, Darrell.

 

[freemink]

Okay, I sorted it out.

Started from scratch:

Running Windows XP in Virtualbox using NAT mode. Mac OS X host is running Checkpoint VPN secure-client.

In (virtual) Windows XP:

Installed Oracle Instant Client
Installed PL/SQL Developer (v7.1.5)

Checked windows hosts file.

Set environment variables ORACLE_HOME and TNS_ADMIN to directory where installed instant client to. I'm pretty sure that ORACLE_HOME wasn't used at all, but I did it anyway.

Create a basic sqlnet.ora in ORACLE_HOME

sqlnet.authentication_services = (ALL)
names.directory_lookup = (TNSNAMES,ONAMES)
names.default_domain = world
name.default_zone = world

Create tnsnames.ora in ORACLE_HOME

TAHICR01.world =
  (DESCRIPTION =
    (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = tahiti)
          (PORT = 1521)
    )
    (CONNECT_DATA = (SID = TAHICR01))
  )

Started pl/sql developer which complained about a missing msvcr71.dll - I found the dll and copied to ORACLE_HOME

Restarted pl/sql developer and manually set 'Oracle Home' and 'OCI Library' from Tools->Preferences.

Restarted pl/sql developer and it worked!