Re: protocol.ora & listener.ora

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 19 Apr 2002 02:19:24 -0700
Message-ID: <a20d28ee.0204190119.7ff8eafe@posting.google.com>

"Judy" <lsu_at_nycap.rr.com> wrote in message news:<GoOv8.57782$0o.10841357_at_typhoon.nyroc.rr.com>...
> Hi Sybrand ,
>
> Mabye I have some misunderstanding on your last email.
> I don't know what do you mean I am confusing client and server.
>
> that's your suggestion to add
> trace_level_client|server = 16 # the | is a shortcut for or as usual
> trace_level_unique = true # to avoid multiple sessions in one file
> trace_directory_client = <any sensible directory>
>
>
> I add the following setting in sqlnet.ora on my client pc:
> trace_level_client = 16
> trace_level_unique = true
> trace_directory_client = d:\Oracle\Ora81\network\log
>
> and i got those information in sqlnet.trc:
> ntvllt: entry
> ntvllt: No PROTOCOL.ORA file is found
> ntvllt: exit
> ntvlin: exit
> nttcnp: Validnode Table IN use; err 0x0
> nttcnp: creating a socket.
> nttcnp: exit
> ------------------------
> I also tried the following setting in sqlnet.ora on my client pc:
> trace_level_server = 16
> trace_level_unique = true
> trace_directory_server = d:\Oracle\Ora81\network\trace
>
> I didn't find any trace file from sqlnet.
> ------------------------
> I turn on trace in listener.ora on server.
> the trace file from listener include:
>
> ntvllt: No PROTOCOL.ORA file is found
> tnslsnr: connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=ipc)(KEY=mll))
> tnslsnr: connect string inst->lcxd[1]: (ADDRESS=(PROTOCOL=ipc)(KEY=protein))
>
>
> Thanks for the help
> Judy
>
>

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGG

(sorry)

> trace_level_client|server = 16 # the | is a shortcut for or as usual
Ever studied a syntax diagram?
This should be read as
either
trace_level_client on the client
and
trace_level_server on the server.
So what did you expect?
Please check the net8 administrators manual if I'm making things too difficult for you, obviously I should have provided that advice right away, but I tried to avoid those 4 letters and to be nice.

---

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Apr 19 2002 - 04:19:24 CDT