Error: CAUAJM_E_18402 ORA-03135: connection lost contact
Article ID: 214693
Updated On:
Products
Issue/Introduction
AutoSys became non-responsive and did not fail over to shadow.
Error:
[05/08/2021 08:37:12] CAUAJM_E_18416 Event Server: <ORCL19> Failed Query: <BEGIN :RetVal := ujo_event_state (:I_eoid, :I_que_status, :I_evt_num); END;>
[05/08/2021 08:37:12] CAUAJM_E_18402 ORA-03135: connection lost contact
[05/08/2021 08:37:12] Process ID: 15399
[05/08/2021 08:37:12] Session ID: 14 Serial number: 64179
[05/08/2021 08:37:12] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[05/08/2021 08:37:12] CAUAJM_W_10900 The database monitoring system has detected a potential problem with the database.
[05/08/2021 08:37:12] CAUAJM_E_18401 Function <doBind> invoked from <ibind> failed <818>
[05/08/2021 08:37:12] CAUAJM_I_10901 The database monitoring system is beginning validation of database connections.
[05/08/2021 08:37:12] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE
Environment
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
Cause
What you are experiencing is outside of Autosys and something external is killing these connections.
This could be a firewall that is killing INACTIVE sqlnet connections after a set amount of time.
Resolution
Investigating the Oracle error ORA-03135 error message determined your issue to be network related with respect to firewall terminating the connection. Please have a look at the following Burleson Consulting URL which explains the error in more detail and provides suggestions for resolving this at database level.
http://www.dba-oracle.com/t_ora_03135_connection_lost_contact.htm
Please also have a look at this Communities discussion, which also suggest something is terminating the connection. Again, most likely firewall. This community post also provide suggestion for remediating the issue.
Feedback
