alter日志出现ORA-6544[pevm_peruws_callback-1][604] is caused (Doc ID 2638095.1)

jiawang

问题现象：
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)