ORA-15437: Not enough quota available in quota group

<<Back to Oracle ASM Main Page 

ORA-15437: Not enough quota available in quota group QG_PDB1.

SQL> create tablespace test datafile '+DG_FLEX_DATA' size 4G;
create tablespace test datafile '+DG_FLEX_DATA' size 4G
*
ERROR at line 1:
ORA-01119: error in creating database file '+DG_FLEX_DATA'
ORA-17502: ksfdcre:4 Failed to create file +DG_FLEX_DATA
ORA-15437: Not enough quota available in quota group QG_PDB1.

Reason:

You are using quota to limit the space usage for the database in the diskgroup and quota limit is exceeding

Solution

Increase the quota value for the database

Investigation

Login to ASM Instance and Find out the Quota for your Database

 SQL> SELECT DG.NAME AS DG_NAME,FI.NAME ASM_FG,QO.NAME AS QUOTA_NAME,FI.CLIENT_NAME as DB_NAME,QO.USED_QUOTA_MB,QO.QUOTA_LIMIT_MB
FROM V$ASM_FILEGROUP FI, V$ASM_QUOTAGROUP QO , V$ASM_DISKGROUP DG
WHERE FI.CLIENT_NAME='PDB1'
AND
FI.QUOTAGROUP_NUMBER=QO.QUOTAGROUP_NUMBER
AND
FI.GROUP_NUMBER=DG.GROUP_NUMBER;DG_NAME                        ASM_FG     QUOTA_NAME DB_NAME    USED_QUOTA_MB QUOTA_LIMIT_MB
------------------------------ ---------- ---------- ---------- ------------- --------------
DG_FLEX_DATA                   FG_PDB1    QG_PDB1    PDB1                2208           5120

As we can see we have quota (QG_PDB1) of 5G on PDB1.

Increase the Quota Value and re run Create Tablespace Command.

SQL> ALTER DISKGROUP DG_FLEX_DATA MODIFY QUOTAGROUP QG_PDB1 SET 'QUOTA' = 10G;

Diskgroup altered.

SQL> SELECT DG.NAME AS DG_NAME,FI.NAME ASM_FG,QO.NAME AS QUOTA_NAME,FI.CLIENT_NAME as DB_NAME,QO.USED_QUOTA_MB,QO.QUOTA_LIMIT_MB
FROM V$ASM_FILEGROUP FI, V$ASM_QUOTAGROUP QO , V$ASM_DISKGROUP DG
WHERE FI.CLIENT_NAME='PDB1'
AND
FI.QUOTAGROUP_NUMBER=QO.QUOTAGROUP_NUMBER
AND
FI.GROUP_NUMBER=DG.GROUP_NUMBER;

DG_NAME         ASM_FG     QUOTA_NAME DB_NAME    USED_QUOTA_MB QUOTA_LIMIT_MB
--------------- ---------- ---------- ---------- ------------- --------------
DG_FLEX_DATA    FG_PDB1    QG_PDB1    PDB1                2208          10240

Since you just increased the quota for PDB1 database you can now create the tablespace.

SQL> create tablespace test datafile '+DG_FLEX_DATA' size 4G;

Tablespace created.