Problem
You need to enable tracing for SQL*Net at the database side
Solution
Tracing for SQL*Net at the database side can be enabled by editing sqlnet.ora file in the RDBMS home:
$ORACLE_HOME/network/admin/sqlnet.ora
Use the parameters:
TRACE_LEVEL_SERVER={off | user | admin | support}
TRACE_DIRECTORY_SERVER=<directory>
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:
Post a Comment