Re: PROTOCOL.ORA

From: Naren Chintala <naren_at_mink.att.com>
Date: 1997/03/19
Message-ID: <332FF651.68A2@mink.att.com>#1/1

Guido vd Zweerde wrote:
>
> Hi,
>
> I've one question. A fews weeks ago we got a new HP9000-server and
> installed Oracle 7.2.3 on it. We use the database for client/server
> applications through SQL*NET 2 and I was wondering if it's possible to
> restrict access to clients in our own domain. I've read a while ago
> something of using protocol.ora, but I can't find any documentation in
> the Oracle books. Can you tell me or give hints on how to use
> protocol.ora.
>
> Thanx,
> Guido vd Zweerde
> Database administrator
> University of Twente
> G.R.vandeZweerde_at_civ.utwente.nl
> +31-53-4892423

Contents of the $ORACLE_HOME/network/admin/protocol.ora (example)

---

tcp.validnode_checking = yes
tcp.invited_nodes=(127.0.0.1,135.21.84.154,135.21.84.152)

Make sure you start the SQL*Net listener for this to take effect or use the "lsnrctl reload" command (I have not used this).

Hope this helps. BTW, the PROTOCOL.ORA file is documented in one of the SQL*NET manuals.

-- 
Naren
naren_at_mink.att.com

Received on Wed Mar 19 1997 - 00:00:00 CST