ERROR OGG-02028 Failed to attach to logmining server ORA-26927

集成模式抽取进程异常abend.

ggserr.log日志提示如下

ERROR OGG-02028 Failed to attach to logmining server OGG$ABCD error 26927 - ORA-26927: altering an outbound server with a remote capture is not allowed

经查询Mos得知，该问题是logminer潜在错误，为进程释放PGA内存时出现问题，导致进程失败

Potential logminer bug.Problem when the PGA memory is being freed for the process resulting in the process failure.

官方给出了3中方法，我这里使用了第二种

    
Copyright (c) 2021, Oracle. All rights reserved. Oracle Confidential.
Click to add to Favorites        IE abends with ERROR OGG-02028 Failed to attach to logmining server ORA-26927 (Doc ID 2127219.1)    To BottomTo Bottom    

In this Document
    Symptoms
    Changes
    Cause
    Solution
    References


Applies to:
Oracle GoldenGate - Version 11.2.1.0.3 to 11.2.1.0.39 [Release 11.2]
Information in this document applies to any platform.
Symptoms

 IE abends with ERROR OGG-02028 Failed to attach to logmining server OGG$ABCD error 26927 - ORA-26927: altering an outbound server with a remote capture is not allowed

 
Changes

 None
Cause

Potential logminer bug.Problem when the PGA memory is being freed for the process resulting in the process failure.
Solution

--  Solution #1 --

 

Double the MAX_SGA_SIZE parameter for the affected Extract and restart.
This is to see if the abend is related to memory.

TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 512, parallelism 2)

 

-- Solution #2 --

Un-register and register the extract again

ggsci> UNREGISTER EXTRACT <ext_name> DATABASE

ggsci> REGISTER EXTRACT <ext_name> DATABASE

ggsci> start <ext_name>

 

-- Solution #3 --

Downgrade to classic extract

第二种亲测可用。