Side Bar Is Not Visible Due To Not Suficient Open Cursors In Oracle
症状
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)原因
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.
ソリューション
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;
最終更新日: 2015 年 10 月 7 日
Powered by Confluence and Scroll Viewport.