重庆思庄Oracle、Redhat认证学习论坛

标题: 11g在安装gi之后，再安装数据库报：ORA-01031 insufficient privileges [打印本页]

作者: 郑全 时间: 2015-10-20 00:53
标题: 11g在安装gi之后，再安装数据库报：ORA-01031 insufficient privileges
在单机中，安装oracle 11g restart后，再去安装数据库，在执行到最后，报类似下面的错误：

PRCR-1079 : Failed to start resource ora.sztech.db
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
CRS-2674: Start of 'ora.sztech.db' on 'rac-dg' failed

作者: 郑全 时间: 2015-10-20 00:56
这样情况，一般是由于安装gi的用户，只授予了 oinstall,asmadmin,asmdba组,但没有授予 dba组导致，

单独再授予 dba组即可

usermod -a -G dba grid

如果不授予这个dba组，后面使用srvctl 启动数据库也会报错。

作者: 郑全 时间: 2015-10-20 01:00

郑全发表于 2015-10-20 00:56
这样情况，一般是由于安装gi的用户，只授予了 oinstall,asmadmin,asmdba组,但没有授予 dba组导致，

单独 ...

METALINK文章如下：

PRCR-1079 ORA-01031 CRS-2674 SRVCTL Fails to Start Database in Oracle Restart Job Role Separation Environment [ID 985743.1]

		修改时间 23-JAN-2011 类型 PROBLEM 状态 MODERATED

In this Document
[size=-1]  Symptoms
  Cause
  Solution
  References

[size=-1]This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

SymptomsIn Oracle Restart (Standalone 11gR2 Grid Infrastructure) environment with Job Role Separation, srvctl fails to start database with error:

srvctl start db -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
CRS-2674: Start of 'ora.testdb.db' on 'siha1' failed

Cause
Possible causes:

1. Grid Infrastructure owner is not part of OSDBA group for the database thats being start up.
2. Grid Infrastructure owner doesn't have write permission to database dbs ($ORACLE_HOME/dbs) directory.

Solution1. As per documentation <Oracle Database Administrator's Guide 11g Release 2 (11.2) -> Configuring Oracle Restart -> Adding Components to the Oracle Restart Configuration>, Grid Infrastructure owner must be part of OSDBA group if the database need to be managed by srvctl.

To find out OSDBA group for RDBMS home, execute: $RDBMS_HOME/bin/osdbagrp

To find out whether grid user is already part of OSDBA group, execute: groups <grid>

Location for groups command is /usr/bin/groups on Linux, and /bin/groups on AIX, Solaris and hp-ux

2. If Grid Infrastructure owner is already part of OSDBA group and the issue still exist, add group write permission to $RDBMS_HOME/dbsdirectory; for example

</grid
cd $RDBMS_HOME
chmod g+w dbs
ls -ld dbs

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)