Oracle中常用跟踪诊断trace配置

SQLNET跟踪tnsping过程 sqlnet.ora中配置

#Trace_level_client=16
#Trace_directory_client=D:\Program files\app\oracle\product\11.2.0.1\dbhome_1\NETWORK\ADMIN
#Trace_unique_client=on
#Trace_timestamp_client=on
#Diag_adr_enabled=off
tnsping.trace_directory=D:\Program files\app\oracle\product\11.2.0.1\dbhome_1\NETWORK\ADMIN
tnsping.trace_level=support

linux 跟踪sqlplus进程

strace -o /tmp/output.txt -T -tt -e trace=all  sqlplus / as sysdba 

strace -t -p 4545

Unix 跟踪sqlplus进程

truss -dfaie -o /tmp/sched_trace.out.02271 sqlplus '/as sysdba'

监听诊断

启动监听日志 lsnrctl set log_status on

LSNRCTL> set log_status on
LSNRCTL> save_config

rman诊断

参考：https://www.xmmup.com/rmanbeifenshijilugengduodelog-huozhetracexinxi.html#wbp-cbm-mao

数据泵

trace=480300

参考：https://www.xmmup.com/shiyongyinhantracecanshuzhenduanoracle-data-pumpexpdpguzhang.html

SQL_TRACE 诊断事件

参考：https://www.xmmup.com/oraclezhongdesql_traceshishenmezhenduanshijianshishenmechangyongde10046ji10053zhenduanshijiandequbie.html

runInstaller诊断调试

-- 调试
./runInstaller -debug -logLevel finest
strace ./runInstaller