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.<\/p>\n
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.<\/p>\n
You can see the compatibility values of disk groups as follows.<\/p>\n
[oracle@orcldb06 ~]$ . oraenv\nORACLE_SID = [+ASM6] ? +ASM6\nThe Oracle base remains unchanged with value \/u01\/app\/oracle\n[oracle@orcldb06 ~]$ sqlplus \/ as sysasm\n\nSQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 4 16:03:10 2017\n\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\nWith the Real Application Clusters and Automatic Storage Management options\n\nSQL> col COMPATIBILITY form a10\nSQL> col DATABASE_COMPATIBILITY form a10\nSQL> col NAME form a10\nSQL> select group_number, name, compatibility, database_compatibility from v$asm_diskgroup;\n\nGROUP_NUMBER NAME\tCOMPATIBIL DATABASE_C\n------------ ---------- ---------- ----------\n\t 1 DATA_ORCL\t11.2.0.2.0 11.2.0.2.0\n\t 2 DBFS_DG\t11.2.0.2.0 11.2.0.2.0\n\t 3 RECO_ORCL\t11.2.0.2.0 11.2.0.2.0<\/pre>\nTo solve the error, it is necessary to change the compatible parameter in the corresponding template.<\/p>\n
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.<\/p>\n
You must change the following line in the General_Purpose.dbc file.<\/p>\n
....\n<initParam name=\"compatible\" value=\"11.2.0.2.0\"\/>\n....<\/pre>\nThen restart the dbca. It will work successfully.<\/p>\n\n
<\/div>\n