ora-01000: maximum open cursors exceeded
From: fmh <fmhabash_at_gmail.com>
Date: Tue, 6 Aug 2013 12:41:03 -0400
Message-ID: <CADpeV5y1i7BcyRL_WdHspu44oozvQU=C17n5cMfKR5qsq8n2gQ_at_mail.gmail.com>
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?
Thank you.
Date: Tue, 6 Aug 2013 12:41:03 -0400
Message-ID: <CADpeV5y1i7BcyRL_WdHspu44oozvQU=C17n5cMfKR5qsq8n2gQ_at_mail.gmail.com>
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 06 2013 - 18:41:03 CEST