用户连接时间超出限制时长(ORA-00604 ORA-02399)

背景

一个入库频繁的应用同时报了 （ORA-00604 + ORA-02399）错误，后续数据再也不能入库。

错误日志

 

ORA-00604: error occurred at recursive SQL level 1
ORA-02399: exceeded maximum connect time, you are being logged off
ORA-02399: exceeded maximum connect time, you are being logged off

 

Oracle官方文档

ORA-00604

ORA-00604 error occurred at recursive SQL level num
Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables.
Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.

ORA-02399

ORA-02399 exceeded maximum connect time, logging off
Cause: A user has exceeded the maximum time allowed to be connected to the database.
Action: The user must reconnect to the database.

分析

不是很能理解ORA-00604的错误，着重看了ORA-02399，大致意思如下：
原因：用户连接数据库时间超出了所允许的最大时长
办法：该用户需要重连数据库
考虑到出问题的应用确实是一刻也不停的操作数据库，而且建立的长连接也未曾释放，很可能超出了Oracle数据库限定的最大连接时长。