The error you are getting indicates that the alias you are using to connect
does not appear in your tnsnames.ora
ie you are using sqlplus username/password_at_nonexistentname
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Paulo" <preichert_at_libero.it> wrote in message
news:89489138.0207300153.42d352a7_at_posting.google.com...
> Please guys,
>
> I'm almost a newbie on Oracle and I'm having the following problem:
>
> I've installed a server Windows 2K with Oracle 8.1.7 and it's
> configured and appears to be working properly.
>
> On my desktop (Windows 2K Professional) I've installed the client
> tools (default installation of Oracle Client 8.1.7).
>
> In Net8 Assistant, I've used the wizard to create the service name to
> connect to a database on the server. When I try to test the connection
> from inside Net8 Assistant to the database it works fine.
>
> When I try to connect to the database from SQL*Plus or ODBC it gives
> me an error that says that the service name could not be resolved:
>
> [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name
>
> Did someone foud a problem like mine?
>
> Thanks.
Received on Tue Jul 30 2002 - 07:30:56 CDT
