DG故障ORA-16191 ORA-01017 and ORA-16000 shipping the logs to Standby database

jiawang

问题描述
主库日志：

Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
求助MOS文档：
ORA-16191 ORA-01017 and ORA-16000 shipping the logs to Standby database (文档 ID 2129339.1)
文章中提到引起该问题可能的原因是备库中一个隐藏参数“_system_trig_enabled”引起的，该参数控制了备库登录是否使用触发器，默认：TRUE。

解决方法
在备库上修改隐藏参数为FALSE

查看参数值：
SELECT I.KSPPINM NAME,
       I.KSPPDESC DESCRIPTION,
       CV.KSPPSTVL VALUE,
       CV.KSPPSTDF ISDEFAULT
  FROM SYS.X$KSPPI I, SYS.X$KSPPCV CV
WHERE I.INST_ID = USERENV('Instance')
   AND CV.INST_ID = USERENV('Instance')
   AND I.INDX = CV.INDX
   AND I.KSPPINM LIKE '_system_trig_enabled'
ORDER BY REPLACE(I.KSPPINM, '_', '');
NAME                   DESCRIPTION              VALUE     ISDEFAULT
------------------------------ ------------------------------ ---------- ---------
_system_trig_enabled           are system triggers enabled    TRUE     TRUE

修改参数：
ALTER SYSTEM SET "_system_trig_enabled"=FALSE;