My Oracle Support Banner

Information to gather when diagnosing ASM space issues (Doc ID 351117.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform. ASM 10g and 11g


This is a guide to provide  all the information needed to troubleshoot Automatic Storage Management (ASM) space issues, which include:

  1. ASM level errors
    • ORA-15041
    • ORA-15047
  2. RDBMS level errors when storage is on ASM
  3. Inconsistencies between what is perceived as the available space
  4. Inconsistencies between V$ASM_DISKGROUP and X$ views

The next section has a reference to the code of the scripts used to collect the information.  Those scripts can be downloaded from the following links: 

          asmdebug.sql -- To be executed on the ASM instance

rdbmsdebug.sql -- To be executed on the RDBMS instance

The next section lists the information to gather.  Be sure to gather the information from the correct instance.  Also, keep in mind that if normal redundancy is used you need to multiply the file size as shown from the database times two, and for high redundancy times three.

Troubleshooting Steps

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
Troubleshooting Steps

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