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 )