WA dSeires (DE) shutdown with errors ORA-04031: unable to allocate 40 bytes of shared memory

Products

• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

The dSeries tracelog shows the following errors related to shutdown.

202XXXXX 00:00:12.345 [relationaldatabase] [ERROR] DM.Appl.MY_APPLICATION.2: [202X-XX-XX_00:00:12.345] SQLCode: 604 SQLState: 60000 Message: ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 272 bytes of shared memory ("shared pool","select name,password,datats#...","ABCD^984","KQR ENQ")

 

Or these errors:

Calling into 911
com.ca.wa.core.engine.rdbms.DatabaseException: java.sql.SQLException: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
........
Caused by: Error : 4036, Position : 0, Sql = INSERT INTO ESP_RTWOB (GENERATION,ID,NAME,APPLID,TYPE,ONHOLD,ONQUIESCE,COMPLETE,COMPPEND,FORCED,THESTATE,CONDITIONS,STATUS,READYTIME,STARTTIME,ENDTIME,USERID,READYQUEUED,JOBNO,JOB_LOG_ID,CMPC,HOST,BULK_DATA)

Environment

Release : 12.2

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

Cause

The ORA-04031 is related to Oracle database.

ORA-04031: unable to allocate 40 bytes of shared memory 

 

Resolution

The error is likely due to heavy fragmentation on the database. Consult the DBA or Oracle on how to fix this.