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