千家信息网

12c broker fast-start failover - ORA-16820解决

发表于:2024-11-24 作者:千家信息网编辑
千家信息网最后更新 2024年11月24日,大早上起来测试一波fsfl,遇到一个小问题记录一下。DGMGRL> DGMGRL> show configuration;Configuration - dg_config Protection M
千家信息网最后更新 2024年11月24日12c broker fast-start failover - ORA-16820解决

大早上起来测试一波fsfl,遇到一个小问题记录一下。

DGMGRL> DGMGRL> show configuration;Configuration - dg_config  Protection Mode: MaxAvailability  Members:  orcl   - Primary database    Error: ORA-16820: fast-start failover observer is no longer observing this database    orcldg - (*) Physical standby database       Error: ORA-16820: fast-start failover observer is no longer observing this databaseFast-Start Failover: ENABLEDConfiguration Status:ERROR   (status updated 26 seconds ago)DGMGRL> DGMGRL> DGMGRL> show configuration;Configuration - dg_config  Protection Mode: MaxAvailability  Members:  orcl   - Primary database    Error: ORA-16820: fast-start failover observer is no longer observing this database    orcldg - (*) Physical standby database       Error: ORA-16820: fast-start failover observer is no longer observing this databaseFast-Start Failover: ENABLEDConfiguration Status:ERROR   (status updated 20 seconds ago)DGMGRL> start observer;[P001 02/27 07:04:10.37] Authentication failed.DGM-16979: Unable to log on to the primary or standby database as SYSDBAFailed.DGMGRL> connect sys/sys   ##这里需要注意一下,使用sys用户连接Connected as SYSDG.DGMGRL> start observerObserver started#再次查看[root@roidb01 ~]# su - oracleLast login: Tue Feb 27 06:45:19 CST 2018 on pts/0$dgmgrl /DGMGRL for Linux: Version 12.1.0.2.0 - 64bit ProductionCopyright (c) 2000, 2013, Oracle. All rights reserved.Welcome to DGMGRL, type "help" for information.Connected as SYSDG.DGMGRL> show configuration;Configuration - dg_config  Protection Mode: MaxAvailability  Members:  orcl   - Primary database    orcldg - (*) Physical standby database Fast-Start Failover: ENABLEDConfiguration Status:SUCCESS   (status updated 25 seconds ago)DGMGRL> 
0