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

From: simon gu <guxinhong_at_yahoo.com>
Date: 27 Sep 2001 13:51:20 -0700
Message-ID: <ae637542.0109271251.370319b7@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 - 15:51:20 CDT