伺服器上ORACLE NET日誌和跟蹤

unix系統listener記錄檔位置預設在$ORACLE_HOME/network/log

windows系統listener記錄檔位置預設在%ORACLE_HOME%/network/log

伺服器追蹤檔案通常位於%ORACLE_HOME%/NETWORK/TRACE.跟蹤可以被設定成OFF、USER、ADMIN或SUPPORT幾個級表。跟蹤中有一些代碼對比表，具體如下

包關鍵字 包類型

NSPTAC ACCEPT[接受]

NSPTRF                                   REFUSE[拒絕]

NSPTRS                                   RESEND[重發]

NSPDA                                      Data [資料]

NSPCNL                                   Control [控制]

NSPTMK                                    marker [標記符]

代碼 包類型

1                                               Connect [串連]

2                                               Accept [接受]

3                                               Acknowledge [收到通知]

4                                               Refuse [拒絕]

5                                               Redirect [重新導向]

6                                               Data [資料]

7                                               Null [即空資料]

9                                               Abort [異常終止]

11                                             Resend [重發]

12                                             Marker [標記符]

13                                            Attention [注意訊號]

14                                            Control information [控制資訊]