Return
-
Title
"ORA-02396: exceeded maximum idle time, please connect again" messages in Oracle agent log files -
Description
The message "ORA-02396: exceeded maximum idle time, please connect again" can be found in Oracle agent log files when collections are interrupted.
-
Cause
The idle_time parameter is used in a SQL*Plus profile.
Oracle has multiple ways to disconnect idle sessions, both from within SQL*Plus via the SQL*net expire time parameter and in the resources profiles (connect_time, idle_time).
-
Resolution
Check the idle_time on the server for the profilesselect * from DBA_PROFILES where resource_name='IDLE_TIMEUsers can use profiles to adjust the connect time and idle time with "alter profile" statements. Note that idle_time is expressed in minutes -
Additional Information
Increasing the DB Connection Timeout in milliseconds in the Agent Status Properties and the Collection Timeout values in the Agent administration may also provide some benefits.