Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, July 26, 2012

ORA-15306: ASM password file update failed on at least one node

Error:
ORA-15306: ASM password file update failed on at least one node

Error by itself is very misleading someone would think the password might have messed up or got corrupted or missing.

In my case none of the above were true.

When I tried this sql i.e trying to alter the password of a user on the ASM instance.

SQL> alter user dbsnmp identified by test;
alter user dbsnmp identified by test.
                                *
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node




SQL> show parameter remote_login_passwordfile

NAME                                 VALUE
-------------------------         ------------
remote_login_passwordfile            EXCLUSIVE


password file parameter is set properly

My password file exists on all nodes and in fact I can connect  as sysasm to the instance so I know it is not the password file issue then what?

Here my problem was the user doesn't exists in the ASM to begin with..
SQL> select * from v$pwfile_users;

USERNAME      SYSDBA          SYSOPER         SYSASM
--------------------------------------------------------------------------------
SYS              TRUE            TRUE            FALSE

I don't have the user in the database for which  I am trying to change the password for.

Now go ahead and create the user in the ASM database.


SQL> create user dbsnmp identified by test;

User created.


SQL>grant sysdba to dbsnmp;



SQL> select * from v$pwfile_users;

USERNAME      SYSDBA          SYSOPER         SYSASM
--------------------------------------------------------------------------------
SYS                  TRUE            TRUE            FALSE
DBSNMP           TRUE            TRUE            TRUE


4 comments:

Arindam said...

Thank u. Just what I was looking for.

Steve Harville said...

Thanks for posting this. I ran into the same issue setting up OEM Cloud Control 12c on our Exadata systems. OEM12c expects "asmsnmp" which was not present on out ASM instances.

Steve Harville said...
This comment has been removed by the author.
mehak kashish said...

excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8 posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee training in hyderebad