NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Privileges issue while starting database with SRVCTL

No comments
Running srvctl command giving insufficient privileges issue.
 
./srvctl start database -d DEV
 

PRCR-1079 : Failed to start resource ora.dev.db
ORA-01031: insufficient privileges
CRS-5017: The resource action "ora.dev.db start" encountered the following error:
ORA-01031: insufficient privileges 
 
Solution:
 
There may be two issues due to which the database would not get started with srvctl
 
1. Grid Infrastructure owner is not part of OSDBA group for the database thats being start up.
The owner of the GRID_HOME should have osdba group as its secondary group.
 
To find the OSDBA group execute below command
$RDBMS_ORACLE_HOME/bin/osdbagrp

To find groups associated with grid home user exeute
groups orgrid


 2. Grid Infrastructure owner doesn't have write permission to database dbs ($ORACLE_HOME/dbs) directory.

Make sure that grid home owner is having permission to write on $RDBMS_ORACLE_HOME/dbs location.

 

No comments :

Post a Comment