Error - ORA-01000: maximum open cursors exceeded

Error:

We are receiving this error on the Database Target activity

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

 

Cause:

Adeptia connection pool size is larger than the maximum number of cursors configured in the Oracle database.

 

Recommendation:

1) Increase the maximum number of cursors limit in the Oracle Database

2) Enable connection pooling in the Database Info activity that connects to the Oracle database and keep the maximum connection to 5 or below

 

Note: If you enable connection pooling while the error is occurring, you'll need to restart the Adeptia Services to reset the cursor count

 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.