search cancel

Error: CAUAJM_E_18402 ORA-03135: connection lost contact

book

Article ID: 214693

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

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: <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

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.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

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.

https://community.broadcom.com/communities/community-home/librarydocuments/viewdocument?DocumentKey=a61b14b6-9176-4f73-92ea-5c970ae41dd3