While creating a tablespace on Oracle Database 11g I ran into a issue related to DB_CREATE_FILE_DEST (OMF parameter). The DB_CREATE_FILE_DEST parameter was pointing to incorrect ASM Disk Group name which doesn’t existing. The issues was fixed by correcting the DB_CREATE_FILE_DEST parameter to point to the correct ASM Disk Group name.
In this article I would like to demonstrate how to fix create tablespace error which is to incorrect DB_CREATE_FILE_DEST parameter.
Create Tablespace ran the into the issue as below:
The create tablespace failed as the ASM Disk Group +DATA doesn’t existing.
About DB_CREATE_FILE_DEST
DB_CREATE_FILE_DEST specifies the default location for Oracle-managed datafiles.
DB_CREATE_FILE_DEST : directory or disk group
Default value : NO Default value.
Modifiable : ALTER SESSION, ALTER SYSTEM
Identify the ASM Disk Group
Here the Data Disk Group name is +DATA_DM01
Now you can Create a Tablespace again as follows:
This time the tablespace was created successfully without errors as the default OMF datafile location is pointing to correct ASM Disk Group
In this article I would like to demonstrate how to fix create tablespace error which is to incorrect DB_CREATE_FILE_DEST parameter.
Create Tablespace ran the into the issue as below:
The create tablespace failed as the ASM Disk Group +DATA doesn’t existing.
ORA Errors:
ORA-01119: error in creating database file ‘+DATA’
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup “DATA” does not exist or is not mounted
Reason for above error:
The above error is due to initialization parameter DB_CREATE_FILE_DEST pointing to incorrect value. Change/Modify the parameter to fix the issue.
The above error is due to initialization parameter DB_CREATE_FILE_DEST pointing to incorrect value. Change/Modify the parameter to fix the issue.
Check parameter db_create_file_dest Value:
About DB_CREATE_FILE_DEST
DB_CREATE_FILE_DEST specifies the default location for Oracle-managed datafiles.
DB_CREATE_FILE_DEST : directory or disk group
Default value : NO Default value.
Modifiable : ALTER SESSION, ALTER SYSTEM
Identify the ASM Disk Group
Here the Data Disk Group name is +DATA_DM01
Modify the parameter DB_CREATE_FILE_DEST parameter to point it to correct ASM Disk Group name. You can use ALTER SYSTEM SET command to make it permanent as well.
Now you can Create a Tablespace again as follows:
This time the tablespace was created successfully without errors as the default OMF datafile location is pointing to correct ASM Disk Group
Conclusion:
In this article we have demonstrated how to fix ORA errors “ORA-15001”, “ORA-17502″,”ORA-01119” which due to incorrect defualt ASM Diskgroup set at Database using parameter DB_CREATE_FILE_DEST.
