My Oracle Support Banner

807 - 12373 - Oracle DB Open_cursors (Doc ID 2844817.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.