Oracle Waveset / Siebel Connector (1.0.1) / "ORA-01000: maximum open cursors exceeded"
Last updated on OCTOBER 14, 2016
Applies to:Oracle Waveset - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Sep-2014***
The purpose of this knowledge document is to explain a known defect that exists in the Siebel Connector that ships with Oracle Waveset 188.8.131.52 (and later 8.1.1.x releases).
The Siebel Connector will be reported as the following in your lh assessment output:
For the record, this same Siebel Connector is also used with the Oracle Identity Manager (OIM) provisioning product and it's also affected by the same known defect.
The Siebel Connector in both OW and OIM is known as an ICF Connector, which means it's using the common Identity Connector Framework (ICF).
The known defect is documented as:
Bug 13705530: SIEBEL CONNECTOR: ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED
The problem/exception is usually seen when running reconciliation.
The specific error is:
ORA-01000: maximum open cursors exceeded
The full exception looks like this:
org.identityconnectors.framework.common.exceptions.ConnectorException: 2567733356An error has occurred preparing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108)Unknown 7733356 An error has occurred preparing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108) 7733355 ORA-01000: maximum open cursors exceeded
Below I've included the existing patch that resolves this known defect along with its installation instructions that pertain specifically to Oracle Waveset.
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