Re: ORA-00604, ORA-01000
Date: Tue, 18 Apr 2000 15:57:40 +0200
Message-ID: <956066134.29195.0.pluto.d4ee154e_at_news.demon.nl>
Increase the open_cursors parameter in init<sid>.ora and bounce the database.
Hth,
Sybrand Bakker, Oracle DBA
Andreas Ursprunger <andreas.ursprunger_at_telekom.at> schreef in berichtnieuws
38fc171c$0$80800_at_SSP1NO17.highway.telekom.at...
> Hello !
>
> I have a connection via JDBC to ORACLE 8.0.4 and sometimes I get the
> following error-message:
>
> "ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum
open
> cursors exceeded"
>
>
> What can I do ?
>
> - Should I close my ResultSets immediately after use ? (BTW: I expected my
> ConnectionBroker to do this.)
> - Should I increase the number of connections to the database ? (I'm not
> really sure if this can solve the Problem.)
>
> Do you have a better idea ?
>
> Please, if anybody of you has a solution for that, please let me know. :-)
> Thanks a lot, Andreas
>
>
>
Received on Tue Apr 18 2000 - 15:57:40 CEST