On Exadata System, When creating a database, DBCA completes - but fails to set the interconnect parameter correctly due to incorrect permissions on cluster

Asset ID:	1-72-1619268.1
Update Date:	2014-07-02
Keywords:

Solution Type Problem Resolution Sure

Solution 1619268.1 : On Exadata System, When creating a database, DBCA completes - but fails to set the interconnect parameter correctly due to incorrect permissions on cluster_interconnect.dat

Applies to:

Exadata Database Machine V2 - Version All Versions to All Versions [Release All Releases]
Exadata Database Machine X2-8 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

<span class="sBugInternalContent">When running dbca templates post OneCommand - the DBCA completes - but fails </span><span class="sBugInternalContent">to set the interconnect parameter correctly.</span>

The /opt/oracle.SupportTools/onecommand directory is owned by root:root with 775 permissions. Within this directory is a file called cluster_interconnect.dat.

While using the DBCA it is being prompted to update this file, but cannot since is it owned by root and only root has permissions on the directory.

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
error opening file
/opt/oracle.SupportTools/onecommand/cluster_interconnect.dat

Cause

Bug 16036164 - CLUSTER_INTERCONNECT.DAT IS NOT ACCESSIBLE BY DBCA TEMPLATES POST ONECOMMAND

Solution

This is a bug. (Fixed in 12.2

Please use this workaround to prevent this issue from occuring when creating a database.
Workaround:

chmod 755 /opt/oracle.SupportTools/onecommand
chmod 644 /opt/oracle.SupportTools/onecommand/cluster_interconnect.dat

After creating Database. Run alter database manually for setting cluster_interconnects.

Attachments

This solution has no attachment