ora817 client access problems. Net8 test ok, but TNSPing does not work.

From: simon gu <guxinhong_at_yahoo.com>
Date: 2 Oct 2001 07:21:54 -0700
Message-ID: <ae637542.0110020621.680f5b8b@posting.google.com>

I tried to trace the activity on the client side. however, no *.trc found in the specified directory. by the way my db server is win2000 server. How to make tracing work on ora817 client?

now this time, please focus on the instance o1. another oberservation is: If I use sql*net 8.05 client to connect to oracle817eent server, everything (tnsping, sqlpus, etc ) works ok using just SID instead of global_nameon the client side. So questions are still in the client side. I need to make ora817 client work concerning the version compatibilities down the road. where do I need to pay attention to this stuff?

the two files are copies below. please comment.

thanks.

/********************sqlnet.ora**************************/

# SQLNET.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools.

trace_level_client = 16
trace_directory_client = C:\oracle\ora81\network\trace
trace_unique_client = true

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

/****************************listener.ora*********************************/

# LISTENER.ORA Network Configuration File: c:\oracle\ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = o1.goldfinger.syr.edu)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = o1)

    )
    (SID_DESC =
(GLOBAL_DBNAME = o2)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = o2)

    )
    (SID_DESC =
(GLOBAL_DBNAME = o3)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = o3)

    )
  )

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<9p51t0$gmscl$1_at_ID-62141.news.dfncis.de>...

> "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 Tue Oct 02 2001 - 09:21:54 CDT