Ensure 'SQLNET.ALLOWED_LOGON_VERSION_SERVER' Is Set To 12a

高级别 1自动化oracle-db

说明

This setting SQLNET.ALLOWED_LOGON_VERSION_SERVER configures the minimum authentication protocols clients can use to connect to database instances. Please note that the term VERSION in the parameter name refers to the version of the authentication protocol, not the version of the Oracle Database release. The last uncommented setting in sqlnet.ora must equal 12A (case-insensitive, spaces ignored). Default: 12 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/sqlnet.ora"; [ -f "$f" ] || { echo "noncompliant: $f not found"; exit 0; }; v=$(grep -Ei '^[[:space:]]*SQLNET\.ALLOWED_LOGON_VERSION_SERVER[[:space:]]*=' "$f" | tail -n 1 | sed 's/^[^=]*=//' | tr -d ' \t\r' | tr '[:lower:]' '[:upper:]'); [ "$v" = "12A" ] && echo compliant || echo "noncompliant: ${v:-not set}"

预期输出: compliant

修复方式

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

To remediate this recommendation, set SQLNET.ALLOWED_LOGON_VERSION_SERVER to 12a.

属性

操作系统: 任意
标签: oracle-dbdatabaseoraclenetworkencryption
参考: CIS Oracle Database 23ai Benchmark v1.1.0 - 2.2.5 Ensure 'SQLNET.ALLOWED_LOGON_VERSION_SERVER' Is Set To 12a

检查本机

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

shell

tmaegis scan --target oracle-db