ORA-02396 error processing method

xiaoxiao2021-03-06  116

2396 Mar-02396: Exceeded Maximum iDLE Time, please connect again

0INSERT INTO AGENT_TASK (Task_ID, TYPE, CREATED_TIME, RELATION_OBJECT_ID) VALUES (Task_Id.NextVal, 1, Sysdate, 7364794)

If DBA modifies the IDLE_TIME default value in DBA_PROFILE, it will limit the connection.

But sometimes it is very innocent, there are many processes of the process, but don't quit normal, solve

The way is to cancel the limit for a while, then restrict some problems, from Metalink

Investing, this is an 8i BUG, ​​why is there in 9.2.0.4?

SQL> ALTER PROFILE DEFAULT LIMIT IDLE_TIME Unlimited

Waiting for a while

SQL> ALTER PROFILE DEFAULT LIMIT IDLE_TIME 16;

SQL> SELECT * FROM DBA_PROFILES;

SQL> SELECT * FROM DBA_PROFILES;

转载请注明原文地址:https://www.9cbs.com/read-126207.html

New Post(0)