From djordjej@home.com Wed, 07 Feb 2001 00:39:37 -0800 From: "djordjej" Date: Wed, 07 Feb 2001 00:39:37 -0800 Subject: Re: Re:Alert Log Message-ID: MIME-Version: 1.0 Content-Type: text/plain Dick, Seems you haven't called OTS recently. They come up nowadays with a lot of "interesting" ideas. Djordje ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 06, 2001 5:43 PM > How did OTS come up with the idea that your using Pro*C? This part of the alert > log tells me that there is a problem with a parallel query process namely either > p000 or p001. My first stem would be to look in the trace file(s) specified and > see what SQL statements are being processed. There may be a corrupt block > running around somewhere. Also did you send these files to OTS when you created > the tar? They exist primarily for OTS's purposes. > > Dick Goulet > > ____________________Reply Separator____________________ > Author: Shakeel Qureshi > Date: 2/6/2001 11:00 AM > > Hi gurus! > > I am receiving the following bug in my Alert Log. > Oracle says it may be because of using PRO*C which > we are not using all. > > Please review the contents and if someone has any idea > about it, the input will be appreciated. > > Thu Jan 25 06:56:15 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 06:56:15 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 06:56:37 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 06:56:37 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:05:05 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:05:05 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:06:39 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:06:39 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:06:59 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Thu Jan 25 10:06:59 2001 > Errors in file > /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: > ORA-00600: internal error code, arguments: [KGHALO2], > [0], [], [], [], [], [], [] > Fri Jan 26 04:43:13 2001 > alter database backup controlfile to trace > Fri Jan 26 04:43:13 2001 > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shakeel Qureshi > INET: msklq@yahoo.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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: dgoulet@vicr.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: djordjej INET: djordjej@home.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).