Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



VMMSYNC fails with ORA-01000,

From: Hanna, Christopher CTR (2011-09-28 08:27)

Maximo 7118
Oracle 11gr2
WebSphere 6.1.0.37
Setting up the VMMSYNC cron task to synchronize just under 2000 users. The task is failing with ORA-01000, maximum open cursors exceeded error. Although the error is being thrown in the logs, the users do appear to have synchronized (spot checked). We have a PMR open with IBM. IBM suggested upping the open cursors parameter, stepping it all the way to 5000 (yikes). Tried this with no success.
Anybody else experience this issue?
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center
christopher.a.hanna@uscg.mil
(304)433-3234


From: Matt Holland (2011-09-29 20:43)

What is your cursor sharing set at in the database?
On Sep 28, 2011 8:28 AM, "Hanna, Christopher CTR" <
christopher.a.hanna@uscg.mil> wrote:
> Maximo 7118
> Oracle 11gr2
> WebSphere 6.1.0.37
>
> Setting up the VMMSYNC cron task to synchronize just under 2000 users. The
task is failing with ORA-01000, maximum open cursors exceeded error.
Although the error is being thrown in the logs, the users do appear to have
synchronized (spot checked). We have a PMR open with IBM. IBM suggested
upping the open cursors parameter, stepping it all the way to 5000 (yikes).
Tried this with no success.
>
> Anybody else experience this issue?
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center
> christopher.a.hanna@uscg.mil
> (304)433-3234
>
>


From: Gopinath Manickam (2011-10-02 15:39)

Did you configured the prerequisites settings for the Oracle database. There
is a open_cursor configuration in oracle and we need to modify that default
values. It is documented in info center. I got similar kind of problem and
i resolved it my changing the open cursor values.
Regards,
Gopinath Manickam
On Wed, Sep 28, 2011 at 8:27 AM, Hanna, Christopher CTR <
christopher.a.hanna@uscg.mil> wrote:
> **
>
>
> Maximo 7118
> Oracle 11gr2
> WebSphere 6.1.0.37
>
> Setting up the VMMSYNC cron task to synchronize just under 2000 users. The
> task is failing with ORA-01000, maximum open cursors exceeded error.
> Although the error is being thrown in the logs, the users do appear to have
> synchronized (spot checked). We have a PMR open with IBM. IBM suggested
> upping the open cursors parameter, stepping it all the way to 5000 (yikes).
> Tried this with no success.
>
> Anybody else experience this issue?
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center
> christopher.a.hanna@uscg.mil
> (304)433-3234
>
>
>


From: Hanna, Christopher CTR (2011-10-03 07:40)

Update on this issue: Found that upping the open cursors parameter actually requires a re-start, even though Oracle says it's a global setting, and should not. Upping the cursors as a workaround allowed the VMMSYNC cron task to run. PMR with IBM left open because this seems to indicate IBM code not properly closing cursors.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Matt Holland
Sent: Thursday, September 29, 2011 8:44 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] VMMSYNC fails with ORA-01000,

What is your cursor sharing set at in the database?
On Sep 28, 2011 8:28 AM, "Hanna, Christopher CTR" <
christopher.a.hanna@uscg.mil <mailto:christopher.a.hanna%40uscg.mil> > wrote:
> Maximo 7118
> Oracle 11gr2
> WebSphere 6.1.0.37
>
> Setting up the VMMSYNC cron task to synchronize just under 2000 users. The
task is failing with ORA-01000, maximum open cursors exceeded error.
Although the error is being thrown in the logs, the users do appear to have
synchronized (spot checked). We have a PMR open with IBM. IBM suggested
upping the open cursors parameter, stepping it all the way to 5000 (yikes).
Tried this with no success.
>
> Anybody else experience this issue?
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center
> christopher.a.hanna@uscg.mil <mailto:christopher.a.hanna%40uscg.mil>
> (304)433-3234
>
>