大家好:
在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