ORA-01031: insufficient privileges On ASM – Grid Infrastructure 11gR2

Posted on by Osama Mustafa in Database
Today like any other day started with customer call , Telling me There is problem on Grid infrastructure after restarting both node, They change heartbeat from cables to connected on switch after i told them to do this.

The Error in the logs like the  below :-
CRS-5011:Check of resource “+ASM” failed: details at “(:CLSN00006:)”

Node #2 was running without any problem , the issue was with node #1 and nothing changed recently.

The Error in Node #1 :-

crsctl start cluster

PRCR-1079 : Failed to start resource ora.asm
ORA-01031: insufficient privileges
CRS-5017: The resource action “ora.asm start” encountered the following error:
ORA-01031: insufficient privileges
. For details refer to “(:CLSN00107:)” in “/u01/app/grid/11.2.0.4/log/lux335/agent/ohasd/oraagent_oracle/oraagent_oracle.log”.

as you see from the above error “ORA-01031: insufficient privileges” i was running this command as root.
After check node #1 the solution so simple :-

Under $GRID_HOME/network/admin
vi sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NONE)

which is wrong and to be changed to the following value :-

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Reboot Node #1 and everything running successfully.

Thank you
Osama mustafa

Published by Osama Mustafa

Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers. In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases. Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.

4 thoughts on “ORA-01031: insufficient privileges On ASM – Grid Infrastructure 11gR2”

  2. absolutely Not, but in my case i only reboot just to test clusterware if it's started with OS Automatically because i didn't know anything about changes on the environment. 🙂

    Like

    Reply

  3. Thanks 🙂 Hope you tried starting the cluster after changing the parameter in sqlnet.ora, before the reboot (to test the automatic cluster start up).

    Like

    Reply

  4. INFO: Read: Configuring ASM failed with the following message:INFO: Read: Configuring HA resource failed. The following error occured:INFO: Read: PRCR-1079 : Failed to start resource ora.asmINFO: Read: CRS-5017: The resource action “ora.asm start” encountered the following error:INFO: Read: ORA-00119: invalid specification for system parameter LOCAL_LISTENERINFO: Read: ORA-00132: syntax error or unresolved network name 'LISTENER_+ASM'How would i solve above?

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.