My Oracle Support Banner

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 later
Oracle 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

  • 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 
             LOCAL_ASM=(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)))

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.