Creating ASMSNMP User reports ORA-15306

简介: In this Document  Symptoms   Cause   Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.

In this Document
  Symptoms
  Cause
  Solution




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
 
转载自: http://myoracleguide.com/msa/Creating%20ASMSNMP%20User%20reports%20ORA-15306%20ASM%20Password%20File%20Update%20Failed%20On%20At%20Least%20One%20Node.htm


相关文章
|
Oracle 关系型数据库
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.1)
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.
2794 0
|
机器学习/深度学习 Oracle 关系型数据库