服务器上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 [控制信息]