Re: Multi-homed interface and Oracle listener

"Paul Sure" <phv_temp_at_yahoo.com> wrote in message news:<v2ou9uko3bta7a_at_corp.supernews.com>...
> > tcp 0 0 *.1521 *.* LISTEN
>
> Well this looks obvious.
>
> In fact I didn't see much services that have restrictions on which ip
> address they listen to or to which addresses they answer. Apache has the
> possibility to service only on certain ip adresses (interfaces). Don't know
> if you can tell the Oracle listener only to listen for connections on
> specific ip addresses.
> Guess you hve to use tcp wrappers for that.
>
> Paul

in 8.1.x one could use a protocol.ora file in the %ORACLE_HOME%\Network\Admin
to define hosts that are either explicitly allowed or explicitly denied.

http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/params.htm#478104

tcp.validnode_checking=yes
tcp.excluded_nodes= (foo.com, 192.168.0.0)
tcp.invited_nodes= (mydomain.com, 172.16.1.0)

One could also use the Oracle Connection Manager utility to set an access policy via ip address.

hth,

Paul Received on Tue Jan 21 2003 - 00:08:29 CST