Google it ....

Showing posts with label ASMSNMP. Show all posts
Showing posts with label ASMSNMP. Show all posts

Friday, January 18, 2013

Could not validate asmsnmp password due to following error ora-01031:insufficient privileges

During Creation new database with dbca, It shows following errors
"could not validate asmsnmp password due to following error ora-01031:insufficent privileges"
very strange, in asm instance alert log found message

ORA-01918: user 'ASMSNMP' does not exist
somehow asmsnmp user is not created during grid infrastructure installation, so we have to cretae it manually.
solution :
1) create password file for asm instance.
orapwd file=/u0/app/11.2.0/grid/dbs/orapw+ASM password=anypassword
2) sqlplus / as sysasm
create user asmsnmp identified by password;
grant sysdba to asmsnmp;

enjoy with database creation.