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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to restrict remote DB connection??

Re: How to restrict remote DB connection??

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 22 Aug 2004 20:14:53 +0200
Message-ID: <4128e26e$0$26988$626a14ce@news.free.fr>

"qazmlp" <qazmlp1209_at_rediffmail.com> a écrit dans le message de news:db9bbf31.0408220914.7f18fa7a_at_posting.google.com... > "Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<412898ae$0$26996$626a14ce_at_news.free.fr>...
> > "qazmlp" <qazmlp1209_at_rediffmail.com> a écrit dans le message de
> > news:db9bbf31.0408220422.28f5892a_at_posting.google.com...
> > > I have to configure in such a way that, there is no DB connection
> > > possible from any remote machine to my machine. What are the things
> > > that I should take care to do so?
> > >
> > > In my understanding, we have to ensure that, there are no entries in
> > > .rhosts and also no entry for the TCP.INVITED_NODES in sqlnet.ora.
> > > What else do we have to ensure?
> >
> > Don't start a listener then only local connections are possible.

> That's a nice idea! Thanks!
>
> Ok, what about allowing DB connections only to some specific remote machines?
> How do we achieve that? Do .rhosts and TCP.INVITED_NODES have impact here?

None and some are very different issue.
TCP.INVITED_NODES is a good idea.
Don't forget to set TCP.VALIDNODE_CHECKING to yes

-- 
Regards
Michel Cadot
Received on Sun Aug 22 2004 - 13:14:53 CDT

Original text of this message

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