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