Re: Multi-homed interface and Oracle listener

Paul Drake wrote:

> "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

FYI: In Oracle 9i the protoco.ora has been eliminated and these entries are valid in sqlnet.ora.

Daniel Morgan Received on Sun Jan 19 2003 - 09:08:29 CST