Creating 11gR1 Or 10g Database on ASM 11gR2 Fails With ORA-15001 (Doc ID 949073.1)

Last updated on MARCH 02, 2015

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
Affects Environments with
Grid Infrastructure 11gR2
ASM 11gR2
RDBMS 11gR1 or 10gR2


Symptoms

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

 

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