hope someone can help me here.
We use Tridon CMS to manage a website hosted on jBoss and Apache.
We have been using SDL Tridion 5.3 for 5 years, and suddenly we encountered an error with the Oracle database behind it. Most of our content is served as regular jsp pages from the file system, but we have some components that are served by calling the Tridion Java API, which returns an html fragment from the Oracle database.
Recently, we noticed that some of these html fragments were not serviced, and while checking the server log files we found that the Oracle ORA-01000 error: maximum open cursors exceeded. Our maximum cursors were set to 300, so we increased it to 350 to see if this helped, but it is not. Observing the active Oracle sessions, we saw that the number of sessions reached the maximum cursors, so we restarted the application server. It helped, but only temporarily. The number of sessions reaching the threshold of the maximum cursor is gradually increasing. Yesterday afternoon after the reboot, there were about 30 sessions with maximum cursors, this morning 150.
Obviously, something has changed recently to trigger this, but we are not sure what. The Oracle database is not something that we usually have access to, and, of course, we do not make any changes directly - all daily database operations occur through the Tridion API. We did not do anything unusual with regard to the development and publication of Tridion, so there is nothing special about what we have done over the past few years. The volume of traffic to our site is relatively low at the moment (and was significantly higher in the past), so we are sure that there is no problem.
, , - , , , , .
- , ? SDL, , .
.