could not validate asmsnmp password due to following error ora-01031:insufficent privileges
During Create new database, It shows following errors
“could not validate asmsnmp password due to following error ora-01031:insufficent privileges”
Solution : [oracle@mazar ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid [oracle@mazar ~]$ export PATH=/u01/app/oracle/product/11.2.0/grid/bin [oracle@mazar ~]$ export ORACLE_SID=+ASM [oracle@mazar ~]$ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 3 20:54:14 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: sys/Admin543 as sysasm Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Automatic Storage Management option SQL> create user asmsnmp identified by Admin321; User created. SQL> grant sysdba to asmsnmp; Grant succeeded.
2 Comments
Post a comment
DBA 
Hi Mahmod,
I tried yours but it doesn’t work either as Grid, or DB user.
oragrid@vztater1a:~$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 18 16:44:48 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: sys/admin as sysasm
ERROR:
ORA-01031: insufficient privileges
oragrid@vztater1a:~$
oragrid@vztater1a:~$ echo $ORACLE_HOME
/u01/app/product/grid
oragrid@vztater1a:~$ echo $ORACLE_SID
+ASM1
oragrid@vztater1a:~$ echo $PATH
/usr/bin:/usr/sbin:/u01/app/product/grid/bin
oragrid@vztater1a:~$
oragrid@vztater1a:~$ exit
root@vztater1a:~# su – ora11g
ora11g@vztater1a:~$
ora11g@vztater1a:~$ export ORACLE_HOME=/u01/app/product/grid
ora11g@vztater1a:~$ export ORACLE_SID=+ASM1
ora11g@vztater1a:~$ export PATH=/u01/app/product/grid/bin
ora11g@vztater1a:~$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 18 16:49:30 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: sys/admin as sysasm
ERROR:
ORA-01031: insufficient privileges
Comments? Thanks.