My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***
ASM 10g and 11g


Purpose

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