807 - 12373 - Oracle DB Open_cursors
(Doc ID 2844817.1)
Last updated on JUNE 10, 2024
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
On : 8.0.7 version, Web UI
ACTUAL BEHAVIOR
---------------
807 - 12373 - Oracle DB open_cursors
In production database FCCM we had the following error:
(/ofsaa/ofsaai/bdf/logs/20211230/ AlertAssignment.log)
2022-01-01 19:36:23,802 [main] DEBUG: 10200AlertAssignment - Message 10200: UPDATE ofsaafccm.kdd_activity SET new_review_owner_id = 10152 WHERE review_id = 10200453
2022-01-01 19:36:23,835 [main] ERROR: 10019AlertAssignment - Message 10019: Unexpected Exception: com.ofss.bdf.common.RethrownException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "OFSAAFCCM.AAI_DATASECURITY", line 32
ORA-06512: at line 1
2022-01-01 19:36:23,838 [main] ERROR: 10200AlertAssignment - Message 10200: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "OFSAAFCCM.AAI_DATASECURITY", line 32
ORA-06512: at line 1
The Database team of NBG increase temporarily the parameter from 4100 to 5000 to provide a quick fix to the error:
NAME TYPE VALUE
------------ ---------- ----------
open_cursors integer 5000
This number is very high and we need to find a solution in order to restore the value in the previous one (4100).
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |