8.1.2 OIDF Install Fails With 'ORA-01000: maximum open cursors exceeded' Error (Doc ID 2960560.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

When installing Oracle Insurance Data Foundation (OIDF) 8.1.2, you get the following error in OFS_OIDF_installation.log:

[04-05-23 15:26:58,298 EST PM] [INFO ] ---------------- DB Scripts Execution Started-----------------
[04-05-23 15:26:58,298 EST PM] [INFO ] Installation stage : POST-INSTALL
[04-05-23 15:26:58,795 EST PM] [INFO ] Loading sequences from :/u01/ofsaa/local/ofsaa8/installerScripts/OFS_OIDF/scripts/fsapps_post_scripts_upgrade_pack.xml
[04-05-23 15:27:00,588 EST PM] [ERROR] =====Exception====
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc8.jar:19.3.0.0.0]
     .
     .
     .
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

The same error repeats multiple times in the log.

As a result, the OIDF install fails.

Cause

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