Monday, May 8, 2023

Oracle Database 19c -- How to enable SQL*Net Tracing for a Database


You need to enable tracing for SQL*Net at the database side 


Tracing for SQL*Net at the database side can be enabled by editing sqlnet.ora file in the RDBMS home:


Use the parameters:

TRACE_LEVEL_SERVER={off | user | admin | support}

It is advisable to use the support level of tracing, as it will include the client host and port details and packet contents, which may have error messages and codes helping the investigation

No comments: