Interactive Reporting - SQLNet Error Messages

There are several problems that may warrant an SQLnet error message.

Note: Interactive Reporting, including both the IR Workspace (web) and the Studio Desktop client, will be decommissioned on March 1st, 2019. Neither the web nor the desktop software will be available or supported after this date.

UW-Madison affiliates can find more information on alternative tools on the Office of Data Management and Analytics Services website.

  • Oracle may not be installed on the PC or there was a problem with the installation.
  • The user may be trying to connect to the EPM data base and the SQLnet.ora file was not edited for this data base.
  • The query tool may be 32-bit and 64-bit Oracle has been installed.
If you have any questions please call the DoIT Help Desk at (608) 264-4357 and select option 2.

This file need be edited only for the EPM data base.  Open the file and delete anything text in it that add:

SQLNET.ENCRYPTION_CLIENT = REQUESTED
SQLNET.CRYPTO_SEED = XXXXXXXX

XXXXXXX = users last name

If this is not changed the user will get an SQLNet error message.




Keywords:error message sqlnet.ora sqlnet   Doc ID:32880
Owner:Tim L.Group:Interactive Reporting Madison
Created:2013-08-19 14:39 CSTUpdated:2018-12-06 15:10 CST
Sites:DoIT Help Desk, Interactive Reporting Madison
Feedback:  0   0