背景
一个入库频繁的应用同时报了 (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 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 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,大致意思如下:
原因:用户连接数据库时间超出了所允许的最大时长
办法:该用户需要重连数据库
考虑到出问题的应用确实是一刻也不停的操作数据库,而且建立的