ITPub博客

首页 > 数据库 > Oracle > Creating ASMSNMP User reports ORA-15306

Creating ASMSNMP User reports ORA-15306

Oracle 作者:yyp2009 时间:2014-02-13 18:28:11 0 删除 编辑

Creating ASMSNMP User reports ORA-15306: ASM Password File Update Failed On At Least One Node. (文档 ID 1137504.1)

Applies to: 

Oracle Database - Enterprise Edition - Version 11.1.0.7 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+ASM
rm Grid Oracle Home/dbs/orapw+ASM
.
.
rm Grid Oracle Home/dbs/orapw+ASM



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

$> orapwd file='orapw+ASM' entries=5 password=



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

scp orapw+ASM to remote node #1 : Grid Oracle Home/dbs/orapw+ASM
scp orapw+ASM to remote node #2 : Grid Oracle Home/dbs/orapw+ASM
.
.
scp orapw+ASM to remote node # : Grid Oracle Home/dbs/orapw+ASM



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

SQL> create user asmsnmp identified by ;


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

 

Note: Pre 11gR2, each node in the cluster had ASM password file named as orapw.  Starting 11gR2, password file in a RAC cluster is named using the format orapw<+’_asmsid’> .”_asmsid” is an underscore parameter that defines default SID/Name of ASM instance:

                                           Value   Value
Underscore Parameter                       Session Instnc  Description
------------------------------------------ ------- ------- ---------------------------------------------------------
_asmsid                                    asm     asm     ASM instance id



Example:
 
Pre 11gR2:

Password file on Node1: orapw+ASM1
Password file on Node2: orapw+ASM2

 11gR2 and onwards:

Password file on Node1: orapw+ASM
Password file on Node2: orapw+ASM

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-1081051/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1025796