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.
Historical Number
PRI47961
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21549447