Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

could not validate asmsnmp password due to following errorora-01031:insufficent privileges

could not validate asmsnmp password due to following errorora-01031:insufficent privileges

ERROR

During Create new database, It shows following errors
“could not validate asmsnmp password due to following error ora-01031:insufficent privileges”

SOLUTION

Step 1. Create Password file for ASM Instance

$orapwd file=/u0/app/11.2.0/grid/dbs/orapw+ASM password=anypassword
Step 2.   $sqlplus / as sysasm
SQL>create user asmsnmp identified by password;
SQL>grant sysdba to asmsnmp;
Related Posts
Write a comment