Re: protocol.ora & listener.ora

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 Wed Apr 17 2002 - 13:06:47 CDT