Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tnsping works but not sqlplus
> ----------
> From: Peter J. Schoenster[SMTP:peter_at_schoenster.com]
>
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given
> in connect descriptor
>
In your connect descriptor ( tnsnames.ora on the local machine ) you use an oracle SID ( SID = ... ) that must match the one found in the listener.ora on the remote server ( SID_NAME = ... ) Received on Thu Nov 09 2000 - 06:49:28 CST