Re: protocol.ora & listener.ora

I try all upper case of file name(PROTOCOL.ORA) and it doesn't work too. i think "protocol.ora" is the correct filename but Oracle listener can't find this file when listener startup.

Judy

"Daniel Morgan" <damorgan_at_exesolutions.com> ????? news:3CBDE1B0.707B318D_at_exesolutions.com...
> Have you considered that UNIX is case sensitive?
>
> Or that perhaps your machine is not looking at that particular network\admin
> directory?
>
> first check the upper/lower/mixed case of the file name. Then try making an error in
> the tnsnames.ora and see if that affects your ability to connect.
>
> Daniel Morgan
>
>
>
> Judy wrote:
>
> > 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 - 23:36:56 CDT