Ensure 'extproc' Is Not Present In 'listener.ora'

高级别 1自动化oracle-db

说明

extproc should be removed from the listener.ora to mitigate the risk that OS libraries can be invoked by the Oracle instance. Passes when listener.ora contains no extproc entry (or no listener.ora exists in that directory). 19c v2.0.0 titles this "Ensure 'extproc' Is Not Enabled". Reads the file from $TNS_ADMIN, or $ORACLE_HOME/network/admin when TNS_ADMIN is unset (Linux/UNIX hosts); fails when neither directory exists.

检查方式

审计方法: Shell 命令

shell

d="${TNS_ADMIN:-${ORACLE_HOME:?ORACLE_HOME not set}/network/admin}"; [ -d "$d" ] || { echo "missing $d"; exit 1; }; f="$d/listener.ora"; [ -f "$f" ] || { echo compliant; exit 0; }; n=$(grep -ic extproc "$f"); [ "$n" = 0 ] && echo compliant || echo "noncompliant: extproc found in $f"

预期输出: compliant

修复方式

修复方法: 操作指南或基础设施补丁

To remediate this recommendation, remove extproc from the listener.ora file. Instead of relying on the EXTPROC feature in Oracle to access external libraries, you can use a database directory to directly access the library files stored within the database server's file system, allowing you to execute code from those libraries within your PL/SQL code without going through a separate external process.

属性

操作系统: 任意
标签: oracle-dbdatabaseoraclenetworklistener
参考: CIS Oracle Database 23ai Benchmark v1.1.0 - 2.1.1 Ensure 'extproc' Is Not Present In 'listener.ora'

检查本机

请在您有权审计的机器上运行此命令。扫描为只读操作。

shell

tmaegis scan --target oracle-db