Google it ....

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.

No comments:

Post a Comment