Home > ASM > How to create asmsnmp user in ASM instance(11g).

How to create asmsnmp user in ASM instance(11g).

March 9, 2016

While i got a chance to create asmsnmp user in ASM instance which is RAC invironment.

Initially i thought asmsnmp user already exists and tried to change the password. But i found the below when i tried to change password when user does not exits.

njunnode2<grid>sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 8 15:31:19 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> Alter user asmsnmp identified by tibcouat123;
Alter user asmsnmp identified by tibcouat123
*
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node
SQL>

And found that user does not exists.

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS TRUE TRUE FALSE

SQL>

Then i checked the presence of password file on both nodes.

njundNODE1<grid>cd $ORACLE_HOME/dbs
njundNODE1<grid>ls -ltr
total 25
-rw-r–r– 1 grid oinstall 2851 May 15 2009 init.ora
-rw-r—– 1 grid oinstall 1536 Jul 11 2014 orapw+ASM.old
-rw-r—– 1 grid oinstall 1536 Nov 4 15:47 orapw+ASM
-rw-rw—- 1 grid oinstall 1780 Mar 4 10:52 ab_+ASM1.dat
-rw-rw—- 1 grid oinstall 1544 Mar 8 10:09 hc_+ASM1.dat
njundNODE1<grid>

njundNODE2<grid>cd $ORACLE_HOME/dbs
njundNODE2<grid>ls -ltr
total 25
-rw-r–r– 1 grid oinstall 2851 Jul 11 2014 init.ora
-rw-r—– 1 grid oinstall 1536 Jul 11 2014 orapw+ASM.old
-rw-r—– 1 grid oinstall 1536 Nov 4 15:49 orapw+ASM
-rw-rw—- 1 grid oinstall 1782 Mar 8 10:09 ab_+ASM2.dat
-rw-rw—- 1 grid oinstall 1544 Mar 8 10:09 hc_+ASM2.dat
njundNODE2<grid>

Now i created the user.

SQL> create user asmsnmp identified by tibcouat123;

User created.

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS TRUE TRUE FALSE
ASMSNMP FALSE FALSE FALSE

SQL> grant sysdba to asmsnmp;

Grant succeeded.

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS TRUE TRUE FALSE
ASMSNMP TRUE FALSE FALSE

SQL>

 

Now i checked at OS level for password file details. Interestingly passwordfile has been changed on both nodes.

njundNODE1<grid>ls -ltr
total 25
-rw-r–r– 1 grid oinstall 2851 May 15 2009 init.ora
-rw-r—– 1 grid oinstall 1536 Jul 11 2014 orapw+ASM.old
-rw-rw—- 1 grid oinstall 1780 Mar 4 10:52 ab_+ASM1.dat
-rw-rw—- 1 grid oinstall 1544 Mar 8 10:09 hc_+ASM1.dat
-rw-r—– 1 grid oinstall 1536 Mar 8 15:32 orapw+ASM
njundNODE1<grid>

njundNODE2<grid>ls -ltr
total 25
-rw-r–r– 1 grid oinstall 2851 Jul 11 2014 init.ora
-rw-r—– 1 grid oinstall 1536 Jul 11 2014 orapw+ASM.old
-rw-rw—- 1 grid oinstall 1782 Mar 8 10:09 ab_+ASM2.dat
-rw-rw—- 1 grid oinstall 1544 Mar 8 10:09 hc_+ASM2.dat
-rw-r—– 1 grid oinstall 1536 Mar 8 15:32 orapw+ASM
njundNODE2<grid>s

Please note that password has been changed @ Mar 8 15:32

 

 

Advertisements
Categories: ASM
%d bloggers like this: