安装数据库勾选OEM的时候,这个地方就要输ASMSNMP密码,报错
查看该用户是否存在
在ASM实例中查询:
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE TRUE FALSE FALSE FALSE 0
ASMSNMP TRUE FALSE TRUE FALSE FALSE FALSE 0
在asmcmd命令中查看:
ASMCMD> lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE TRUE
如果不存在,就创建起来
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:
[grid@host01-+ASM1 ~]$ sqlplus / as sysasm
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