ITPub博客

首页 > 数据库 > Oracle > DBCA创建ASM数据库时遇到ORA-01031

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

原创 Oracle 作者:fengsongtao123 时间:2016-05-26 10:53:20 0 删除 编辑
问题:是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博客 ” ,链接:https://blog.itpub.net/30373263/viewspace-2107224/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-07-25

  • 博文量
    96
  • 访问量
    259428