OGG-08221 Cannot Register Or Unregister EXTRACT EO0000 Because Of The Following SQL Error: OCI Error 2,393 (Doc ID 2216540.1)

Last updated on JANUARY 08, 2017

Applies to:

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

Goal

GGSCI (katrnorai1 as GOLDENGATE@OLINT) 9> REGISTER EXTRACT EO0000, DATABASE

2016-12-20 17:28:52 ERROR OGG-08221 Cannot register or unregister EXTRACT EO0000 because of the following SQL error: OCI Error 2,393.

Cause: An attempt was made to exceed the maximum CPU time for a call, a parse, execute, or fetch, allowed by the CPU_PER_CALL clause of the user profile.
 

Solution

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 hundreds of Community platforms