Re: protocol.ora & listener.ora

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

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ????? news:4evpbus6flvi26eeh53kad4qiipi3p4gur_at_4ax.com...
> On Wed, 17 Apr 2002 03:33:50 GMT, "Su Ling-Yu, Judy"
> <judysu_at_nycap.rr.com> wrote:
>
> >Hi ,
> >
> > Please help!
> >
> > I want to setup protocol.ora for host-base access control on ORACLE 5.1.8
> >for Solaris. I create protocol.ora file but it doesn't work.
> >I wonder if i need to re-config listener.ora file for protocol.ora.
> >Does anybody know how to write listener.ora with protocol(tcp) access restrict?
> >(probably EXPROC with an TCP protocol address... etc)
> >
> >Thanks
> >Judy
> >
> >......^_^.....
> >
> >
> It won't work for 5.1.8 of course, as that even doesn't use sqlnet 2
> nor net8
> Use
> tcp.invited_nodes =
> and tcp.excluded_nodes =
> Your last phrase is absolute nonsense. Please look up the protocol.ora
> definition in the net8 administrators manual.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Apr 17 2002 - 08:37:57 CDT