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

I got “ORA-02396: Exceeded Maximum Idle Time, Please Connect Again ” error in Oracle.

 

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

 

Details of error are as follows.

SQL> select * from dba_users;

select * from dba_users
*
ERROR at line 1:
ORA-02396: exceeded maximum idle time, please connect again

 

 

Exceeded Maximum Idle Time, Please Connect Again

This ORA-02396 errors are related with the IDLE_TIME resource limit set in the user profile

To solve this error, set the User’s Profile IDLE_TIME to UNLIMITED as follows.

 

ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )