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

error¶

The integrated mode extraction process is abnormal abend.

ggserr.log log prompts as follows

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

reason¶

After querying Mos, it is found that the problem is a potential logminer error. There is a problem when the PGA memory is released for the process, which causes the process to fail.

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

solution¶

The official has given 3 methods, I used the second one here

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