ASM Diskgroup not compatible for database usage

Ran into an interesting issue today; while trying to setup a database for a demo with OEM12c and ODA, I got a compatibility warning dealing with ASM. Really more of an info message but it would not allow you pass the step until fixed.

Image

So now, how do you resolve this issue?

Solution:

  1. Navigate to $OH/assistants/dbca/templates
  2. Edit the template you are trying to use and change the “compatible” line:

<InitParamAttributes>
<InitParams>
<initParam name=”db_name” value=””/>
<initParam name=”dispatchers” value=”(PROTOCOL=TCP) (SERVICE={SID}XDB)”/>
<initParam name=”audit_file_dest” value=”{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump”/>
 <initParam name=”compatible” value=”11.2.0.0.0″/>
<initParam name=”remote_login_passwordfile” value=”EXCLUSIVE”/>

3. Then rerun dbca and create the database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: