[Enmotech] Q: DG主备传输中断,报错ORA-16191,重新copy密码文件后恢复正常

  • From: "杨康" <kang.yang@xxxxxxxxxxxx>
  • To: "enmotech" <enmotech@xxxxxxxxxxxxx>
  • Date: Thu, 16 Jul 2015 20:55:22 +0800

大家好:


在2 node RAC+DG环境遇到如下情况:
主库2节点、备库密码文件均一致(搭建时scp传过去、改名)
运行一段时间后,主库1节点报错,不能正常发送日志到备库,报错ORA-16191。


经检查:
1.主、备库remote_login_passwordfile参数均为exclusive;
2.密码文件均没有进行人为重建,且权限可读;
3.备库同样报FAL error,代码为16191;
4.将主库1节点密码文件重新scp到备库并改名,DG通讯恢复正常,报错消失。

请问大家是否遇到过这种情况,是何原因?如何解决呢?




主库告警日志如下:

Wed Jul 15 12:01:37 2015
ARC3 started with pid=37, OS id=11397
Thread 2 advanced to log sequence 4 (before internal thread enable)
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log
switch
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
------------------------------------------------------------
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARCH: Error 16191 Creating archive log file to 'STDB'

备库告警日志:
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
------------------------------------------------------------
FAL[client, ARC3]: Error 16191 connecting to RACDB for fetching gap sequence





------------------

Best Regards.

-杨康
--------------------------------------------
云和恩墨(北京)信息技术有限公司
Yunhe Enmo(Beijing)Technology Co.,LTD

地址:北京市朝阳区东大桥路8号尚都SOHO北塔B座21层2108



手机: 15901558103
邮箱: kang.yang@xxxxxxxxxxxx
网址: www.enmotech.com

Other related posts:

  • » [Enmotech] Q: DG主备传输中断,报错ORA-16191,重新copy密码文件后恢复正常 - 杨康