问题:是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
监控建库日志([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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30373263/viewspace-2107224/