ITPub博客

首页 > Linux操作系统 > Linux操作系统 > failed to establish dependency between database GERP and diskgroup resource

failed to establish dependency between database GERP and diskgroup resource

原创 Linux操作系统 作者:tolywang 时间:2013-09-11 13:22:37 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13456957