ORA-01000- Maximum Open Cursors Exceeded Occurs When Multiple POS Clients Are Running (Doc ID 739084.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle Retail Point-of-Service - Version 12.0 and later
Information in this document applies to any platform.
***Checked for relevance on 11-DEC-2013***


Symptoms

When attempting to run more than 20 transactions per register per hour for 5 hours on Oracle Retail Point of Service (ORPOS) ,the following error occurs in the server.log.

ERROR
ORA-01000 ORACLE DB MAX CURSOR ISSUE - MAXIMUM OPEN CURSORS EXCEEDED



Steps To Reproduce:
1. Run 20 transactions per register on 15 registers for 5 hours.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms