DanBrother的部落格

Issue:
ORA-15306: ASM Password File Update Failed On At Last One Node While Createing ASMSNMP User

Cause:
ASM password file is missing or typo in one or several node(s) or it is corrupt.


Solution:
cd $GRID_HOME/dbs
orapwd file=orapw+ASM1 entries=5 passwod=mypwd
scp -p orapw+ASM1 rac2:/grid/grid11203/dbs/orapw+ASM2

export ORACLE_SID=+ASM1
sqlplus / as sysasm

SQL> create user asmsnmp identified by mypwd;
grant sysdba to asmsnmp;

select * from gv$pwfile_users
order by 1,2;
>>

INST_ID USERNAME SYSDB SYSOP SYSAS
---------- ---------------------------- ---------- --------- ---------
1               ASMSNMP TRUE FALSE FALSE
1               SYS           TRUE TRUE TRUE
2               ASMSNMP TRUE FALSE FALSE
2               SYS           TRUE TRUE TRUE