ORA-02396 - exceeded maximum idle time

[cdev]

Hi

I use a 8.1.7 Oracle Database which have set the idle time parameter to 60 (1 hour) in the application user's profile.

When a user stay connected for up to an hour, i get the ORA-02396 Error (exceeded maximum idle time, please connect again) . That's normal but what to do exactly now to reconnect the session?

I tried this :

MainSession.Connected := false;
   MainSession.LogOn;

But I often get the ORA-01012 error (not logged on).

Thanks for your help.

CdeV

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

For reference :
Here is what says the official Oracle documentation :

• ORA-02396 exceeded maximum idle time, please connect again
  Cause: A user has exceeded the maximum time allowed to remain idle.
  Action: The user must reconnect to the database.
• ORA-01012 not logged on
  Cause: A host language program issued an Oracle call, other than OLON or OLOGON, without being logged on to Oracle. This can occur when a user process attempts to access the database after the instance it is connected to terminates, forcing the process to disconnect.
  Action: Log on to Oracle, by calling OLON or OLOGON, before issuing any Oracle calls. When the instance has been restarted, retry the action.

 

[Uli Kobsa]

Have you tried it with MainSession.CheckConnection(true)?

Uli

 

[cdev]

Yes Uli, I have tried CheckConnection(true) whitout success.

I have to make some tests again but the problem seems to be basicly in multi-threaded multi-sessions usage. May I have to checkconnection on all of these. I will look at that tomorrow.

CdeV