Oracle 参数 SEC_PROTOCOL_ERROR_TRACE_ACTION 官方解释，作用，如何配置最优化建议

本站中文解释

SEC_PROTOCOL_ERROR_TRACE_ACTION参数指定当安全协议出现失败后应采取的行动。该参数是一个VARCHAR2类型参数，可以设置为CONTINUE、CONTINUE_REQUEST_AND_LISTENER_ONLY或TERMINATE。

其中，CONTINUE参数的值让安全协议过程仍然可以继续，并且可以找出安全协议出现的问题；CONTINUE_REQUEST_AND_LISTENER_ONLY表示使安全协议失败后仅继续请求客户机的会话，而不继续向服务器发送查询；TERMINATE参数的值表示使安全协议失败后将查询取消，重新尝试重新连接或终止连接。

正确设置SEC_PROTOCOL_ERROR_TRACE_ACTION参数可以有效地确保Oracle数据库安全。在设置时，应根据实际情况选择合适的参数值，并确保安全协议失败时能够做出正确反应。

官方英文解释

SEC_PROTOCOL_ERROR_TRACE_ACTION specifies the kind of logging the database server does when bad packets are received from a possibly malicious client, apart from the client receiving the error.

Values

• NONE

  The database server does not record it in any of the trace files.

• TRACE

  A short entry is made in the alert log file and a detailed incident file is generated. The server trace file also will have an entry about the protocol error and incident file.

• LOG

  The server trace file will have an entry about the protocol violation.

• ALERT

  A short entry is made in the alert log file and in the server trace file about the protocol violation.