RE: ora 600

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Fri, 16 Mar 2001 05:17:42 -0800
Message-ID: <F001.002CED04.20010316050556@fatcity.com>

I looked it up on metaslow and apperantly it will not be fixed until 8.1.7.2.

-----Original Message-----
(Frank)
Sent: Friday, March 16, 2001 5:05 AM
To: Multiple recipients of list ORACLE-L

Kevin,

I have the same problem with 8.1.6 on NT.

It's probably this bug :

Bug No. 1365873
Filed 27-JUL-2000 Updated 25-FEB-2001
Product Oracle Server - Enterprise Edition V7 Product Version 8.1.6.1.2 Platform Generic Platform Version No Data Database Version 8.1.6.1.2 Affects Platforms Generic Priority Severe Loss of Service Status Q/A To Development Base Bug N/A Fixed in Product Version 8.1.7.99

Problem statement:

ORA-600 INTERNAL ERROR CODE [17182] AFTER SETTING CURSOR_SHARING=FORCE
----------------------------------------------------------------------------
----

<SNIP>

.

]] Using cursor_sharing = FALSE could corrupt the CGA heap resulting in ]] Ora-600 [17xxx] errors or core dumps. This has been fixed.
.

Note that this has been fixed in 8.2/9i and so only applies to Oracle8i.

*** 01/12/01 11:47 am ***
*** 02/16/01 12:40 pm ***
*** 02/20/01 10:49 am ***

Backported to 8.1.6.4
.

*** 02/25/01 11:41 am ***
Backported to 8.1.7.2
.

Neither 8.1.6.4 nor 8.1.7.2 is available yet (at least not on Metalink).

Greetings,
Frank

> -----Original Message-----
> From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]
> Sent: donderdag 15 maart 2001 16:51
> To: Multiple recipients of list ORACLE-L
> Subject: ora 600
>
>
> Hi all,
>       Has anyone else experienced an 0ra 600 when using
> cursor_sharing=FORCE
> under Windows NT 4.0 Oracle 8.1.6 and 8.1.7?  I was hoping it
> would have
> been fixed in 8.1.7 but it is not.  The only apperent
> workaround is to alter
> the session, but I don't want to have to do that.
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> kevin_at_dulcian.com
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kuijten, F. (Frank)
  INET: f.kuijten_at_organonteknika.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Fri Mar 16 2001 - 07:17:42 CST