Side Bar Is Not Visible Due To Not Suficient Open Cursors In Oracle
Symptoms
The left side bar in Confluence is blank and the following error message appear in Confluence logs:
XXXX-XX-XX 12:44:09,913 ERROR [active-objects-init-system tenant-0] [net.java.ao.sql] handleUpdateError Exception executing SQL update <ALTER TABLE "AO_187CCC_SIDEBAR_LINK" MODIFY ("DEST_PAGE_ID" DEFAULT 0)>
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
....
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)Cause
The current number of cursors in Oracle is not sufficient for the SQL Alter table command as we can see above.
There is a good documentation stating this issue in DBA-Oracle.com.
Resolution
Increase the number of of available cursors in Oracle. In our test, increasing to 1000 available cursors allowed the Alter table to finish successfully.
ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;
Last modified on Oct 7, 2015
Powered by Confluence and Scroll Viewport.