Gold
Partner
BLOG POSTS
Business Process
Outsourcing
Oracle Training

ORA-01501 CREATE DATABASE failed incompatible with diskgroup

Published: December 31, 2023

Redo Buffers               13058048 bytes

SQL> @/home/oracle/clone/create_orcl1.sql

CREATE DATABASE orcl

*

ERROR at line 1:

ORA-01501: CREATE DATABASE failed

ORA-00200: control file could not be created

ORA-00202: control file: '+DATADG/ORCL/CONTROLFILES/control01.ctl'

ORA-17502: ksfdcre:4 Failed to create file

+DATADG/ORCL/CONTROLFILES/control01.ctl

ORA-15001: diskgroup "DATADG" does not exist or is not mounted

ORA-15204: database version 12.1.0.0.0 is incompatible with diskgroup DATADG

 

 

 

 

 

 

SQL> select * from v$asm_disks;

select * from v$asm_disks

              *

ERROR at line 1:

ORA-01219: database or pluggable database not open: queries allowed on fixed

tables or views only

 

 

SQL> select group_number, name,

compatibility, database_compatibility from v$asm_diskgroup;  2

 

GROUP_NUMBER NAME

------------ ------------------------------

COMPATIBILITY

------------------------------------------------------------

DATABASE_COMPATIBILITY

------------------------------------------------------------

           1 DATADG

12.1.0.2.0

12.1.0.2.0

 

           2 FLASHDG

12.1.0.2.0

12.1.0.2.0

 

GROUP_NUMBER NAME

------------ ------------------------------

COMPATIBILITY

------------------------------------------------------------

DATABASE_COMPATIBILITY

------------------------------------------------------------

 

           3 REDODG

12.1.0.2.0

12.1.0.2.0

 

SQL> show parameter compat

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      12.0.0

noncdb_compatible                    boolean     FALSE

plsql_v2_compatibility               boolean     FALSE

SQL> alter system set compatable = '12.1.0.2.0';

 

 

SQL> alter system set compatable = '12.1.0.2.0' scope=spfile;

alter system set compatable = '12.1.0.2.0' scope=spfile

                 *

ERROR at line 1:

ORA-02065: illegal option for ALTER SYSTEM

 

 

SQL> alter system set compatible = '12.1.0.2.0' scope=spfile;

 

System altered.

 

SQL> shutdown immediate;

ORA-01507: database not mounted

 

 

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area 3204448256 bytes

Fixed Size                  3715928 bytes

Variable Size            1627393192 bytes

Database Buffers         1560281088 bytes

Redo Buffers               13058048 bytes

SQL> @/home/oracle/clone/create_orcl1.sql

 

Database created.

 

Categories
Category 1
Category 2
Category 3
Category 4
ORA Errors
CONTACT
Boulevard Street 19,
New Jersey, USA
81000 Montenegro
+382 20 389 268
+382 69 655 333
08-16 h
Monday - Friday