oracle 开启tnsping trace、sqlnet trace 、event10257

在sqlnet.ora文件中加入以下参数：
TNSPING.TRACE_LEVEL=SUPPORT
TNSPING.TRACE_DIRECTORY=d:\oracle\trace

“tnsping”工具的预期用途仅仅是测试Oracle Net别名中指定的数据库侦听器是up还是down。

“tnsping”工具不打算用作Oracle Net性能测量工具

B.  Sql*net trace

 

SERVER side tracing

On the DB server,  go to ORACLE_HOME/network/admin and add the following lines to sqlnet.ora file:

TRACE_LEVEL_CLIENT = 16
TRACE_FILE_CLIENT = cli
TRACE_DIRECTORY_CLIENT = <place your trace directory here>
TRACE_UNIQUE_CLIENT = ON
TRACE_TIMESTAMP_CLIENT = ON

For 11G add  the following to override the Automatic Diagnostic Repository:

DIAG_ADR_ENABLED=off

 

可以进一步设置数据库10257事件，跟踪LREG进程（Oracle 12c之前为PMON进程）动态注册的过程。