If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client and listener for detailed review.
For this :
Add the following to the sqlnet.ora file on the client side.
|
1 2 3 4 5 |
TRACE_LEVEL_CLIENT=16 TRACE_FILE_CLIENT=CLIENT TRACE_DIRECTORY_CLIENT=<where the trace files are written> TRACE_TIMESTAMP_CLIENT=on TRACE_UNIQUE_CLIENT=on |
Add the following to the sqlnet.ora file on the server side.
|
1 2 3 4 |
TRACE_LEVEL_SERVER=16 TRACE_FILE_SERVER=SERVER TRACE_DIRECTORY_SERVER=<where the trace files are written> TRACE_TIMESTAMP_SERVER=on |
When you restart listener, you will be able to see in detail what is happening in the listener trace.
