Scheduler shutdown with ORA-04031 error message

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

Scheduler shuts down with "ORA-04031" error message in event_demon.<INS> log.

CAUAJM_E_18402 ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","BEGIN :RetVal := ujo_sendafm...","*********","kglHeapInitialize:temp")

Environment

CA WAAE R11.3.x Onwards

Cause

Receiving an oracle error message ORA-04031 in the autosys logs usually means that the Oracle database does not have enough shared memory available in Oracle for the amount of requests (processes) that are being run.

Resolution

To resolve the issue, one needs to perform following steps for Oracle Database: 

1. Increase SGA (sga_target and sga_max_size)
2. Increase shared_pool.
3. Increase shared_pool_reserved_size.
4. Or set _SHARED_POOL_RESERVED_PCT=10 - this setting will make sure that there is always 10% reserved size available of shared pool.

After increasing Shared pool memory kindly start scheduler and execute "chk_auto_up -r 111" to verify whether jobs are processing successfully.

Additional Information

How to Increase Shared Pool Memory