exadata alert_xx.log:

ERROR: failed to establish dependency between database edw and diskgroup resource ora.DATA_DM01.dg
ERROR: failed to establish dependency between database edw and diskgroup resource ora.RECO_DM01.dg

Fri Aug 03 16:44:05 2012
NOTE: dependency between database edw1 and diskgroup resource ora.RECO_DM01.dg is established


-- MOS:
ERROR: failed to establish dependency between database <database name> and diskgroup resource ora.<diskgroup name>.dg [ID 1474954.1]

In this Document

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Goal

Alert logfile of the database shows the error as follows:-

ERROR: failed to establish dependency between database <database name> and diskgroup resource ora.<diskgroup name>.dg

Example:

ERROR: failed to establish dependency between database ERPREP and diskgroup resource ora.DATA.dg

Fix

This error is harmless.
Documented in Bug 8304720
Abstract: ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP
This is an internal BUG.

The db-dg dependency will be created later on if the diskgroup is used by the db again; the dependency can also be created manually through cmdline tool.

Automatically it will resolve itself later on when the db tries to use the diskgroup. Or we can manually establish the dependancy through any command line utility.

For establishing dependencies between database and diskgroups, please use DB home owner running srvctl from DB home with

$ srvctl modify database -d <db_name> -a "<diskgroup_list>"

For example:
$ srvctl modify database -d db112 -a "DATA,FRA"

References

@ BUG:8304720 - SIHA: ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP

srvctl status database -d xxx
srvctl modify database -d xxx -a "DATA_DM01,RECO_DM01"

-----
select name, state from v$asm_diskgroup;

NAME       STATE
---------- --------
DATA_DM01  MOUNTED
DBFS_DG    MOUNTED
RECO_DM01  MOUNTED