Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 Received on Fri Jun 30 2006 - 04:05:10 CDT