Re: limiting access to oracle by ip adress

From: John <jhook_at_regenstrief.org>
Date: Tue, 11 Sep 2001 12:23:16 -0500
Message-ID: <9nlg4v$f56$1@hercules.iupui.edu>

Hi,

Add the following to the protocol.ora file in the network.admin directory

tcp.validnode_checking = yes
tcp.invited_nodes = (

             111.111.111.111,
            999.999.999.999

)

Hope this helps

John

"Andreas Moroder" <amoroder_at_sb-brixen[nospam].it> wrote in message news:9nks7c$ee2$1_at_serv1.iunet.it...
> Hello,
>
> we have a ancient oracle application ( Forms 3 on a old machine and the DB
> on oracle 8 ) that runs only with one user because the application
manages
> the access rights.
> Now we want to limit the access via sqlplus to certain worksstations.
> On most unix systems you cann tell inetd to give access only to certain IP
> adresses.
>
> Is this possible with the oracle listener ?
>
> Thank you very much
> Andreas Moroder
>
> P.S. If possible answer via e-mail too.
>
>
Received on Tue Sep 11 2001 - 12:23:16 CDT