Creating ASMSNMP User reports ORA-15306
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
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>
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>
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;
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
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE
轉載自:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29067253/viewspace-2121299/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-600[13013] Error While Creating a User. [ID 297595.1]ErrorWhile
- 【ASM】ASMSNMP使用者已存在ASM
- SAP security reports
- Active Session History ReportsSession
- Numerical test reports
- Oracle Respones-Time Analysis ReportsOracle
- odoo的Aeroo Reports模組使用。Odoo
- Crystal reports 9 的使用示例
- Creating the Database (58)Database
- Intermediate Crystal Reports XI TrainingAI
- Creating a Physical Standby DatabaseDatabase
- Creating Secondary IndexesIndex
- Creating the SYSAUX Tablespace (72)UX
- dbca建庫的時候忘記asmsnmp密碼,臨時修改ASM密碼
- Systemwide Tuning using STATSPACK ReportsIDE
- Creating your first iOS FrameworkiOSFramework
- Error creating bean with name ‘dataSource‘ErrorBean
- Creating External Lists From Code
- Creating Test Script With Bind Variable
- Creating an Index OnlineIndex
- Creating Compressed Tables and IndexesIndex
- android-Creating Multiple APKs for Different Screen Sizes,Creating Multiple APKs for Different GL TeAndroidAPK
- 安裝Oracle RAC時,不能驗證ASMSNMP密碼問題的解決OracleASM密碼
- Error creating bean with name 解決ErrorBean
- creating indexing for SQL tunningIndexSQL
- 【OH】Creating a Database with the CREATE DATABASE StatementDatabase
- Creating Managed Today Screen Items
- Creating a physical standby from ASM primaryASM
- Oracle10gR2新特色:Generate ASH ReportsOracle
- oracle user$Oracle
- RxJava操作符之Creating ObservablesRxJava
- android-Creating a Navigation DrawerAndroidNavigation
- Miscellaneous Information about Creating Indexes on Partitioned TablesORMIndex
- Stimulsoft Reports使用者手冊:如何建立關係
- Running Workload Repository Reports Using SQL ScriptsSQL
- [絕對原創] SAP Get User data by User ID
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- user 和 user profile是聚合的關係嗎