could not validate asmsnmp password due to following errorora-01031:insufficent privileges
May 16, 2017
Errors/Workarounds11g, Oracle Database Material
ERROR
During Create new database, It shows following errors
“could not validate asmsnmp password due to following error ora-01031:insufficent privileges”
“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