RAC primary+Single standby日志传输问题
862070Aug 28 2012 — edited Aug 29 2012最近用grid control部署了一套RAC primary+Single standby环境，如下
角色 实例名 IP
主集群数据库1 racdb_racdb1 192.168.2.101
主集群数据库2 racdb_racdb2 192.168.2.102
rac-scan-ip:192.168.2. 201
物理备用 racsdb 192.168.2.200
部署时没有问题，可是当部署完成后，在standby库日志中出现如下错误：
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 29-8月 -2012 07:16:35
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: 操作超时
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.102)(PORT=41124))
WARNING: inbound connection timed out (ORA-3136)
在broker中出现的错误：
racsdb ORA-16191: Primary log shipping client not logged on standby
racdb(racdb2) ORA-16737: the redo transport service for standby database "racsdb" has an error
在实例racdb1执行 alter system switch logfile命令，日志如下：
Wed Aug 29 10:01:19 2012
Thread 1 advanced to log sequence 429 (LGWR switch)
Current log# 1 seq# 429 mem# 0: +DATA/racdb/onlinelog/group_1.261.765379725
Current log# 1 seq# 429 mem# 1: +FRA/racdb/onlinelog/group_1.257.765379727
Wed Aug 29 10:01:24 2012
LNS: Standby redo logfile selected for thread 1 sequence 429 for destination LOG_ARCHIVE_DEST_3
Wed Aug 29 10:01:33 2012
Archived Log entry 957 added for thread 1 sequence 428 ID 0x2d79fb01 dest 1:
在实例racdb2执行 alter system switch logfile命令，日志如下：
Wed Aug 29 10:06:04 2012
Thread 2 advanced to log sequence 474 (LGWR switch)
Current log# 4 seq# 474 mem# 0: +DATA/racdb/onlinelog/group_4.266.765380287
Current log# 4 seq# 474 mem# 1: +FRA/racdb/onlinelog/group_4.260.765380289
Wed Aug 29 10:06:15 2012
Archived Log entry 958 added for thread 2 sequence 473 ID 0x2d79fb01 dest 1:
Wed Aug 29 10:06:17 2012
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[server, ARC4]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance racdb2 - Archival Error. Archiver continuing.
但是两实例的密码和standby的sys密码是一样的，为什么还提示密码不一致呢？
看现象是standby库无法连接到实例racdb2，从而导致实例racdb2日志无法传输至备库。
但是问题出在哪里，请各位帮我分析一下！
谢谢
Edited by: user12030691 on 2012-8-28 下午8:33