Re: tnsping fails, yet sqlplus connects

EdStevens wrote:
C:\>tnsping epspd

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
29-JUN-2
006 09:10:21

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

As the output shows, tnsping doesn't find or use any parameter file, so your entry in TNSNAMES isn't used.
In Oracle 10 you can connect to a db without a tnsnames.ora (don't remember the name of the new connection method) with an URL-like name (//10.xxx.xxx.xxx/EPSPD in your case). sqlplus seems to
try to add localhost to a name, whenever the name couldn't be resolved, tnsping doesn't!

Lars
.

Relevant Pages

  • Re: tnsping fails, yet sqlplus connects
    ... Copyright 1997, 2005, Oracle. ... Used parameter files: ... As the output shows, tnsping doesn't find or use any parameter file, so ... you supply the entire connection string at the command line. ...
    (comp.databases.oracle.server)
  • Re: tnsping fails, yet sqlplus connects
    ... TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on ... "Used parameter files:" means the sqlnet.ora file. ... Copyright 1997 Oracle Corporation. ...
    (comp.databases.oracle.server)
  • Re: Cant TNSPing XE database
    ... I'm having difficulty getting TNSPING to see my local XE database. ... I'm running oracle XE on Vista business. ... After installing XE, I installed the Oracle tools for .NET from here ...
    (comp.databases.oracle.server)
  • Re: tnsping fails, yet sqlplus connects
    ... Copyright 1997, 2005, Oracle. ... My expectation is that if TNSPING fails, so should an actual connection ... Are you running the tnsping and sqlplus from the same machine (server ...
    (comp.databases.oracle.server)
  • Cant TNSPing XE database
    ... I'm having difficulty getting TNSPING to see my local XE database. ... I'm running oracle XE on Vista business. ... I installed the Oracle tools for .NET from here ...
    (comp.databases.oracle.server)