"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