ORA-01031: insufficient privileges From srvctl Commands on ASM Resources or When Connecting Through Listener
(Doc ID 1330604.1)
Last updated on OCTOBER 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Cluserware is unable to start ASM
- Startup attempt from srvctl gives errors as seen below.
srvctl start asm -n <NODE_NAME>1
PRCR-1013 : Failed to start resource ora.asm
PRCR-1064 : Failed to start resource ora.asm on node <NODE_NAME>1
CRS-2672: Attempting to start 'ora.asm' on '<NODE_NAME>1'
ORA-01031: insufficient privileges
- Agent logs shows the following:
2011-06-14 11:32:24.693: [ USRTHRD][1114257728] {1:38712:474} makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=<GRID_HOME>/bin/oracle)(ARGV0=oracle+ASM1)(ENVS='ORACLE_HOME=/orcl/app/oracle/product/11.2.0.2 /grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM1)))
.....
2011-06-14 11:32:24.693: [ USRTHRD][1114257728] {1:38712:474} InstConnection::connectInt: server not attached
2011-06-14 11:32:24.752: [ USRTHRD][1114257728] {1:38712:474} ORA-01031: insufficient privileges
.....
2011-06-14 11:32:24.693: [ USRTHRD][1114257728] {1:38712:474} InstConnection::connectInt: server not attached
2011-06-14 11:32:24.752: [ USRTHRD][1114257728] {1:38712:474} ORA-01031: insufficient privileges
- Local connections to ASM instance (sqlplus / as sysasm ) works.
- However a connection to ASM instance via tns entry like below gives same error as agent gets
Changes
Changes made to <GRID_HOME>/network/admin/sqlnet.ora from default e.g. wallet entries
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |