GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again, ogg00868

GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again, ogg00868

GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again

Reference Original:
GoldenGate Processes Abend with OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again (Doc ID 1393647.1)

Applicable:
Oracle GoldenGate-Version: 11.1.1.0.0 to 11.1.1.1.20-Release: 11.1.1 to 11.1.1.1
Information in this document applies to any platform.

Symptoms:
Oracle GoldenGate (OGG) process abend, the error is:

Extract (or replicat) Process
ERROR OGG-00868 ORA-02396: exceeded maximum idle time, please connect again.

Manager Process
ERROR OGG-00665 OCI Error describe for query (bad syntax) (status = 2396-ORA-02396: exceeded maximum idle time, please connect again ), SQL <SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'x' FROM GGS_OWNER.GGS_MARKER WHERE OPTIME <'... ')>.
ERROR OGG-01668 process abending.

Cause:
This problem occurs when the user connection times out. Check whether the user has set time out.

Solution:
SQL> select USERNAME, USER_ID, ACCOUNT_STATUS, PROFILE from dba_users where USERNAME = 'ggs _ owner ';
Check which profile is used, and then check the idle timeout of gg user:

SQL> select * from dba_profiles where resource_name = 'idle _ time ';

If the query result contains a profile used by gg user, check whether the profile is restricted or set to UNLIMITED.

If UNLIMITED is not available, increase the time out to a proper value.