UPK: Getting ORA-03135: Connection lost contact at OracleInternal.ConnectionPool.PoolManager'3 When Adding sqlnet.ora Parameters (Doc ID 2380215.1)

Last updated on JULY 14, 2024

Applies to:

User Productivity Kit - Version 12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to add sqlnet.ora parameters

SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256)
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(MD5)

the following error appears in the Windows Event Log.

ERROR
-----------------------
Windows User: IISAPPPOOL\ODDevAppPool4r2
Oracle.ManagedDataAccess.Client.OracleException: ORA-03135: Connection lost contact at OracleInternal.ConnectionPool.PoolManager'3

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Added sqlnet.ora parameters

SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256)
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(MD5)

2. Recycle listeners

3. Stop IIS in Windows 2008 R2

4. Decrypt web.config for KData, KUser and ODSContent sites

5. Confirm that the DB configurations are not modified

6. Encrypt web.config for the same three

7. Start IIS

8. Start UPK client and point to http://<servername>/ODSContent

9. UPK Client sees the site, then prompts for user/password

10. Cannot login