Skip to main content
Contact a Moderator

Discussion

1
Replies
94
Views
 Nandhini Nataraj (natan)
PEGA
Principal Software Engineer - Customer Success
Pegasystems Inc.
natan Member since 2012 32 posts
PEGA
Posted: June 4, 2015
Last activity: April 6, 2018
Posted: 4 Jun 2015 9:27 EDT
Last activity: 6 Apr 2018 19:26 EDT
Closed

How to overcome ORA-0100 error during data upgrade DDL generation?

I got "ORA-0100: Maximum Open cursors exceeded" during the DDL generation of data upgrade. How can I get rid of this error?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 5 Jun 2015 2:05 EDT
Murali Krishnan Divakaran (divam)
PEGA
Associate Architect, Cloud Engineering
Pegasystems Inc.
IN

This is a DB error caused due to exceeded Maximum Open Cursors.


Increase Open_Cursors Value from 1000 to ~6000 to resolve the issue.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice