Re: Net Assistant test ok, but command line login does not work. connectivity problems

ORA_12154: is a high level error.
Check the listener configuration.

HTH,
Vladimir

"simon gu" <guxinhong_at_yahoo.com> wrote in message news:ae637542.0109271251.370319b7_at_posting.google.com...
> Net Assistant test ok, but command line login does not work.
> connectivity problems
>
> hi, gurus,
>
> I could install ora817 client on win2000 pro. Using Net8 assistant, I
> could setupa servicing name, and test it just ok.
>
> however, it does not work on command line: sqlplus scott/tiger_at_o3. The
> Error is ORA_12154: TNS could not resolve service name.
>
> and also sqlplus will not connect to the servrer, using scott/tiger,
> host_string: o3. the same error message.
>
> The related 2 .ora files are print in part for refereces.
>
> please offer your suggestions and any hints. thanks in advance.
>
>
>
>
> tnsnames.ora --------------
> O3 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = o3)
> )
> )
>
>
> sqlnet.ora-----------------------------------
> SQLNET.ORA Network Configuration File:
> C:\oracle\ora81\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Received on Thu Sep 27 2001 - 16:36:41 CDT