Re: tnsping works, but cannot connect using sqlplus

According to your tnsnames.ora your servicename is ODEV. You are connecting using the dev servicename.
So, it is not surprising this results in 12154. Probably just a typo?
Hopefully you don't post all your typos.

Hth,

Sybrand Bakker, Oracle DBA

"Peter Bismuti" <bismuti_at_cs.fsu.edu> wrote in message news:8o3jg1$2bj$1_at_news.fsu.edu...
> tnsping works:
>
>
> [oracle_at_roughneck oracle]$ netping dev
> bash: netping: command not found
> [oracle_at_roughneck oracle]$ tnsping dev
>
> TNS Ping Utility for Linux: Version 8.1.5.0.0 - Production on 24-AUG-00
 09:34:23
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521))
> OK (90 msec)
>
> here is the blurb from tnsnames:
>
>
> ODEV.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = appserver01)(PORT = 1521))
> (CONNECT_DATA = (SID = dev))
> )
>
> when I try using sqlplus:
>
> [oracle_at_roughneck oracle]$ sqlplus name/password_at_dev
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Thu Aug 24 09:38:48 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
>
> This command works from a different machine with the identical
 tnsnames.ora file.
>
>
> Any ideas what the problem is?
>
>
>
>
>
Received on Thu Aug 24 2000 - 13:47:24 CDT