Re: ORA-02396

The error you encountered mostly occur when the profiles are used and assigned to the Oracle user who got the error message. Oracle allows use of profiles to contain or restrict a user on Oracle Resources. Through the use of profile you can set a limit on IDLE_TIME, if the user remains idle for more the maximum allowed in the profile, the the user session is killed automatically by Oracle.

So, check the profile to which this user is associated and then check the IDLE_TIME limit. Then you can alter the profile/ or remove the user from this profile and associate it to a new profile or assign this user to DEFAULT profile which has unlimited resources and unlimited IDLE_TIME.

Oracle Errors ORA-02376 to ORA–02399: Oracle Resources

ORA–02396 exceeded max 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.

Hope this helps,

Manoj Jain
Oracle Certified Professional - DBA
Chauncey Certified Oracle - DBA

In article <35C75AE5.41C67EA6_at_ornl.gov>,   D S Tharpe <i5t_at_ornl.gov> wrote:
> ERROR: Oracle COMMIT Error: ORA-02396: Unable to open message file
> (SQL-02113).
>
> ORA-02396: exceeded maximum idle time, please connect again
>
> This ORACLE error is occurring in SQL embedded in a SAS program.
> (SUN OS/UNIX environment)
>
> If a user's idle and connect time are set to unlimited, why would they
> get this message? 100,000 rows were being updated, and the message prior
> to this message is '100000 rows were updated'. What other reasons would
> cause this to occur?
>
> Any help appreciated,
>
> D. Tharpe (i5t_at_ornl.gov)
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 20:29:18 CDT