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.
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.
Below patches were applied:
33192628;Database PSU 126.96.36.199.211019,Oracle JavaVM Component (OCT2021)
33197468;JDK BUNDLE PATCH 188.8.131.52.211019
32758932;OCW PATCH SET UPDATE 184.108.40.206.210720 (32758932)
33114885;Database Bundle Patch : 220.127.116.11.211019 (33114885)
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