oracle client access Re: Net Assistant test ok, but command line login does not WORK

hmmm, I tried both global_name, and ora8 compatible sid. Both still do not work. Should I pay any attention to the sqlnet.ora. I presume a client net8 app parses TNSnames.ora for oracle server connection info, any other files or configturation tool that I need to pay attention.

help, help...

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:<tr76d4btglu35f_at_corp.supernews.com>...
> 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 Sat Sep 29 2001 - 11:21:13 CDT