Re: 8i private connection

Hi Nick,

you could create a file <protocol.ora> in the directory where your listner.ora is with the following :

tcp.validnode_checking=yes
tcp.invited_nodes=(address1,address2)
# tcp.excluded_nodes=(address1, address2, ...)

don't forget localhost;

after that do a listner reload

as i havent used this much , check the docs. Should work with net8

hth.

s.kapitza

nlefel_at_web.de (nlefel) wrote in message news:<2b16ef15.0210102108.faa9ada_at_posting.google.com>...
> We have a DB server and application server that
> communicate via 192.x.x.x private network. This works
> well. Users connect to the application via another network.
> I as DBA now want to get direct to the DB from my workstation which is
> outside this private net.
> Of course the DB server has 2 network cards. I can reach it using
> telnet or ping or whatever. I can even telnet to it and start sqlplus.
>
> How can I configure the listener.ora (or whatever) to
> allow me to communicate - but nobody else.
>
> Yes: I want to tell the listener to listen on the local, private
> address
> <<and>> my workstation address.
>
> Must I stop the listener or can I tell it to restart with
> a new config file ?
>
> Thanks in advance
> Nick
Received on Fri Oct 11 2002 - 09:30:02 CDT