Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
While creating a database with DBCA, when “General_Purpose” template is selected, this error is received because the “compatible” parameter in the template is lower than the database_compatibility value of the existing disk groups.
The database_compatibility value of the ASM disk group to be used by the database must be less than or equal to the compatible value of the database.
You can see the compatibility values of disk groups as follows.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [oracle@orcldb06 ~]$ . oraenv ORACLE_SID = [+ASM6] ? +ASM6 The Oracle base remains unchanged with value /u01/app/oracle [oracle@orcldb06 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 4 16:03:10 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> col COMPATIBILITY form a10 SQL> col DATABASE_COMPATIBILITY form a10 SQL> col NAME form a10 SQL> select group_number, name, compatibility, database_compatibility from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBIL DATABASE_C ------------ ---------- ---------- ---------- 1 DATA_ORCL 11.2.0.2.0 11.2.0.2.0 2 DBFS_DG 11.2.0.2.0 11.2.0.2.0 3 RECO_ORCL 11.2.0.2.0 11.2.0.2.0 |
To solve the error, it is necessary to change the compatible parameter in the corresponding template.
Templates that DBCA can use are in the “$ORACLE_HOME/assistants/dbca/emplates” directory. Modify the compatible value in the General_Purpose.dbc file in this directory to be greater than or equal to the database_compatibility of your disk groups.
You must change the following line in the General_Purpose.dbc file.
1 2 3 | .... <initParam name="compatible" value="11.2.0.2.0"/> .... |
Then restart the dbca. It will work successfully.
