How to enable sqlnet tracing for debugging sqlplus traffic in RSA Identity Governance and Lifecycle
Originally Published: 2016-09-14
Article Number
Applies To
Issue
Tasks
When using our installer to connect to a remote database this directory would be the directory prefixed with instantclient under /home/oracle.
To enable tracing for a failed installation, do not uninstall after the previous failed attempt so that the instantclient folder structure remains.
create a file named sqlnet.ora within that directory with these contents:
TRACE_LEVEL_CLIENT=USER TRACE_FILENO_CLIENT=6 TRACE_FILELEN_CLIENT=51200 TRACE_UNIQUE_CLIENT=ON TRACE_TIMESTAMP_CLIENT=ON TRACE_DIRECTORY_CLIENT=/home/oracle/instantclient12_1/log LOG_DIRECTORY_CLIENT=/home/oracle/instantclient12_1/log DIAG_ADR_ENABLED=OFF
sqlnet operations look for the existence of this file at every execution. The next attempted installation will log verbose information about the connection string being used and the result or results received.
For a detailed reference on the above parameters and additional parameters that can be set, please refer to this online Oracle reference:
http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm
Related Articles
How to enable DEBUG logging in RSA Identity Governance and Lifecycle Number of Views How to Enable AFX Connector Debug Logging in RSA Identity Governance & Lifecycle Number of Views How to enable or disable Audit Logging in RSA Identity Governance and Lifecycle Number of Views Artifacts to gather in RSA Identity Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle RESTful web service response: java.lang.IllegalStateException Number of Views
Trending Articles
RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide How to Download OTP Token Seed Files from myRSA RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide How to set up the REST RSA SecurID Authentication API for Authentication Manager 8.2 SP1
Don't see what you're looking for?
