ora-01000: maximum open cursors exceeded
- From: fmh <fmhabash@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 6 Aug 2013 12:41:03 -0400
Straight forward error & resolution. In attempting to increase this
parameter using 'alter system set ... scope=memory;', it worked
successfully. 'show parameter' shows the new value. However, the
application continues to fail and we can see it is hitting the old value as
it shows in v$open_cursors & v$sesstat.
Rebooting the instance resolve it as the new values takes effect.
At least according to the official doc, this parameter is 'ISSYSMODIFIED'
with a value of 'IMMEDIATE'. Rebooting the instance is not needed, but it
does not appear to behave this way?
Have you come across this issue?
--
----------------------------------------
Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
