search cancel

schedulers and AS freezes

book

Article ID: 243771

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

We are experiencing issues with several machines in our farm (schedulers+AS) where after start of the system Autosys is running fine for about an hour but then we are getting errors as if it timeout trying to connect to the DB . . . 

After some time, Autosys freezes and only run agent verification (no jobs are managed in any way) but both machines are writing to their respective logs. Autosys services are running and the only way to stop the AS and scheduler service is with a kill command.

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The issue stamped from the quality of our DBaaS and the underline server performances.

We have updates the sqlnet.ora file on the DB side :

In /app/oracle/admin/DASZOD2B/network/admin/sqlnet.ora

SQLNET.EXPIRE_TIME=10

and this seems to give the slow DB time to run the queries.