Resolving Oracle GoldenGate Extract Process Error: OGG-01044 & OGG-01668

Oracle GoldenGate (OGG) is a powerful replication tool that enables real-time data movement and transformation between heterogeneous databases. However, while configuring and running extract processes, users may encounter critical errors that cause process failures. One common issue involves errors OGG-01044 and OGG-01668, which indicate missing or unassigned trail files, leading to extract process termination. This blog post outlines the root causes, troubleshooting steps, and resolutions to help users resolve these errors efficiently.

2024-06-11 17:33:52  INFO    OGG-01971  The previous message, 'INFO OGG-02776', repeated 1 times.

Source Context :
  SourceModule            : [er.extrout]
  SourceID                : [er/extrout.c]
  SourceMethod            : [setInitialPosition]
  SourceLine              : [1548]
  ThreadBacktrace         : [12] elements
                          : [/u01/app/oracle/product/19c/ogg/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/u01/app/oracle/product/19c/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/u01/app/oracle/product/19c/ogg/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition))]
                          : [/u01/app/oracle/product/19c/ogg/extract()]
                          : [/u01/app/oracle/product/19c/ogg/extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::get_extract_chkpts(chkpt_context_t*))]
                          : [/u01/app/oracle/product/19c/ogg/extract()]
                          : [/u01/app/oracle/product/19c/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/u01/app/oracle/product/19c/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                          : [/u01/app/oracle/product/19c/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/u01/app/oracle/product/19c/ogg/extract(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/app/oracle/product/19c/ogg/extract()]

2024-06-11 17:33:52  ERROR   OGG-01044  The trail './dirdat/et' is not assigned to extract 'EXTTEST'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL ./dirdat/et, EXTRACT EXTTEST".

2024-06-11 17:33:52  ERROR   OGG-01668  PROCESS ABENDING.

Root Cause

The errors indicate that the extract process EXTTEST does not have an associated trail file (./dirdat/et) This can happen if:

• The extract parameter file does not specify the correct trail file.
• The trail file has not been added to the extract using GGSCI.
• The trail file path is incorrect

Resolution

Step 1: Verify the Extract Parameter File

Check the extract parameter file to confirm the trail file configuration.

Run the following command in GGSCI:

GGSCI> VIEW PARAMS EXTTEST

Ensure the file includes a correct trail path, such as:

EXTTRAIL ./dirdat/tt
TABLE schema.table_name;

If the trail file path is incorrect, update it in the parameter file.

Step 2: Add the Extract Trail

If the trail is missing, add it using the following GGSCI command:

GGSCI (ggate1 as c##ggadmin@ESTCDB/CDB$ROOT) 29> add exttrail ./dirdat/tt, EXTRACT EXTTEST
EXTTRAIL added.

Step 3: Restart the Extract Process

After making changes, restart the extract process:

GGSCI> STOP EXTTEST
GGSCI> START EXTTEST
GGSCI> INFO EXTTEST

Verify that the extract process is running without errors.

Conclusion

The errors OGG-01044 & OGG-01668 occur when an extract process does not have an assigned trail file. This can be resolved by verifying the extract parameter file and adding the missing trail file in GGSCI. The steps outlined above should restore normal operations for the GoldenGate extract process.