GoldenGate OGG-01032 There Is a Problem in Network Communication Error in Writing to Rmt Remote Trai

GoldenGate OGG-01032 There Is a Problem in Network Communication Error in Writing to Rmt Remote Trai GoldenGate OGG-01032 There Is a Problem in Network Communication Error in Writing to Rmt Remote TraiTo Bottom GoldenGate OGG-01032 There Is a Problem in Network Communication Error in Writing to Rmt Remote Trai

GoldenGate OGG-01032 There Is a Problem in Network Communication Error in Writing to Rmt Remote Trai

In this Document

  Symptoms
  Changes
  Cause
  Solution

 

APPLIES TO:

Oracle GoldenGate - Version 10.0.0.0 to 11.2.1.0.3 [Release 10.0.0 to 11.2]
Information in this document applies to any platform.

SYMPTOMS


The pump does not start. The following errors are captured in the report file:

2012-03-30 10:50:57  ERROR   OGG-01032  There is a problem in network communication, a remote file problem, encryption keys for target and
source do not match (if using ENCRYPT) or an unknown error. Length is 3 - 000000: 46 45 00                

CHANGES

No changes made to the OS or GoldenGate.

CAUSE

Trail file system on target goes out of space causing the pump  to hang. The issue is ultimately due to an  interrupted rmt trail writing caused by connection issues because the target file system cannot be written to.

 

Note that this is a single instance of a broader issue. Anytime the collector server fails for any reason, it will look like a TCP or network issue to the pump. This can be space or security or path issues or anything else.

SOLUTION

Firstly, simply try stopping the extract pump and re-starting it agaın, otherwise, follow these directives

 

Fix any target space issue.


1) Go the source server and login into ggsci

2a) Execute the below command
alter <extract pump> etrollover

2b) start <extract pump>

(ETROLLOVER will force the pump to write on a fresh trail)

3) Go the target server and check if the new trail files are being generated.

4) Verify if the first record in the new trail file is indeed the next record in the local extract trail. (It can be done by looking at the RBA value through the logdump utility)

5) Alter the replicat to the new trail file
alter <replicat> extseqno <new trail file> extrba 0

6) Start the Replicat process

7) Verify if all the processes are running fine.

上一篇:lync server 2013边缘前端无法同步


下一篇:[Linux] 009 链接命令