Oracle Net logs and tracking on servers

The default location of listener log files in UNIX systems is $ ORACLE_HOME/Network/log.

In Windows, the default location of the listener log file is % ORACLE_HOME %/Network/log.

The server trace file is usually located in % ORACLE_HOME %/Network/trace. The trace can be set to off, user, admin, or support tables. There are someCodeThe comparison table is as follows:

Package keyword package type

Nsptac accept [accept]

Nsptrf refuse [reject]

Nsptrs resend [resend]

Nspda data [Data]

Nspcnl control [control]

Nsptmk marker [Marker]

Code package type

1 connect [connection]

2 accept [accept]

3 acknowledge [receive notification]

4 refuse [reject]

5 redirect [redirection]

6 data [Data]

7 null [empty Data]

9 abort [exceptional termination]

11 resend [resend]

12 marker [Marker]

13 attention [Note signal]

14 control information [Control Information]