ORA-15040, ORA-15066, ORA-15042 when ASM disk is not present in all nodes of a Rac Cluster. Adding a disk to the Diskgroup fails. (Doc ID 399500.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.2 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2014***

Symptoms

Environments running RAC and ASM, before a disk became part of the diskgroup, it has to be validated in all nodes of the cluster.  Failing to this validation, produce different results, particularly for environments using  version 10.2.0.2 and below.

10.2.0.2 and below


The diskgroup is mounted in the ASM instance where the operation  was executed, but is not mounted in other ASM instances of the cluster where the disk was missing.

Trying to mount the diskgroup could report possible errors like:

ORA-15001: diskgroup "1" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15066: offlining disk "" may result in a data loss
ORA-15042: ASM disk "3" is missing

or

SQL> alter diskgroup test1 mount;
alter diskgroup test1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing

When adding disks to the diskgroup:

SQL> alter diskgroup test1 add disk '/dev/asmdisk_KH5' force;
alter diskgroup test1 add disk '/dev/asmdisk_KH5' force
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide

 

10.2.0.3 and above


Starting with 10.2.0.3, if the disk can not be validated in all nodes of the cluster, it won't be added to the diskgroup.  During the process, the header of the disk is formatted with valid information looking  like a valid  ASM disk.

Trying to delete the disk will failed with error ORA-15032 and ORA-15054

SQL> alter diskgroup test drop disk '/dev/raw/raw8';
alter diskgroup test drop disk '/dev/raw/raw8'
*
ERROR at line 1:
ORA-15032 : not all alterations performed
ORA-15054 : disk "/DEV/RAW/RAW8" does not exist in diskgroup "TEST" 


Trying to add the disk again will fail with errors ORA-15032 and ORA-15020

SQL> alter diskgroup test add disk '/dev/raw/raw8';
alter diskgroup TEST add disk '/dev/raw/raw8'
*
ERROR at line 1:
ORA-15032 : not all alterations performed
ORA-15020 : discovered duplicate ASM disk "TEST_0005"







Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms