try using a qualified servicename in your tnsnames.ora instead of that sid
"simon gu" <guxinhong_at_yahoo.com> wrote in message
news:ae637542.0109271305.41a7cb88_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:23:03 CDT
