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]