查看: 1319|回复: 0

[Oracle数据库] 12c broker fast-start failover - ORA-16820解决

发表于 2018-3-8 08:00:02

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

  1. DGMGRL>
  2. DGMGRL> show configuration;
  3. Configuration - dg_config
  4. Protection Mode: MaxAvailability
  5. Members:
  6. orcl - Primary database
  7. Error: ORA-16820: fast-start failover observer is no longer observing this database
  8. orcldg - (*) Physical standby database
  9. Error: ORA-16820: fast-start failover observer is no longer observing this database
  10. Fast-Start Failover: ENABLED
  11. Configuration Status:
  12. ERROR (status updated 26 seconds ago)
  13. DGMGRL>
  14. DGMGRL>
  15. DGMGRL> show configuration;
  16. Configuration - dg_config
  17. Protection Mode: MaxAvailability
  18. Members:
  19. orcl - Primary database
  20. Error: ORA-16820: fast-start failover observer is no longer observing this database
  21. orcldg - (*) Physical standby database
  22. Error: ORA-16820: fast-start failover observer is no longer observing this database
  23. Fast-Start Failover: ENABLED
  24. Configuration Status:
  25. ERROR (status updated 20 seconds ago)
  26. DGMGRL> start observer;
  27. [P001 02/27 07:04:10.37] Authentication failed.
  28. DGM-16979: Unable to log on to the primary or standby database as SYSDBA
  29. Failed.
  30. DGMGRL> connect sys/sys ##这里需要注意一下,使用sys用户连接
  31. Connected as SYSDG.
  32. DGMGRL> start observer
  33. Observer started
  34. #再次查看
  35. [root@roidb01 ~]# su - oracle
  36. Last login: Tue Feb 27 06:45:19 CST 2018 on pts/0
  37. <roidb01:orcl:/home/oracle>$dgmgrl /
  38. DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
  39. Copyright (c) 2000, 2013, Oracle. All rights reserved.
  40. Welcome to DGMGRL, type "help" for information.
  41. Connected as SYSDG.
  42. DGMGRL> show configuration;
  43. Configuration - dg_config
  44. Protection Mode: MaxAvailability
  45. Members:
  46. orcl - Primary database
  47. orcldg - (*) Physical standby database
  48. Fast-Start Failover: ENABLED
  49. Configuration Status:
  50. SUCCESS (status updated 25 seconds ago)
  51. DGMGRL>
复制代码


回复

使用道具 举报