GoldenGate OGG-01032 There Is a Problem in Network Communication Error

今早接到机房节点故障，ogg同步进程中断，报错如下，解决方法如下。

看到goldengate 抽取进程和，复制进程正常，再看传输进程中断。重启传输进程后，查看ogg告警日志报错。

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 0

大概是由于网络传输中断，导致传输文件写不到目标数据库。

下面是解决方法

1.登陆源端数据库。把传输进程重新生成一个检查点。然后启动传输进程

alter etrollover

Start   start

2.登陆目标端数据库查看最后一个trail 号，然后根据trail号重新生成复制进程文件，然后启动复制进程

alter extseqno extrba 0

Start  replicat

下面为matelink对应的官方解答。以及解决方法。

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 etrollover

2b) start

(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 extseqno extrba 0

6) Start the Replicat process

7) Verify if all the processes are running fine.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27017639/viewspace-2040265/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27017639/viewspace-2040265/