Creating 11gR1 Or 10g Database on ASM 11gR2 Fails With ORA-15001
Last updated on MARCH 21, 2018
Applies to:Oracle Server - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
Affects Environments with
Grid Infrastructure 11gR2
RDBMS 11gR1 or 10gR2
You have installed Clusterware 11gR2 and ASM 11gR2 and want to create a database in 10gR2 or 11gR1.
The create database command throws the following errors:
CREATE DATABASE "P700"
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DG_P700_DATA/p700/control01.ctl'
ORA-17502: ksfdcre:4 Failed to create file +DG_P700_DATA/p700/control01.ctl
ORA-15001: diskgroup "DG_P700_DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
The mentioned diskgroup in the error message is mounted and available:
GROUP# NAME STATE TOTAL_MB FREE_MB
------ -------------- ------- ---------- ----------
1 DG_ACFS MOUNTED 2047 926
2 DG_OCRVOTE MOUNTED 2047 1651
3 DG_P700_DATA MOUNTED 4094 2294
4 DG_P700_BACKUP MOUNTED 4094 3546
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