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.