Oracle中常用的跟踪诊断trace配置方法
SQLNET跟踪tnsping过程 sqlnet.ora中配置
1 2 3 4 5 6 7 | #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进程
1 2 3 | strace -o /tmp/output.txt -T -tt -e trace=all sqlplus / as sysdba strace -t -p 4545 |
Unix 跟踪sqlplus进程
1 | truss -dfaie -o /tmp/sched_trace.out.02271 sqlplus '/as sysdba' |
监听诊断
启动监听日志 lsnrctl set log_status on
1 2 | LSNRCTL> set log_status on LSNRCTL> save_config |
rman诊断
参考:https://www.xmmup.com/rmanbeifenshijilugengduodelog-huozhetracexinxi.html#wbp-cbm-mao
数据泵
1 | trace=480300 |
参考:https://www.xmmup.com/shiyongyinhantracecanshuzhenduanoracle-data-pumpexpdpguzhang.html
SQL_TRACE 诊断事件
runInstaller诊断调试
1 2 3 4 | -- 调试 ./runInstaller -debug -logLevel finest strace ./runInstaller |