Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: hosts.allow in net8/sqlnet

Re: hosts.allow in net8/sqlnet

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 06 Oct 2000 16:31:44 GMT
Message-ID: <39ddfe36.1454571@news.earthlink.net>

that's .protocol.ora (notice the extra dot in the front) in 8i, and it had to be placed in $ORACLE_HOME/network/admin

On Fri, 06 Oct 2000 16:23:46 GMT, andreyNSPAM_at_bookexchange.net (NetComrade ) wrote:

>yeah.. I found out later on.
>It's surprising how all oracle documentation sucks.
>I couldn't find anything in any books about this under 'security'
>chapters, but I knew it could be done. Luckily i remembered that it
>had something to do with protocol.ora, but no book states where the
>hell the file should be. I tried placing it in
>$ORACLE_HOME/network/admin
>and
>/var/opt/oracle
>but nothing worked. It turned out that protocol.ora had to be named
>protocol.ora in 8i.
>Not only that, but all 400 ips had to be one one line, which vi
>couldn't handle. (perl rulz).
>
>On Fri, 06 Oct 2000 00:02:13 +0200, Sybrand Bakker
><postbus_at_sybrandb.demon.nl> wrote:
>
>>On Thu, 05 Oct 2000 21:15:53 GMT, andreyNSPAM_at_bookexchange.net
>>(NetComrade ) wrote:
>>
>>>How do you implement restricting certain IPs to connect to the
>>>database?
>>>
>>>Thanx.
>>
>>You need to configure the file protocol.ora
>>This file should have
>>tcp.invited_nodes=(....)
>>tcp.excluded_nodes=(...)
>>
>>Hth
>>
>>
>>Sybrand Bakker, Oracle DBA
>
Received on Fri Oct 06 2000 - 11:31:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US