Diskgroup is not compatible for database usage. Database compatible attribute of diskgroup should be same or lower than the database compatible initialization parameter value.

##########################
## Error
##########################

##########################
#  Error Occurred
##########################

Error occured when i tried to create a database using DBCA at Step 6 in 11.2.0.3.0 version

**************************************** Step By Step Analysis ******************************************************

#########################################
# 1) Check the compatible Values
#########################################

SQL> select NAME,STATE,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;
NAME                           STATE       COMPATIBILITY                                                DATABASE_COMPATIBILITY
------------------------------ ----------- ------------------------------------------------------------ ------------------------------------------------------------
DATA                           MOUNTED     11.2.0.2.0                                                   11.2.0.2.0
RECO                           MOUNTED     11.2.0.2.0                                                   11.2.0.2.0
VOTEDISK                       MOUNTED     11.2.0.2.0                                                   11.2.0.2.0

=====================================================================================================================

#########################################
# 2) Reason for Failure
#########################################

Database compatible attribute of diskgroup should be same or lower than the database compatible initialization parameter value.

From above we can see that Database_compatibility attribute is set to 11.2.0.2.0

When we create a new database using DBCA, by default the database init compatible parameter is set to 11.2.0.0.0, So we are receiving the above error.

This also seems to be Bug 11075044
=====================================================================================================================

##########################
## Solution
##########################

Modify the database creation templates, such that when we invoke DBCA the compatiable parameter must be 11.2.0.2.0

Template Location : $ORACLE_HOME/assistants/dbca/templates

[oracle@host01 templates]$ pwd
/u01/app/oracle/product/11.2.0.3/dbhome_1/assistants/dbca/templates

Here I've tried creating db using General Purpose Option. So i'm taking a backup of General_Purpose.dbc template before making changes.

[oracle@host01 templates]$ cp General_Purpose.dbc General_Purpose.dbc.bkp

Changed the Below parameter as follows,

initParam name="compatible" value="11.2.0.2.0"

Difference between two files,

[oracle@host01 templates]$ diff General_Purpose.dbc General_Purpose.dbc.bkp
32c32
<          initParam name="compatible" value="11.2.0.2.0"
---
>          initParam name="compatible" value="11.2.0.0.0"
[oracle@host01 templates]$

=====================================================================================================================
 Now Invoke DBCA again, this step i didnt face any issues and the DB Creation is Successful.
=====================================================================================================================

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================