Skip to content
Advertisements

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.
Advertisements
2 Comments Post a comment
  1. J Wang #

    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.

    October 18, 2011

Trackbacks & Pingbacks

  1. [A] Could not validate asmsnmp password | Oracle in Thai | Oracle in Thai | Oracle User Group in Thailand |

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: