ora-604错误

jiaosongs

今天看日志时发现有这个错误,不知道什么原因引起的。
请教大佬，如何解决

ZALBB

1  alter system set events '604 trace name errorstack level 3';
2  然后打开警告日志，看看日志里有哪些信息，与这 604 错误相关，有无跟踪文件产生？

jiaosongs

ZALBB 发表于 2021-1-6 11:13
1  alter system set events '604 trace name errorstack level 3';2  然后打开警告日志，看看日志里有哪些 ...

没有跟踪日志 有就好办了， 我先修改下试试.看能输出什么信息

ZALBB

jiaosongs 发表于 2021-1-6 11:16
没有跟踪日志 有就好办了， 我先修改下试试.看能输出什么信息

执行该命令后，再到警告日志里找，

jiaosongs

ZALBB 发表于 2021-1-6 11:27
执行该命令后，再到警告日志里找，

经过一段时间后
Errors in file /u01/app/oracle/diag/rdbms/jljcqzdb/jljcqzdb1/trace/jljcqzdb1_ora_27708.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Wed Jan 06 11:48:57 2021
Errors in file /u01/app/oracle/diag/rdbms/jljcqzdb/jljcqzdb1/trace/jljcqzdb1_ora_26797.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Wed Jan 06 11:48:57 2021
Errors in file /u01/app/oracle/diag/rdbms/jljcqzdb/jljcqzdb1/trace/jljcqzdb1_ora_27109.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Wed Jan 06 11:48:57 2021
Errors in file /u01/app/oracle/diag/rdbms/jljcqzdb/jljcqzdb1/trace/jljcqzdb1_ora_27413.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
opidcl aborting process unknown ospid (27109) as a result of ORA-604

报这个错误，已经找到原因了谢谢.

lfree

$  oerr ora 604
00604, 00000, "error occurred at recursive SQL level %s"
// *Cause:  An error occurred while processing a recursive SQL statement
//         (a statement applying to internal dictionary tables).
// *Action: If the situation described in the next error on the stack
//         can be corrected, do so; otherwise contact Oracle Support

有点奇怪，为什么不报ora－01000错误。

jiaosongs

lfree 发表于 2021-1-6 15:29
$  oerr ora 60400604, 00000, "error occurred at recursive SQL level %s"// *Cause:  An error occurred ...

版本问题吧,有的说是604错误也可能是bug引起的