Creating ASMSNMP User reports ORA-15306

路途中的人2012發表於2016-06-30

In this Document
  
  
  




Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Creating the ASMSNMP user on 11.2 ASM RAC reports the next error:


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

Cause

The ORA-15306 error demonstrates that the ASM password file is missing in one or several node(s) or it is corrupt.

Solution

1) Remove all the ASM password files from each node:

rm Grid Oracle Home/dbs/orapw+ASM1
rm Grid Oracle Home/dbs/orapw+ASM2
.
.
rm Grid Oracle Home/dbs/orapw+ASM<..n>


2) Create ASM password file manually on the first node as the OS user which owns the Grid Infrastructure:


$> orapwd file='orapw+ASM1' entries=5 password=<here your password>


3) Copy the password file to all nodes with the correct ASM instance name:


scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM2
scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM3
.
.
scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM<..n>


4) Add the ASMSNMP user in ASM instance, and grant sysdba privilege to it:



SQL> create user asmsnmp identified by <password>;


SQL> grant sysdba to asmsnmp;

5) Verify the ASMSNMP user was created:


SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE
 
轉載自:


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29067253/viewspace-2121299/,如需轉載,請註明出處,否則將追究法律責任。

相關文章