Troubleshooting
Problem
The customer has a load balancer that was configured to time out idle connections. API calls that experienced a ORA-03114: not connected to ORACLE error, would fail
Resolving The Problem
SQLNET.EXPIRE_TIME was set to less than 60 in the sqlnet.ora for the Oracle instance. This produced ""dead connection detection"" traffic that allowed the connections to remain open and not time out.
[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1428
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21471485