My Oracle Support Banner

EM 13c: False Pluggable Database (PDB) Down Alerts Due To ORA-04031 (Doc ID 3071409.1)

Last updated on FEBRUARY 13, 2025

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager Could Control (OEM) is reporting false pluggable database (PDB) down alerts due to ORA-04031: unable to allocate bytes of shared memory error. The pluggable database (PDB) is actually up and running on the server.

Target type=Pluggable Database
Categories=Availability
Message=The pluggable database <PDB Name> is down
Severity=Fatal
Event reported time=31/12/2024 05:54:22 PM AWST
Operating System=Linux
Platform=x86_64
Event Type=Target Availability
Event name=Status
Availability status=Down

 

$ <Agent_Base>/agent_inst/sysman/log/gcagent_errors.log

2024-12-31 17:53:17,675 [264971:9628B48C:GC.Executor.26 (rac_database:<Cluster DB Name>:pdbResponse_cdb)] ERROR - ORA-04031: unable to allocate bytes of shared memory ("","","","")
java.sql.SQLException: ORA-04031: unable to allocate bytes of shared memory ("","","","")
   at oracle.sysman.emSDK.agent.sql.SqlConnection.filter(SqlConnection.java:2192)
   at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2159)
   at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2090)

2024-12-31 18:01:12,224 [264978:B3EA38EF:GC.Executor.31 (oracle_database:<Cluster DB Name>:db_inst_cpu_usage)] ERROR - ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate bytes of shared memory ("","","","")
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate bytes of shared memory ("","","","")
   at oracle.sysman.emSDK.agent.sql.SqlConnection.filter(SqlConnection.java:2192)
   at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2159)

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.