- 14 Dec, 2023
- 0 Comments
- 2 Mins Read
ORA-02396: Exceeded Maximum Idle Time, Please Connect Again
PROBLEM: The application is unable to connect to the database after it was idle for a long time.
First, you need to identify, with which user, the application is connecting to the database. Let’s say the user is TESTUSER.
Now find the value of the IDLE_TIME resource limit set in the profile of that user(TESTUSER)
1 2 3 4 5 6 | select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b whereb.resource_name='IDLE_TIME' and a.profile=b.profile and a.username='&USERNAME';USERNAME PROFILE RESOURCE_NAME LIMIT------------- -------------- -------------------------------- --------------TESTUSER DEFAULT IDLE_TIME 125500 |
Here the idle_time is set to 125500 minutes. So if the session is idle for this much time, then it will be disconnected with the error,
Solution : To fix this, alter the profile with the IDLE_TIME set to a higher value or UNLIMITED.
1 2 3 4 5 6 7 8 | ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b whereb.resource_name='IDLE_TIME' and a.profile=b.profile and a.username='&USERNAME';USERNAME PROFILE RESOURCE_NAME LIMIT------------- -------------- -------------------------------- --------------TESTUSER DEFAULT IDLE_TIME UNLIMITED |