Re: protocol.ora & listener.ora

From: Judy <lsu_at_nycap.rr.com>
Date: Fri, 19 Apr 2002 06:01:10 GMT
Message-ID: <GoOv8.57782$0o.10841357@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

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ????? news:phdubuo23rcku88r3kc8ln64stud52gec5_at_4ax.com...
> On Thu, 18 Apr 2002 20:39:28 GMT, "Judy" <lsu_at_nycap.rr.com> wrote:
>
> >here is the previous email i post.
> >it seems no protocol.ora is found on server.
> >
> >thanks.
> >Judy
> >
>
> trace_directory_*client* = d:\Oracle\Ora81\network\log
> ntvllt: No PROTOCOL.ORA file is found
>
> so on the *client*
> You are confusing client and server.
>
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
>
>
> >"Judy" <lsu_at_nycap.rr.com> ¼¶¼g©ó¶l¥ó news:XQiv8.149397$GF1.20358133_at_typhoon.nyroc.rr.com...
> >> Hi Sybrand,
> >>
> >> Thanks for the help!
> >>
> >> I add 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
> >>
> >> in sqlnet.trc file, I found:
> >>
> >> nsopen: opening transport...
> >> nttcon: entry
> >> nttcon: toc = 1
> >> nttcnp: entry
> >> ntvlin: entry
> >> 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
> >>
> >> Does it means "can't find protocol.ora on database server" ?
> >> protocol.ora is in $ORACLE_HOME/network/admin on database server..
> >>
> >> thanks a lots
> >> Judy
> >>
> >> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ?????
> >> news:0d2rbu0agj6hcf1hps25g13luukia3re2p_at_4ax.com...
> >> > On Wed, 17 Apr 2002 13:37:57 GMT, "Judy" <lsu_at_nycap.rr.com> wrote:
> >> >
> >> > >Hi Sybrand,
> >> > >
> >> > > Thanks for your reply.
> >> > >I have typing error in my previous email.
> >> > >The Oracle version is 8.1.5 for solaris.
> >> > >
> >> > >here is my protocol.ora:
> >> > >
> >> > >tcp.invited_nodes= (x.x.x.x)
> >> > >tcp.excluded_nodes= (x.x.x.x)
> >> > >tcp.validnode_checking= yes
> >> > >
> >> > >ps. (x.x.x.x) is ip address
> >> > > It doesn't work... so i wonder there has anything wrong wtih my listener.ora.
> >> > >
> >> > >Thanks
> >> > >Judy
> >> >
> >> >
> >> > I still think the listener hasn't anything to do with it.
> >> > Time to set sqlnet tracing to level 16 as a level 16 trace will
> >> > contain pertinent references to protocol.ora
> >> > How to do this
> >> > modify sqlnet.ora
> >> > include and/or change the following lines
> >> > 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>
> >> >
> >> > If you don't have a protocol.ora a client trace will report this fact.
> >> > I assume if you have a valid protocol.ora the contents will be listed
> >> > If the protocol.ora isn't valid this will be reported.
> >> > I don't know what the server trace will report.
> >> > There is a good chance (there have been many issues with net8) this
> >> > doesn't work at all in the -desupported- 8.1.5
> >> >
> >> > --
> >> > Hth
> >> >
> >> > Sybrand Bakker, Senior Oracle DBA
> >> >
> >> > To reply remove -verwijderdit from my e-mail address
> >>
> >>
> >
>
Received on Fri Apr 19 2002 - 01:01:10 CDT