从未想过还有这需求,当然是给监控用的,来吧
11.2.0.4 RAC linux
create user jk identified by jk123;
居然提示
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node
字面意思是
在另一个节点口令文件上更新失败
看告警日志


印象中应该有个命令能看到口令文件的位置,找了半天没找到,根据报错直接搜MOS吧,
又是果然,找到两篇
How To Recreate The ASM Password File And Change ASM Users Password On 11.2 RAC. (Doc ID 1638586.1)
Creating ASMSNMP User reports ORA-15306: ASM Password File Update Failed On At Least One Node. (Doc ID 1137504.1)
忘记了11g时代,asm的口令文件独立各自存放在$ORACLE_HOME/dbs目录下,而且还有些细微差别

检查当前环境,节点1有一个orapw+ASM文件,节点2的dbs目录下没有。
所以解决方案是
scp orapw+ASM to remote node #2: /dbs/
scp orapw+ASM to remote node #3: /dbs/
...
阅读(17993) | 评论(0) | 转发(0) |