Re: [Q] sqlplus through VPN not work, but tnsping work

could this be something as simple as the service name not matching the alias in tnsnames.ora as the tnsping doesn't actually verify that the service_name
(or sid) is correct, only the login will verify.

I just tested the following
MIKE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = mikea)
    )
  )

bash-2.02$ tnsping mike

TNS Ping Utility for Solaris: Version 8.1.7.3.0 - Production on 16-DEC-2004 11:23:44

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx)(PORT=1521)) OK (10 msec)

bash-2.02$ sqlplus mike/mike_at_mike

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 16 11:23:53 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

--
http://www.freelists.org/webpage/oracle-l