Cannot Allocate Space Error With Asm Ora-15041 (Doc ID 389877.1)

Last updated on FEBRUARY 05, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.

Symptoms

When trying to add a new datafile or resize an existent datafile, the procedure fails:

SQL> alter database datafile '+DG1/chrsprd/datafile/test.272.594387433' resize
4000M;

alter database datafile '+DG1/chrsprd/datafile/test.272.594387433' resize 4000M
*
ERROR at line 1:
ORA-01237: cannot extend datafile 15
ORA-01110: data file 15:
'+DG1/chrsprd/datafile/test.272.594387433'
ORA-17505: ksfdrsz:1 Failed to resize file to size 512000 blocks
ORA-15041: diskgroup space exhausted

Reviewing the free space on the diskgroup, it reports available space:

GROUP_NUMBER NAME TOTAL_MB FREE_MB STATE
------------ ------------------------------ ---------- ---------- -----------
1                                 DG1     43155         8055             MOUNTED


.

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