Re: ora-01000: maximum open cursors exceeded

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 6 Aug 2013 11:43:59 -0500
Message-ID: <CAJvnOJY=2jLrKSsdUfw5VScqUaFUtVA3CuqrU+Gm14U=EBF0PA_at_mail.gmail.com>

Did you try to disconnect the user and reconnect? It takes effect immediately at the system level, but the users would have to reconnect for it to take effect.

On Tue, Aug 6, 2013 at 11:41 AM, fmh <fmhabash_at_gmail.com> wrote:

> 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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 06 2013 - 18:43:59 CEST