Running srvctl command giving insufficient privileges issue.
./srvctl start database -d DEV
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.
./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.
Post a Comment
Post a Comment