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

(Doc ID 2380215.1)

Last updated on MARCH 29, 2018

Applies to:

User Productivity Kit - Version 12.1.0.1 to 12.1.0.4 [Release 12.1]
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. Recicle 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms