Could not validate ASMSNMP Password ORA-01017
oracle11.2.0.4rac+centos7.7+dbca
启用oem控制台后报错Could not validate ASMSNMP Password ORA-01017
[[email protected] oracle]# su - grid
Last login: Tue Jul 7 10:00:55 CST 2020 from 192.168.52.1 on pts/2
[[email protected] ~]$ cd $ORACLE_HOME/dbs
[[email protected] dbs]$ ll
total 16
-rw-rw---- 1 grid oinstall 2708 Jul 7 09:41 ab_+ASM1.dat
-rw-rw---- 1 grid oinstall 1544 Jul 7 09:41 hc_+ASM1.dat
-rw-r--r-- 1 grid oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 grid oinstall 1536 Jul 5 22:26 orapw+ASM
[[email protected] dbs]$ ssh rac2
Last login: Mon Jul 6 18:07:17 2020
[[email protected] ~]$ ll $ORACLE_HOME/dbs
total 16
-rw-rw---- 1 grid oinstall 2708 Jul 7 09:41 ab_+ASM2.dat
-rw-rw---- 1 grid oinstall 1544 Jul 7 09:41 hc_+ASM2.dat
-rw-r--r-- 1 grid oinstall 2851 Jul 5 13:26 init.ora
-rw-r----- 1 grid oinstall 1536 Jul 5 22:26 orapw+ASM
[[email protected] ~]$ exit
logout
Connection to rac2 closed.
[[email protected] dbs]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 7 10:07:40 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create user asmsnmp identified by "abcd1234";
create user asmsnmp identified by "abcd1234"
*
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node
ORA-15321: cannot set attribute with connected clients
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[[email protected] dbs]$ orapwd file=orapw+ASM1 password=abcd1234
[[email protected] dbs]$ ll
total 20
-rw-rw---- 1 grid oinstall 2708 Jul 7 09:41 ab_+ASM1.dat
-rw-rw---- 1 grid oinstall 1544 Jul 7 09:41 hc_+ASM1.dat
-rw-r--r-- 1 grid oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 grid oinstall 1536 Jul 5 22:26 orapw+ASM
-rw-r----- 1 grid oinstall 1536 Jul 7 10:08 orapw+ASM1
[[email protected] dbs]$ scp orapw+ASM1 rac2:$ORACLE_HOME/dbs/orapw+ASM2
orapw+ASM1 100% 1536 960.6KB/s 00:00
[[email protected] dbs]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 7 10:09:24 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create user asmsnmp identified by "abcd1234";
User created.
SQL> grant sysdba to asmsnmp;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[[email protected] dbs]$ asmcmd lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE FALSE
ASMSNMP TRUE FALSE FALSE