EXTRACT abends with ORA-2396 when idle_time is set for GoldenGate admin user (Doc ID 2242787.1)

Last updated on MARCH 10, 2017

Applies to:

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

Symptoms

When the idle_time is enabled in the profile associated to the GoldenGate admin user, the extract process will amend with an ORA-2396 error when the GoldenGate is
running in RAC.

Customer defined the following parameter in the replicat parameter file:

SQLEXEC "select sysdate from dual" EVERY <n> MINUTES

And the issue still reproduce despite of that.

Changes

 Enable idle_time limit in the profile of the GoldenGate admin user

Cause

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