Home

Unreleasing the ECO giving Error

we are getting exception when we are trying to Unrelease the ECO. Below is the Exception material:
ORA-01000: maximum open cursors exceeded
ORA-06508: PL/SQL: could not find program unit being called: “PUBLIC.DBMS_OUTPUT”
ORA-06512: at “AGILE.PAGE_TWO_T”, line 35
ORA-01000: maximum open cursors exceeded

How do we fix this issue? we have tried restarting the server but that did not work.

Any help appreciated . thank you.

Agile User Asked on September 6, 2016 in Agile PLM (v9),   Product Collaboration.

Antonio

This is very bad: ORA-01000: maximum open cursors exceeded

 

Do you have any custom store procedure in your Agile schema?

on September 6, 2016.
Cancel

varunh

There arent any Custom procedure on the schema.

on October 18, 2016.
Cancel
Add Comment
Cancel
1 Answer(s)

Hi Varun,

Did you try to bounce the Server and did it resolve afterwards. We did the same in similar situation. What count do you see in V$OPEN_CURSOR table. 

You can increase the threshold limit on the nodes. In our case there was a parameter called “INST_ID” that we increased. 

Regards,
Arif

Cancel
Agile Angel Answered on September 21, 2016.

varunh

Bounce back did not help. we altered the open cursors size to a higher value which resolved the issue.

ALTER SYSTEM SET open_cursors = <set a number> SCOPE=BOTH;

on October 18, 2016.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.