问题
解决方案
Error 1017 / ORA-16191 In Standby Alertlog (Doc ID 2225190.1)
ORA-16191 ORA-01017 on logical standby (Doc ID 2497091.1)
1 检查主备库密码文件是否一致,所有节点均需要用md5sum检查,并保持一致
2 检查是否存在登录触发器
select trigger_name,owner,status from dba_triggers where upper(DESCRIPTION) like '%LOGON%';
select trigger_name,owner,status from dba_triggers where status='ENABLED' and owner ='SYS';
如果存在,则需要在备库添加参数禁用触发器
alter system set "_system_trig_enabled"=false;
show parameter _system_trig_enabled