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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Numerical test reports
- Creating your first iOS FrameworkiOSFramework
- Error creating bean with name 'tomcatEmbeddedServletContainerFactory'ErrorBeanTomcatServletAI
- Error creating bean with name ‘dataSource‘ErrorBean
- Oracle Respones-Time Analysis ReportsOracle
- Error creating bean with name 解決ErrorBean
- odoo的Aeroo Reports模組使用。Odoo
- 在Dynamics AX 2009中呼叫Crystal Reports
- oracle user$Oracle
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- error creating overlay mount to invalid argument unbuntu系統Error
- 快速瞭解:user-valid和:user-invalid
- 4 Creating a Logical Standby Database 建立邏輯備庫Database
- 【MOS】Creating a PDB ... Fails With ORA-17630 (文件 ID 2090019.1)AI
- Error creating bean with name ‘dataSource‘: Unsatisfied dependency expressed through fieldErrorBeanExpress
- Visual Studio 2022安裝水晶報表(Crystal Reports)
- ORA-31687: error creating worker process with worker id 1Error
- audit by user by table
- Vue @user 元件Vue元件
- User Account Control
- MyBatis-maven-User例子-根據id查詢UserMyBatisMaven
- Dynamics CRM Error- Creating Entity with an invalid parent. Entity: EmailErrorAI
- Consumer Reports:家用電器品牌可靠性評價
- ORA-15041 IN A DISKGROUP ALTHOUGH FREE_MB REPORTS SUFFICIENT SPACE
- Extract rows from a CORRUPT table creating ROWID from DBA_EXTENTS
- Stimulsoft Reports使用者手冊:如何建立關係
- Oracle OCP(28):USEROracle
- Auth::user() 踩坑
- user表的改
- LightBeter Software User Agreement
- Django的User ModelDjango
- Make sure you configure your "user.name" and "user.email" in git.AIGit
- App\User 替換為 App\Models\User 的問題解決!APP
- @1-MYSQL當前使用者user()與current_user()MySql
- Broker reports ORA-16858: last communication time from redo source could not beAST
- Camunda User Task:Task Listeners
- Shooter Game User Interface StarterGAM
- 2.4、User’s guide (Coroutines)GUIIDE
- User Exits for WM (Warehouse Management)