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 Delete the SMTP(s) Certificate Number of Views Add a RADIUS Client Agent 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 RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.1 Quick Setup Fails with "Failed to Attach Replica Instance" User Application Portal The RSA Identity Governance & Lifecycle AD Collector and AD ADC authentication source fail to establish a TLS 1.2 SSL conn…
Don't see what you're looking for?
