您好,欢迎访问一九零五行业门户网

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

情况是这样的,我有一台服务器安装的是oracle11gr201,并且分别使用grid和oracle用户安装了grid infrastructure和database软件,
情况是这样的,我有一台服务器安装的是oracle11gr201,并且分别使用grid和oracle用户安装了grid infrastructure和database软件,结果在使用dbca工具创建数据库时,在进度条为96%的地方报错了,dbca的trace.log日志内容:
[thread-161] [ 2012-03-04 15:29:08.101 cst ] [postdbcreationstep.executeimpl:820]  starting database ha resource
[thread-161] [ 2012-03-04 15:29:08.101 cst ] [crsnative.internalstartresource:339]  about to start resource: name: ora.srcbdc.db, node: null, options: 0, filter null
[thread-161] [ 2012-03-04 15:29:08.157 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db false crs-2672: attempting to start 'ora.srcbdc.db' on 'instsvr1'
[thread-161] [ 2012-03-04 15:29:18.377 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db true ora-01031: insufficient privileges
[thread-161] [ 2012-03-04 15:29:18.378 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db true ora-01031: insufficient privileges
[thread-161] [ 2012-03-04 15:29:18.379 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db true crs-2674: start of 'ora.srcbdc.db' on 'instsvr1' failed
[thread-161] [ 2012-03-04 15:29:18.380 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db false crs-2679: attempting to clean 'ora.srcbdc.db' on 'instsvr1'
[thread-161] [ 2012-03-04 15:29:18.385 cst ] [crsnativeresult.addline:106]  callback: ora.srcbdc.db false crs-2681: clean of 'ora.srcbdc.db' on 'instsvr1' succeeded
[thread-161] [ 2012-03-04 15:29:18.386 cst ] [crsnativeresult.addcomp:162]  add comp: name ora.srcbdc.db, rc 215, msg crs-0215: could not start resource 'ora.srcbdc.db'.
[thread-161] [ 2012-03-04 15:29:18.386 cst ] [crsnative.internalstartresource:352]  failed to start resource: name: ora.srcbdc.db, node: null, filter: null, msg ora-01031: insufficient privileges
ora-01031: insufficient privileges
crs-2674: start of 'ora.srcbdc.db' on 'instsvr1' failed
[thread-161] [ 2012-03-04 15:29:18.387 cst ] [postdbcreationstep.executeimpl:828]  exception while starting with ha database resource prcr-1079 : failed to start resource ora.srcbdc.db
ora-01031: insufficient privileges
ora-01031: insufficient privileges
crs-2674: start of 'ora.srcbdc.db' on 'instsvr1' failed
[thread-161] [ 2012-03-04 15:31:05.276 cst ] [postdbcreationstep.executeimpl:861]  connecting for siha/rac...
通过日志的内容可以比较容易判断,这是权限的问题的!并且数据库能手工启动!但是使用srvcrl命令也无法启动:
[grid@instsvr1 ~]$ srvctl start database -d srcbdc
prcr-1079 : failed to start resource ora.srcbdc.db
ora-01031: insufficient privileges
ora-01031: insufficient privileges
crs-2674: start of 'ora.srcbdc.db' on 'instsvr1' failed
查了一下发现,原来由于我的grid infrastructure和database是使用分别的用户管理的,而在创建数据库的过程中,由于使用的asm,所以在建库的左后grid要把数据库起来,但是由于grid用户不在oracle用户的dba组,所以无法启动数据库,即错误中提到的无法启动资源:ora.srcbdc.db
解决方法:把grid用户添加到dba组即可。

其它类似信息

推荐信息