Scheduler shutdown with ORA-04031 error message
search cancel

Scheduler shutdown with ORA-04031 error message


Article ID: 7746


Updated On:


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


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


CA WAAE R11.3.x Onwards


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.



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