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

APPLIES TO:

Oracle Database - 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.

***Checked for relevance on 12-Feb-2014***

GOAL

Database aler tlog 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

SOLUTION

This error is harmless.

It is documented in the internal Bug 8304720 "ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP"

"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, run srvctl from RDBMS home:

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

For example:

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

REFERENCES

The above document has copied from Oracle Support (https://support.oracle.com), Doc ID 1474954.1