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


相关文章
|
SQL Oracle 关系型数据库
Backup and Recovery User‘s Guide 学习笔记
For each file that is not listed in the CREATE CONTROLFILE statement but is present in the data dictionary, an entry is created for them in the control file. These files are named as MISSINGnnnnn, where nnnnn is a 5-digit number starting with 0
128 0
ORA-09925: Unable to create audit trail file
ORA-09925: Unable to create audit trail file
177 0
|
SQL 测试技术 数据库
0131 ORA-00942 and AUTHID CURRENT_USER
[20180131]ORA-00942 and AUTHID CURRENT_USER.txt --//偶尔写一个存储过程调用一些系统视图.经常遇到一些ORA-00942,有时候很烦.
1170 0
|
机器学习/深度学习 Oracle 关系型数据库

热门文章

最新文章