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.
So now, how do you resolve this issue?
Solution:
- Navigate to $OH/assistants/dbca/templates
- 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
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.