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

"simon gu" <guxinhong_at_yahoo.com> wrote in message news:ae637542.0109290821.58160ca0_at_posting.google.com...
> 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)
Pleaseb enable tracing.
Add to your sqlnet.ora

trace_level_client = 16
trace_directory_client = <any sensible directory>
trace_unique_client = true

Post : the resulting cli*.trc
Your *listener.ora*
Note: an unbalanced parenthesis on any location in tnsnames.ora will result in 12154.

And yes: I don't agree with Ban Spam there are various methods to connect. I do agree with him the 3 files have to match.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Sep 29 2001 - 12:43:48 CDT