SOLVED

ORA-02396: Exceeded Maximum Idle Time, Please Connect Again

Asked by OracleDba••13 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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)

select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b where

b.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,
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
To fix this, alter the profile with the IDLE_TIME set to a higher value or UNLIMITED.

ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;

select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b where

b.resource_name='IDLE_TIME' and a.profile=b.profile and a.username='&USERNAME';

USERNAME PROFILE RESOURCE_NAME LIMIT

------------- -------------- -------------------------------- --------------

TESTUSER DEFAULT IDLE_TIME UNLIMITED
OracleDba•

Post Your Solution