listener.ora 에 쓰이는 항목중 PLSExtProc 이란? ;링크는 네트워크보안 관련내용, PLSExtProc 설명도 포함

PL/SQL External Procedures (ExtProc).
---------------------------------------------------------------------------------------------------

LISTENER MODES

The Listener can be configured in one of three modes (as configured in listener.ora) –

Database

Provides network access to an Oracle database instance
 

PLSExtProc

Method for PL/SQL packages to access operating system executables
 

Executable

Provides network access to operating system executables

 

The "Database" mode is the most widely used mode and is the standard mode used by every database for connectivity. "PLSExtProc" allows PL/SQL database packages to access external programs and is configured by default for many instances. "Executable" mode allows an external program to be defined and accessed through a TNS connection. There is little documentation on this mode and is almost exclusively used by Oracle products, such as the Oracle E-Business Suite and Oracle Collaboration Suite.

위 내용만 보지마시고, 링크 들어가셔서 보안이슈들도 한번 읽어보세요.
http://www.integrigy.com/security-resources/whitepapers/Integrigy_Oracle_Listener_TNS_Security.pdf  

Integrigy_Oracle_Listener_TNS_Security.pdf

   링크문서다운로드


리스너 파일예제(oracle 9i)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = server15)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/9i)
      (PROGRAM = extproc)
    )
  )