标题: alter日志出现ORA-6544[pevm_peruws_callback-1][604] is caused (Doc ID 2638095.1) [打印本页] 作者: jiawang 时间: 2023-10-24 15:05 标题: alter日志出现ORA-6544[pevm_peruws_callback-1][604] is caused (Doc ID 2638095.1) 问题现象：
2023-09-22T09:25:41.785614+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_1864419.trc (incident=2360061):
ORA-6544 [pevm_peruws_callback-1] [604] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_2360061/orcl1_ora_1864419_i2360061.trc
Applies to: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform. SymptomsORA-6544[pevm_peruws_callback-1][604] has been logged into alert.log file.
ex)
ORA-6544 [pevm_peruws_callback-1] [604] [] [] [] [] [] [] [] [] [] []
From an incident file, ORA-604 is logged with ORA-1000 in "error stack dump with barriers" section.
------------------- start error stack dump with barriers
<error barrier> at 0x7fff1d643d70
<error barrier> at 0x7fff1d6444a0
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
------------------- end error stack dump with barriers
CauseAfter reached open_cursors max limit it is through the ORA-6544 error. SolutionPlease increase open_cursors=<higher> and monitor the database. Also, please restart the database after increased open_cursors.
Please use below documents:
=====================================
Monitoring Open Cursors & Troubleshooting ORA-1000 Errors (Doc ID 76684.1)
Overview of ORA-1000 Maximum Number of Cursors Exceeded (Doc ID 1012266.6)