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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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 pgrac1
                        PRCR-1013 : Failed to start resource ora.asm
                        PRCR-1064 : Failed to start resource ora.asm on node pgrac1
                        CRS-2672: Attempting to start 'ora.asm' on 'pgrac1'
                        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=/orcl/app/oracle/product/11.2.0.2/grid/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=/orcl/app/oracle/product/11.2.0.2/grid/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


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