My Oracle Support Banner

Getting Error ORA-01000: Maximum Open Cursors Exceeded (Doc ID 2853385.1)

Last updated on MARCH 08, 2022

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting below error:

@0PACKAGE_ERROR@1ORA-01000: maximum open cursors exceeded@2NEW_ITEM_LOC_SQL.PERSIST_ITEM_SUPP_COUNTRY_LOC
Open cursor count is 1000, which in this Non-prod is more than Production value (900).

Checked with Database restart and that didn't help to solve the issue.

The error is occurring on 2 different environments, both are single node instance, Linux boxes, no Exadata.

Changes

Below patches were applied:
33192628;Database PSU 12.1.0.2.211019,Oracle JavaVM Component (OCT2021)
33197468;JDK BUNDLE PATCH 12.1.0.2.211019
19472320;
32758932;OCW PATCH SET UPDATE 12.1.0.2.210720 (32758932)
33114885;Database Bundle Patch : 12.1.0.2.211019 (33114885)

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
Changes
Cause
Solution
References


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