Forum Stats

  • 3,769,804 Users
  • 2,253,023 Discussions
  • 7,875,210 Comments

Discussions

GoldenGate extract OGG-02830 Formatting error. Please help!

user13419014
user13419014 Member Posts: 5
edited Sep 15, 2020 11:12AM in GoldenGate

Hi All,

I hope this is simple for a learned member to answer.

I'm trying to run GoldenGate for the first time, on an old Ora11.2.0.3.0 box in classic extract mode, I've got it setup hitting the db, but the extract won't fully start. I get this

2020-03-30 16:19:41  INFO    OGG-01515  Positioning to begin time 30 Mar 2020 13:46:27. (waits for about a min....)

Source Context :

  SourceModule            : [er.redo.ora.rdr]

  SourceID                : [er/redo/oracle/redoorardr.c]

  SourceMethod            : [RedoClassic::getLogPosition]

  SourceLine              : [5548]

  ThreadBacktrace         : [17] elements

                          : [L:\oggy\gglog.dll([email protected]@[email protected])]

                          : [L:\oggy\gglog.dll([email protected]@@[email protected]@[email protected]@IZZ)]

                          : [L:\oggy\gglog.dll([email protected]@[email protected]@[email protected]@[email protected]@Z)]

..... loads of ggtrydebughooks....

2020-03-30 16:21:03  ERROR   OGG-02830  Formatting error.

2020-03-30 16:21:03  ERROR   OGG-01668  PROCESS ABENDING.

I've tried searching for the error code and message, but can't find anything that explains what the problem is. If someone could help me out that would be amazing.

Thanks

Jim

Jeison Junqueira

Best Answer

Answers

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy
    edited Mar 30, 2020 11:44AM

    Jim,

    Please share the complete report file.

    Regards,

    Veera

  • user13419014
    user13419014 Member Posts: 5
    edited Mar 30, 2020 12:25PM

    Hi Veera,

    Yeah no problem. Thanks for looking

    ***********************************************************************

                     Oracle GoldenGate Capture for Oracle

        Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO

          Windows x64 (optimized), Oracle 11g on Oct 19 2019 11:15:45

    Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2020-03-30 16:19:41

    ***********************************************************************

    Operating System Version:

    Microsoft Windows Server 2016, on x64

    Version 10.0 (Build 14393)

    Process id: 6560

    Description:

    ***********************************************************************

    **            Running with the following parameters                  **

    *********************************************************************

    2020-03-30 16:19:41  INFO    OGG-03059  Operating system character set identified as windows-1252.

    2020-03-30 16:19:41  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

    2020-03-30 16:19:41  INFO    OGG-02095  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15.

    EXTRACT devtest

    SETENV (NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P15")

    USERID [email protected], PASSWORD ***

    EXTTRAIL L:\oggy\dirdat\st

    TABLE DEV.SRS_CAP;

    2020-03-30 16:19:41  INFO    OGG-01635  BOUNDED RECOVERY: not used. NORMAL RECOVERY only used due to altered checkpoint.

    2020-03-30 16:19:41  INFO    OGG-01815  Virtual Memory Facilities for: BR

        anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

        file alloc: MapViewOfFile  file free: UnmapViewOfFile

        target directories:

        L:\oggy\BR\DEVTEST.

    Bounded Recovery Parameter:

    BRINTERVAL = 4HOURS

    BRDIR      = L:\oggy\

    2020-03-30 16:19:41  INFO    OGG-01851  filecaching started: thread ID: 2091493089856.

    2020-03-30 16:19:41  INFO    OGG-01815  Virtual Memory Facilities for: COM

        anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

        file alloc: MapViewOfFile  file free: UnmapViewOfFile

        target directories:

        L:\oggy\dirtmp.

    2020-03-30 16:19:41  WARNING OGG-01842  CACHESIZE PER DYNAMIC DETERMINATION (16G) LESS THAN RECOMMENDED: 64G (64bit system)

    vm found: 22.25G

    Check swap space. Recommended swap/extract: 128G (64bit system).

    2020-03-30 16:19:41  INFO    OGG-25340 

    Database Version:

    Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

    PL/SQL Release 11.2.0.3.0 - Production

    CORE 11.2.0.3.0 Production

    TNS for Linux: Version 11.2.0.3.0 - Production

    NLSRTL Version 11.2.0.3.0 - Production.

    2020-03-30 16:19:41  INFO    OGG-25341 

    Database Language and Character Set:

    NLS_LANGUAGE     = "AMERICAN"

    NLS_TERRITORY    = "AMERICA"

    NLS_CHARACTERSET = "WE8ISO8859P15".

    2020-03-30 16:19:41  INFO    OGG-06604  Database DEV.DEVSERVER.NET CPU info: CPU Count 24, CPU Core Count 12, CPU Socket Count 2.

    2020-03-30 16:19:41  INFO    OGG-02089  Source redo compatibility version is: 11.2.0.0.0.

    2020-03-30 16:19:41  INFO    OGG-02776  Native data capture is enabled for Oracle NUMBER data type.

    2020-03-30 16:19:41  INFO    OGG-01515  Positioning to begin time 30 Mar 2020 13:46:27.

    Source Context :

      SourceModule            : [er.redo.ora.rdr]

      SourceID                : [er/redo/oracle/redoorardr.c]

      SourceMethod            : [RedoClassic::getLogPosition]

      SourceLine              : [5548]

      ThreadBacktrace         : [17] elements

                              : [L:\oggy\gglog.dll([email protected]@[email protected])]

                              : [L:\oggy\gglog.dll([email protected]@@[email protected]@[email protected]@IZZ)]

                              : [L:\oggy\gglog.dll([email protected]@[email protected]@[email protected]@[email protected]@Z)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(ERCALLBACK)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(_ggTryDebugHook)]

                              : [L:\oggy\extract.exe(ERCALLBACK)]

                              : [L:\oggy\extract.exe(CommonLexerNewSSD)]

                              : [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]

                              : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]

    2020-03-30 16:21:03  ERROR   OGG-02830  Formatting error.

    2020-03-30 16:21:03  ERROR   OGG-01668  PROCESS ABENDING.

    Regards

    Jim

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy
    edited Mar 30, 2020 12:57PM Accepted Answer

    Hi Jim,

    OGG 19c supports minimum 11.2.0.4. It is not certified to support 11.2.0.3.

    Please check the below link,

    https://www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls

    Regards,

    Veera

    user13419014
  • ORA-00001
    ORA-00001 Member Posts: 1 Green Ribbon
    edited Jun 15, 2020 6:45AM

    Hi ORASCN:

    I met the same failure which my oracle database version is '11.2.0.4.0' and ogg version is '19.1.0.0.1',Before the failure,i got 'ERROR   OGG-00446   C�' fallow with a gibberish string

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy
    edited Jun 15, 2020 10:28AM

    Hey Jim,

    Please open an new thread and also, please share the complete report file with error.

    Regards,

    Veera

  • User_UTH6C
    User_UTH6C Member Posts: 1 Red Ribbon
    edited Sep 15, 2020 11:12AM

    I ran into format error in Golden Gate 19c. I had extract created days before starting it. When started I got the error OGG-02830  Formatting error..

    fix: I updated the GLOBALS file such that it read the correct extract schema. Then I ran - alter extract <extract_name> begin now

    It put the extract to initial sequence. Extract started fine after the fix.

  • User_WYJRK
    User_WYJRK Member Posts: 1 Green Ribbon

    Hi All,

    Got the same issue with those gibberish fonts. Followed the following Oracle support doc and issue got fixed.

    If someone understands why we need to enable TRANLOGOPTIONS DBLOGREADER here, Please do explain the same.

    Capture Process Cannot Be Startup with OGG-02830 or OGG-02829 (Doc ID 2685463.1)


    Regards,

    -Gowtham Babu S R

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    TRANLOGOPTIONS DBLOGREADER

    Whenever the redo or archive logs reside in ASM, we need to use below in earlier version of GG.

    ASMUSER [email protected]_instance, ASMPASSWORD password
    

    This was slow in reading the logs residing in ASM. Later Oracle Introduced a new advanced API with the parameter,

    TRANLOGOPTIONS DBLOGREADER

    Causes Extract to use a newer API that is available as of Oracle 11.2.0.2 and later 11g R2 versions. This API uses the database server to access the redo and archive logs. DBLOGREADER can be used to mine logs on regular disks and raw disks, and can be used instead of connecting directly to an Oracle ASM instance. 


    Regards,

    Veera