My Oracle Support Banner

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

Last updated on FEBRUARY 07, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.