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

From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 16 Dec 2004 11:27:49 -0500

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
--
//www.freelists.org/webpage/oracle-l

References:
- [Q] sqlplus through VPN not work, but tnsping work
  - From: dba1 mcc

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

Other related posts: