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

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]