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

郑全

这样情况，一般是由于安装gi的用户，只授予了 oinstall,asmadmin,asmdba组,但没有授予 dba组导致，

单独再授予 dba组即可

usermod -a -G dba grid

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

郑全

郑全 发表于 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