asmsnmp and sys users missing in ASM.

when you dont see asmsnmp/sys/etc  users are not available in the ASM. there is an easy way to create them back.

As ASM user,

ASMCMD> lspwusr   ---- you will not see any result.

cd $ORACLE_HOME/dbs(grid home)

create orapwd file for sys user that are missing.

then login in to sqlplus and create asmsnmp user and  give required grants that you want...

SQL> create user asmsnmp identified by  xxxxx;

User created.

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID

------------------------------ ----- ----- ----- ----- ----- ----- ----------

SYS                                     TRUE  TRUE  FALSE FALSE FALSE FALSE          0

ASMSNMP                        FALSE FALSE FALSE FALSE FALSE FALSE          0

now you will see the users back in the

ASMCMD> lspwusr

Username sysdba sysoper sysasm

     SYS   TRUE    TRUE  FALSE

ASMCMD> exit

Now you can also use this for monitoring the ASM using asmsnmp account with required privileges..

Hope this Helps......