RE: Oracle bug 2316137

On Wed, 2002-12-18 at 11:49, Jamadagni, Rajendra wrote:
> If you have cursor_sharing=force ... can you use cursor_sharing=exact
> and see if the error reproduces? I think (and I could be wrong) that
> this setting will at-least buy you some time.
>

I'll have to try that idea.

> Search for 'kksscl-inf-inl-loop' including bug database, you'll find
> many references. Basically it means the process has gone into an
> infinite loop scanning shared cursors.
>

I can't access the bug database for some reason; I should contact them about that. Something that hasn't come up before.

Glenn

> Have you talked to OWS ... time to call them.
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of
> ESPN Inc.
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -----Original Message-----
> From: Glenn Stauffer [mailto:stauffer_at_swarthmore.edu]
> Sent: Wednesday, December 18, 2002 10:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle bug 2316137
>
>
> We've just started experiencing a problem where a client-server Forms
> 4.5 application hangs and then produces this error:
>
> ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop],
> [1500], [0], [1], [41], [41], [], []
>
> Our database is version 9.2 and we found reference to a bug on
> metalink,
> 2316137, though we can't see the details. We are planning an
> off-hours
> upgrade to 9.2.0.2 which is said to fix this problem; in the meantime,
> we can clear up the condition causing this error by bouncing the
> instance. Then things work for a while until the error starts to
> occur
> again (last time it cleared up for about a week).
>
> Since it is several weeks before I can get the downtime to apply the
> upgrade, I'm wondering if anyone has had experience with this problem
> and whether there is a temporary fix short of updating the Oracle
> software.
>
> Thanks
> --
> Glenn Stauffer <stauffer_at_swarthmore.edu>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glenn Stauffer
> INET: stauffer_at_swarthmore.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Glenn Stauffer <stauffer_at_swarthmore.edu>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Glenn Stauffer
  INET: stauffer_at_swarthmore.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).