Re: ORA-01000 + DESIGNER 2000
From: J. de Hooge <jdh_at_euronet.nl>
Date: 1996/07/26
Message-ID: <4tac6l$be_at_news.euro.net>#1/1
> Get the following error messages from the Application Design Wizard :
>
> Inserting candidate modules......
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> DESIGNER/2000 location(10104)
> DESIGNER/2000 location(10104)
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> NOLONG
> NOLONG
> DESIGNER/2000 location(10019)
>
> Is ther a parameter in the DB that can be modified(add more cursors?) to
> solve this problem?
>
> TIA
>
> djjr_at_ix.netcom.com
Date: 1996/07/26
Message-ID: <4tac6l$be_at_news.euro.net>#1/1
CDJ <djjr_at_ix.netcom.com> wrote:
>
> Get the following error messages from the Application Design Wizard :
>
> Inserting candidate modules......
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> DESIGNER/2000 location(10104)
> DESIGNER/2000 location(10104)
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> NOLONG
> NOLONG
> DESIGNER/2000 location(10019)
>
> Is ther a parameter in the DB that can be modified(add more cursors?) to
> solve this problem?
>
> TIA
>
> djjr_at_ix.netcom.com
The installation guide recommends 200 open curors. This value can be set in your INIT.ora file:
open_cursors = 200. If this is not enough, try a higher value
Good luck,
Toine van Beckhoven,
Dedicate Information Technology Services
Woerden , The Netherlands
A.A.M.v.Beckhoven_at_inter.nl.net
Received on Fri Jul 26 1996 - 00:00:00 CEST