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

Other related posts: