search cancel

Error: CAUAJM_E_18402 ORA-03135: connection lost contact


Article ID: 214693


Updated On:


CA Workload Automation AE - Scheduler (AutoSys)


AutoSys became non-responsive and did not fail over to shadow.

[05/08/2021 08:37:12]      CAUAJM_E_18416 Event Server: <AUTXPP.PROD.SXORAP0004>  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


Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)


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.


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.

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.