11-20-2012 10:28 AM - edited 03-01-2019 08:56 AM
We have an Oracle RAC DB (11.2.0.3) serving as our Tidal Repository. We upgraded to Tidal Version 6.0.3.235 a week ago. We received the max open cursors error. The install doc says to increase to 1000, but we were already at that level. Is the suggestion to just keep increasing until the error stops occuring?
Error: max open cursors exceeded
If you are using Oracle and you get the message
Max open cursors exceeded, you need to increase the open_cursors
value from the default (50) to a value of 1000. Contact your Database Administrator to have this value changed in your database initialization file.
01-04-2013 11:19 AM
I highly recomend contacting support on this one to get an answer and i would be very interested in the response.
02-01-2013 08:21 AM
Max open cursors is a bug CSCue36335. Trying to get more info on it now. But from what we have see the max used is around 50 until some event happens then a couple of sessions in the TES schem a go up to the hundreds with some aparently tryig to get more than 500.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide