建数据库oracle 01031,DBCA创建ASM数据库时遇到ORA-01031

问题:是dbca创建ASM数据库时,图形界面缓冲条停留在86%

监控建库日志([root@rhel5 bin]# tail -f /u01/app/oracle/cfgtoollogs/dbca/orcl/trace.log)中显示如下错误:

[Thread-73] [ 2016-05-26 10:04:35.701 CST ] [PostDBCreationStep.executeImpl:820]  Starting Database HA Resource

[Thread-73] [ 2016-05-26 10:04:35.701 CST ] [CRSNative.internalStartResource:339]  About to start resource: Name: ora.orcl.db, node: null, options: 0, filter null

[Thread-73] [ 2016-05-26 10:04:35.970 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db false CRS-2672: 尝试启动 'ora.orcl.db' (在 'rhel5' 上)

[Thread-73] [ 2016-05-26 10:04:46.977 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db true ORA-01031: insufficient privileges

[Thread-73] [ 2016-05-26 10:04:47.019 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db true ORA-01031: insufficient privileges

[Thread-73] [ 2016-05-26 10:04:47.047 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db true CRS-2674: 未能启动 'ora.orcl.db' (在 'rhel5' 上)

[Thread-73] [ 2016-05-26 10:04:47.047 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db false CRS-2679: 尝试清除 'ora.orcl.db' (在 'rhel5' 上)

[Thread-73] [ 2016-05-26 10:04:47.061 CST ] [CRSNativeResult.addLine:106]  callback: ora.orcl.db false CRS-2681: 成功清除 'ora.orcl.db' (在 'rhel5' 上)

[Thread-73] [ 2016-05-26 10:04:47.063 CST ] [CRSNativeResult.addComp:162]  add comp: name ora.orcl.db, rc 215, msg CRS-0215: Could not start resource 'ora.orcl.db'.

[Thread-73] [ 2016-05-26 10:04:47.063 CST ] [CRSNative.internalStartResource:352]  Failed to start resource: Name: ora.orcl.db, node: null, filter: null, msg ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

CRS-2674: 未能启动 'ora.orcl.db' (在 'rhel5' 上)

[Thread-73] [ 2016-05-26 10:04:47.064 CST ] [PostDBCreationStep.executeImpl:828]  Exception while Starting with HA Database Resource PRCR-1079 : 无法启动资源 ora.orcl.db

ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

CRS-2674: 未能启动 'ora.orcl.db' (在 'rhel5' 上)

原因:

由于我的Grid Infrastructure和Database是使用分别的用户管理的,而在创建数据库的过程中,由于使用的asm,所以在建库的左后grid要把数据库起来,但是由于grid用户不在oracle用户的dba组,所以无法启动数据库,即错误中提到的无法启动资源:ora.srcbdc.db

解决:将grid用户添加到dba组

[root@rhel5 ~]# vim /etc/group

dba:x:500:oracle,grid

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2107224/,如需转载,请注明出处,否则将追究法律责任。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值