My Oracle Support Banner

Archived - ORA-01000: maximum open cursors exceeded (Doc ID 511877.1)

Last updated on APRIL 18, 2025

Applies to:

Siebel System Software - Version 7.0.4.305 SIS [14190] and later
Oracle Solaris on SPARC (64-bit)
Version: 7.0.4.305 [14190] Com/Med/Engy

Database: Oracle 8.1.7.4

Application Server OS: Sun Solaris 8

Database Server OS: Sun Solaris 8



This document was previously published as Siebel SR 38-1062802101.

Symptoms


Over the last couple of nights some of the batch workflows have been erroring out with errors like this;

PrcExec    BatchErr    1    2003-08-18 07:00:14    Error executing batch process for work item '1-6HZAYT'
PrcExec    BatchErr    1    2003-08-18 07:00:14    Siebel Error Symbol '1: Unknown'. Siebel Error Message '1: An error has occurred preparing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.'.
PrcExec    BatchErr    1    2003-08-18 07:00:14    Siebel Error Symbol '2: Unknown'. Siebel Error Message '2: ORA-01000: maximum open cursors exceeded
'.

Changes

 

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
 Message 1

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