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

book

Article ID: 208387

calendar_today

Updated On:

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

 

 

Cause

The ORA-04031 is related to Oracle database.

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

 

Environment

Release : 12.2

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

Resolution

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