My Oracle Support Banner

Error In ASM Creating A Database (Doc ID 2439763.1)

Last updated on JANUARY 29, 2020

Applies to:

Oracle Exadata Storage Server Software - Version 18.1.6.0.0 and later
Information in this document applies to any platform.

Symptoms

>> error in ASM creating a database
...............................................................................................................................................
When we try to create a database in RAC version 12.1.0.2 on an Exadata X7-2 server, with grid infrastructure 12.2.0.1, we get the following error:

NOTE: ASMB mounting group 1 (DATADEV)
NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
WARNING: group 1 (DATADEV) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 1 is being dismounted.
WARNING: ASMB force dismounting group 1 (DATADEV) due to missing disks
SUCCESS: diskgroup DATADEV was dismounted
Wed Jul 04 12:13:12 2018
Errors in file /u01/app/rac12cr2/diag/rdbms/test11/test1/trace/test1_ora_173089.trc:
ORA-00200: control file could not be created
ORA-00202: control file: '+DATADEV'
ORA-17502: ksfdcre:4 Failed to create file +DATADEV
ORA-15001: diskgroup "DATADEV" does not exist or is not mounted
ORA-15040: diskgroup is incomplete


The compatible parameters are:

'compatible.asm'='12.2.0.1.0',
'compatible.rdbms'='11.2.0.4'

And finishes without creating the database.

We have followed the note Doc ID 21626377.8 and we get the following errors:

SQL> ALTER DISKGROUP DATADEV SET ATTRIBUTE 'compatible.asm' = '12.1.0.2';
ALTER DISKGROUP DATADEV SET ATTRIBUTE 'compatible.asm' = '12.1.0.2'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.asm
ORA-15244: new compatibility setting less than current [12.2.0.1.0]


...............................................................................................................................................

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.