ORA-16191: Primary log shipping client not logged on standby

一、客户巡检发现 alert 日志中有报错

alert.log 日志

Mon Jan 28 07:17:15 2013

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

It may be necessary to define the DB_ALLOWED_LOGON_VERSION

initialization parameter to the value "10".   Check the

manual for information on this initialization parameter.

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

Mon Jan 28 07:17:15 2013

Errors in file /opt/oracle/admin/research/bdump/research_arc0_16451.trc:

ORA-16191: Primary log shipping client not logged on standby

PING[ARC0]: Heartbeat failed to connect to standby 'orcl'. Error is 16191.

alert 日志提供思路：

1 、 check password file

2 、 check remote_login_passwordfile

3 、设置 DB_ALLOWED_LOGON_VERSION=10

解决思路：

1 、可能是主库与备库的密码不一致导致

2 、主库 remote_login_passwordfile is set EXCLUSIVE ，所以这个问题不考虑了

3 、设置参数 DB_ALLOWED_LOGON_VERSION ，这个参数不太了解，暂不修改

解决方法：

1 、把主库的密码文件 copy 到备份，覆盖掉备库的密码文件；问题解决！

二、 dump 文件

   Errors in file /opt/oracle/admin/research/bdump/research_arc0_16451.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

ORACLE_HOME = /opt/oracle/product/10.2.0/db_1

System name:     Linux                              ----( 系统 )

Node name:       research.bj.mycos.org --- （ servies_name ）

Release:         2.6.9-89.ELlargesmp ---- （系统内核）

Version:         #1 SMP Mon Jun 22 12:46:58 EDT 2009

Machine:         x86_64   --- （ 64 位系统）

Instance name: research   

Redo thread mounted by this instance: 1

Oracle process number: 17

Unix process pid: 16451, image: oracle@research.bj.mycos.org (ARC0)

*** SERVICE NAME:() 2013-01-23 00:31:20.637

*** SESSION ID:(321.1) 2013-01-23 00:31:20.637

kcrrwkx: nothing to do (start)

*** 2013-01-23 00:32:20.332

Redo shipping client performing standby login

*** 2013-01-23 00:32:20.417 64561 kcrr.c

Logged on to standby successfully

Client logon and security negotiation successful!

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2)

tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x2)

kcrrwkx: work to do 0x2 (end)

Control file resized from 548 to 638 blocks  --- （控制文件增长）

kccrsd_append: rectype = 11, lbn = 274, recs = 1240

kcrrwkx: nothing to do (end)

kcrrwkx: nothing to do (end)

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:33:02.956

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:33:20.572

Redo shipping client performing standby login

*** 2013-01-23 00:33:20.698 64561 kcrr.c

Logged on to standby successfully

Client logon and security negotiation successful!

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:34:20.900

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:35:20.943

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:36:22.067

kcrrwkx: nothing to do (end)

*** 2013-01-23 00:37:22.077

tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2

1 、

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2)

tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x2)

无条件写入 dump 文件，这个不影响正常数据库使用，但是要注意 dump 文件大小，需手动清理

MOS: Large Trace Files with Message "Failed to find ARCH for message" [ID 733795.1]

2 、

kcrrwkx: nothing to do (start)

kcrrwkx: nothing to do (end)

解决方案： 1 、升级； 2 、忽略，不影响数据库。但是要手动清理 dump 文件。

MOS: Many trace files from ARCH generated in 10.2 [ID 372364.1]