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 Artifacts to gather in RSA Identity Governance & Lifecycle Number of Views AFX Server stuck in 'Not running' State, with error 'timed out waiting for AFX applications to start' Number of Views How to enable or disable Audit Logging in RSA Identity Governance and Lifecycle Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA-2026-07: RSA Identity Router Security Update for Third-Party Component Vulnerabilities Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
