On Aug 15, 3:59 am, gazzag <gar..._at_jamms.org> wrote:
> On 14 Aug, 19:44, nitesh <oracledba.nit..._at_gmail.com> wrote:
>
>
>
>
>
> > hi,
>
> > I have recently ugraded oracle 9.2.0.6 to 9.2.0.8 on HP-UX. I am
> > getting the following errors:
>
> > ORA-00604: error occurred at recursive SQL level 1
>
> > ORA-00018: maximum number of sessions exceeded
>
> > so i have increased the parameter values accordingly. It is going on
> > fine now.
>
> > Now, my question is: Is it related to the oracle patch.?
>
> > Main concern is that the application usuage is still the same as it
> > used to be when it was on 9.2.0.6 but now ended up with this error.
>
> What are you doing when you get the errors? What parameters exactly
> have you increased and how?- Hide quoted text -
>
> - Show quoted text -
well, i have increased the sessions and processes parameter in the
pfile and bounced the database. It is going fine now. Please tell me
if it is due to patch .
Received on Wed Aug 15 2007 - 07:55:58 CDT
