ORA-16191: Primary log shipping client not logged on standby

问题

解决方案

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 

Oracle 登录触发器