From kevin@dulcian.com Fri, 16 Mar 2001 05:17:42 -0800 From: "Kevin Kostyszyn" Date: Fri, 16 Mar 2001 05:17:42 -0800 Subject: RE: ora 600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 ---------------------------------------------------------------------------- ---- . ]] 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@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@dulcian.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuijten, F. (Frank) INET: f.kuijten@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@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@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@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).