How to enable sqlnet tracing for debugging sqlplus traffic in RSA Identity Governance and Lifecycle
Originally Published: 2016-09-14
Last Modified: 2023-10-06
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
Minimum Assurance Level Number of Views After an upgrade to RSA Authentication Manager 8.3.patch 1, unable to access Operations Console via IP address Number of Views Add a RADIUS Client Agent Number of Views Cloud Access Service and Authenticators Historical Release Notes (September 2025 - February 2025) Number of Views User ID does not have the correct service account role error when trying to authenticate using an RSA Authentication Manag… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to test RSA Identity Router (IDR) Secure Connector connectivity to the RSA ID Plus Cloud Access Service RSA SecurID Software Token for Microsoft Windows shows blank screen when asked to select a device where the token will be … RSA Governance & Lifecycle Generic Database Collector Guide RSA Authentication Manager 8.7 SP2 Administrator's Guide
Don't see what you're looking for?
