How to Fix ORA DBT-06003 Error: ASM Diskgroup Does Not Have Sufficient Space in Oracle 19c
ORA Error ASM (Oracle DBA):
[DBT-06003] The selected disk group (+DATA/prim/) does not have sufficient space available.This error occurs when the ASM diskgroup does not have enough free space to create the database files.
In this blog, we will understand:
- Why this error occurs
- How to check ASM free space
- How to clean old ASM files
- How to fix the issue permanently
Step 1: Check ASM Diskgroup Space
Login as Grid user:
sqlplus / as sysasmRun the following query:
SELECT name,type,total_mb,free_mb,usable_file_mb
FROM v$asm_diskgroup;Output:
NAME TYPE TOTAL_MB FREE_MB USABLE_FILE_MB
----- ------ -------- ------- ---------------
CRS EXTERN 5116 2756 2756
DATA EXTERN 5116 1052 1052Observation:
The DATA diskgroup has only:
1052 MB free spacewhich is insufficient for Oracle 19c database creation.
Step 2: Check ASM Disk Usage
Open ASM command utility:
asmcmdCheck disk usage:
duOutput:
Used_MB Mirror_used_MB
6236 6236Check DATA diskgroup usage:
du +DATA/*Output:
Used_MB Mirror_used_MB
3968 3968Step 3: List ASM Directories
Check existing folders inside ASM diskgroups:
ls +DATA
ls +CRSOutput:
+DATA:
ASM/
PRIM/
orapwasm
+CRS:
PRIM/The old PRIM database files were still present inside ASM.
Step 4: Remove Old Database Files
Since the old database was no longer required, remove the leftover ASM directories.
Delete from DATA diskgroup:
rm -r +DATA/PRIMDelete from CRS diskgroup:
rm -r +CRS/PRIMConfirmation:
You may delete multiple files and/or directories.
Are you sure? (y/n) YAfter deletion:
ls +CRSOutput:
(no output)This confirms the old PRIM database files were removed successfully.
Add New ASM Disk
Step 1: Add Virtual Disk in VirtualBox
- Shutdown VM
- Open VirtualBox Settings
- Storage → Add Hard Disk
- Create 10 GB disk
Step 2: Create ASM Disk
After OS boot:
fdisk /dev/sdeCreate partition:
n
p
1
Enter
Enter
wRefresh partitions:
partprobeCreate ASM disk:
oracleasm createdisk DISK5 /dev/sde1Step 3: Add Disk to ASM Diskgroup
Login as SYSASM:
ALTER DISKGROUP DATA
ADD DISK '/dev/oracleasm/disks/DISK5';The error:
DBT-06003: selected disk group does not have sufficient spaceoccurs because ASM diskgroup free space is insufficient for database creation.
The issue can be resolved by:
- Removing old ASM database files
- Cleaning archive logs/backups
- Adding new ASM disks
- Increasing DATA diskgroup size
After freeing or adding space, rerun DBCA and the database creation should complete successfully.
🚀 Become a Job-Ready Oracle DBA with Learnomate Technologies!
Looking to build a strong career in Oracle Database Administration? Join the Best Oracle DBA Training Program at Learnomate Technologies and gain hands-on experience with real-time projects and industry-level scenarios.
🔥 What You’ll Learn:
✔ Oracle 19c Database Installation & Configuration
✔ ASM (Automatic Storage Management)
✔ RMAN Backup & Recovery
✔ Data Guard Setup & Administration
✔ Performance Tuning & Troubleshooting
✔ OEM (Enterprise Manager) Monitoring
- Why Choose Learnomate?
- Practical, real-time training approach
- Experienced industry trainers
- Live project exposure
- Interview preparation & resume building
- 100% placement assistance
Who Can Join?
- Freshers (IT / Non-IT)
- Working Professionals
- Anyone looking to switch to Database Administration
📍 Mode: Online & Offline Available
📞 Contact us today & start your DBA journey!
Don’t just learn Oracle — MASTER it with Learnomate Technologies!
#OracleDBA #OracleTraining #DatabaseAdministrator #Learnomate #Oracle19c #DBATraining #ITCareer #DataBase #JobReady #CareerGrowth
