Re: protocol.ora & listener.ora

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 Thu Apr 18 2002 - 16:11:40 CDT