failed to establish dependency between database GERP and diskgroup resource

tolywang發表於2013-09-11
Oracle 11.2.0.3.7  版本,  15個節點RAC .  其中三個節點是給另外一個資料庫使用 。 其他12個節點是我使用,因為EBS R12 從AIX 遷移到 Linux系統需要指令碼建立資料庫,  按照文件建立後, 開啟例項的時候報錯 , 查詢alert log 發現報錯如下:
....
 Post SMON to start 1st pass IR
 Submitted all GCS remote-cache requests
 Post SMON to start 1st pass IR
Reconfiguration complete
ORACLE_BASE from environment = /u01/app/oracle
Wed Sep 11 12:30:38 2013
ALTER DATABASE   MOUNT
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
ERROR: failed to establish dependency between database GERP and diskgroup resource ora.DATA.dg
ORA-1079 signalled during: ALTER DATABASE   MOUNT...
Wed Sep 11 12:30:47 2013
SUCCESS: diskgroup DATA was dismounted


查了Metalink ,  可能是bug  (ID 1474954.1),  查詢其他論壇或部落格上的文章 ,重新啟動另外一個共享ASM diskgroup的資料庫例項即可 (參考http://yangtingkun.itpub.net/post/468/523429)。  

------------ 
Metalink的描述:

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

ERROR: failed to establish dependency between database and diskgroup resource ora..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 -a ""

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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-772556/,如需轉載,請註明出處,否則將追究法律責任。

相關文章