My Oracle Support Banner

"ORA-12801: error signaled in parallel query" and "ORA-03171: Recovery was terminated during query execution" when Executing ODI Jobs with Parallelism (Doc ID 2398750.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) session executing looped Insert Select statements ends with an error after several hours.

After trying to re-execute the processing multiple times, the error still appears on different steps/loops of processing but always on the same server and instance.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.