[Dataguard]ORA-16191: Primary log shipping client not logged on standby問題解決

今天朋友Dataguard備庫無法同步主庫的問題，大概場景如下：

1.備庫startup，日誌同步語句執行都沒問題，但是備庫就是無法同步主庫的內容

2.觀察了下備庫的歸檔同步情況，發現都是0表示未同步主庫資料過來，然後看了下警告日誌檔案的內容，發現如下問題

<msg time="2016-01-20T00:57:57.734+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 Check that the primary and standby are using a password file
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 and that the SYS password is same in the password files.
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
       returning error ORA-16191
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 ------------------------------------------------------------
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 FAL[client, ARC2]:Error 16191 connecting to orcl for fetching gap sequence
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 Errors in file /home/oracle/diag/rdbms/dg/dg/trace/dg_arc2_26257.trc:
ORA-16191: Primary log shipping client not logged on standby
 

<msg time="2016-01-20T00:57:57.735+08:00" org_id="oracle" comp_id="rdbms"
 client_id='' type='UNKNOWN' level='16'
 host_id='testdg' host_addr='127.0.0.1' module=''
 pid='26257'>
 Errors in file /home/oracle/diag/rdbms/dg/dg/trace/dg_arc2_26257.trc:
ORA-16191: Primary log shipping client not logged on standby
 

3.問題解決方式其實很簡單，在主庫重新生成口令檔案傳到備庫中即可。問題的主要思路還是要根據警告日誌的內容做對應的排查。