设为首页 加入收藏

TOP

DBCA创建ASM数据库时遇到ORA-01031
2014-11-24 18:40:59 】 浏览:9513
Tags:DBCA 创建 ASM 数据库时 遇到 ORA-01031

[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组即可。


】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇使用Logminer还原操作记录 下一篇Oracle 11gR201创建数据库时遭遇O..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目