My Oracle Support Banner

ODA using DBSYSTEM should change ASM SGA to 2G to prevent ASM run out of memory (Doc ID 2903001.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

ODA DBSYSTEM status change to unknown 

The database inside related DBSYSTEM is hanging during the issue time.

 

We can find ora-4031 in ASM alert log:

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

Changes

There are multiple dbsystem created on the env. 

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
Changes
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.