IBM Support

Oracle Error : ORA-01000 : Maximum Open Cursors Exceeded

Troubleshooting


Problem

Oracle Error : ORA-01000 : Maximum Open Cursors Exceeded

Symptom

Oracle Error : ORA-01000 : Maximum Open Cursors Exceeded
PART: DCS 6.1 SP1    DCS
OS: Sun OS - 5.5.1
DATABASE: Oracle - 8.1.6

Cause

Resolving The Problem

There is a parameter that is set in init.ora for each instance to specify the value for Max Open Cursors.

Check <ORACLE_SID>init.ora in $ORACLE_HOME/dbs DIR.

Parameter Name: open_cursors=XXX
"Indicates the maximum number of open cursors (context areas) a single-user process can have at once."

This value should be set to at least 2000 (and perhaps higher), depending on transaction volume expected.

These settings should be ideally checked and maintained by DBAs.

The Oracle Instance needs to be restarted for the settings to be effective.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI47961

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21549447

Page Feedback