My Oracle Support Banner

E-PRCS: Process Scheduler Open Cursor Buildup Error: ORA-01000: maximum open cursors exceeded (Doc ID 2952638.1)

Last updated on NOVEMBER 17, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Information in this document applies to any platform.

Symptoms

On: 8.60.02, Process Scheduler

Process Scheduler Oracle Open Cursor Buildup

Over time the Process Scheduler builds up open cursors in the Oracle database until the max is reached and the Process Scheduler log shows
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.774] - - - (3) File: /vob/peopletools/src/psschdlr/schedulerrequest.cppSQL error. Stmt #: 1490 Error Position: 0 Return: 1000 - ORA-01000: maximum open cursors exceeded

Open Cursors are left open in PeopleSoft Oracle database from Process Scheduler requests.

Process Scheduler should not run out of Tuxedo Resource allocations to accommodate Process Requests.

Once condition where Max Instances for Process Scheduler requests are reached as in:

PSPRCSRV.14946 (0) [2023-02-15T03:03:02.470] - - - (3) Application Engine : 8:8
PSPRCSRV.14946 (0) [2023-02-15T03:03:02.470] - - - (3) SQR Report : 5:15

Batch Server will no longer process any requests and will error out with

*** PS_StartProc: Error on fork() call - Cannot allocate memory (12)

Error Position: 0 Return: 1000 - ORA-01000: maximum open cursors exceeded

PSPRCSRV.14946 (0) [2023-02-15T08:32:37.816] - - - (1) =================================Error===============================
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.818] - - - (1) Database error encountered
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.818] - - - (2) Info:
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.818] - - - (2) Section:
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.818] - - - (2) Info:
PSPRCSRV.14946 (0) [2023-02-15T08:32:37.818] - - - (2) SQL Stmt: SELECT PARMLIST ,WORKINGDIR ,CMDLINE ,OUTDEST ,ORIGPARMLIST ,PRCSPARMEXTFLAG ,PRCSFILENAME FROM PSPRCSPARMS WHERE PRCSINSTANCE = :1

PSPRCSRV.14946 (0) [2023-02-15T03:03:04.019] - - - (0) *** System Error Code 12
PSPRCSRV.14946 (0) [2023-02-15T03:03:04.019] - - - (0) ***
PSPRCSRV.14946 (0) [2023-02-15T03:03:04.019] - - - (0) *** PS_StartProc: Error on fork() call - Cannot allocate memory (12)

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
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.