Re: Securing Oracle server from internal access

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 05 Feb 2007 20:42:13 +0100
Message-ID: <eq819l$444$1@news5.zwoll1.ov.home.nl>

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))     )
  )

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Feb 05 2007 - 13:42:13 CST