My Oracle Support Banner

Restarting GoldenGate Extracts Leads To ORA-04030 (Doc ID 2659169.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 19.1.0.0.4 version, 1 - Oracle DB backend

Restarting GoldenGate extracts leads to ORA-04030

Adding new tables and restarting GoldenGate extracts  leads to ORA-04030 errors in database.
At this point, there was not a lot of memory consumption in the database, there was a lot of free memory on the server.

ERROR
-----------------------
ORA-04030 (QERGH hash-agg,kllcqc:kllcqslt), ORA-04030 (kxs-heap-w,kcbpioqInitClientBuffer), ORA-04030 (koh-kghu sessi,recursive addr reg file), ORA-04030 (kxs-heap-w,kcbpioqInitClientBuffer)




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!

In this Document
Symptoms
Cause
Solution


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