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: Securing Oracle server from internal access

Re: Securing Oracle server from internal access

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Mon, 05 Feb 2007 21:03:38 +0000
Message-ID: <newscache$26d0dj$zai$1@newsfront4.netvisao.pt>


check the sqlnet manual.
It's possible to restrict the IP_ADDRESSes allowed to connect or restrict the access to a certain IP.

pedro

Frank van Bortel wrote:
> Ana C. Dent schreef:
>

>> Yes, shutdown the listener & only use IPC protocol.

>
> IPC requires a listener running. Bequeath does not.
>
> IPC entry for tnsnames.ora:
>
> DEMO =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = demo))
> )
> (CONNECT_DATA =
> (SID = demo)
> )
> )
>
> Beqeuath entry for tnsnames.ora (Windows):
> DB920.XX.YZ =
> (DESCRIPTION=
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM=oracle)
> (ARGV0=oracledb920)
> (ARGS='(DESCRIPTION=(LOCAL=yes)(ADDRESS=(PROTOCOL=BEQ)))')
> )
> (CONNECT_DATA=(service_name=db920.xx.yz)
> )
> )
>
> Listener.ora that goes with the demo entry:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = demo))
> )
> )
Received on Mon Feb 05 2007 - 15:03:38 CST

Original text of this message

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