Wednesday, October 6, 2021

 

ORA-02396: exceeded maximum idle time, please connect again.


Resolution
To resolve the above error there are three approaches:

1.Set the idle time to unlimited on the Oracle database. 
alter profile <profile_name> limit idle_time UNLIMITED;

before





























After 



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...

  • (no title)
    DBCA Fails To Create Oracle 19c Database On AIX [DBT-05509] (Doc ID 2663388.1 ) In this Document ...
  • (no title)
      How to set FILESYSTEMIO_OPTIONS for use with RSA Identity Governance and Lifecycle on a remote Oracle database where Automatic Storage Man...
  • (no title)
    Oracle auditing setup & configuration The Oracle audit command is used to to create specific audit trails for Oracle tables.  to ena...