Scheduler shutdown with ORA-04031 error message

book

Article ID: 7746

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

 

Scheduler shutds 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")

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.

Environment

CA WAAE R11.3.x Onwards

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.

Post increasing Shared pool memory kindly start scheduler and execute "chk_auto_up -r 111" to verify whether jobs are running to success.

Additional Information

 

How to Increase Shared Pool Memory