Oracle DG 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]