From dgoulet@vicr.com Tue, 06 Feb 2001 16:39:26 -0800 From: dgoulet@vicr.com Date: Tue, 06 Feb 2001 16:39:26 -0800 Subject: Re:Alert Log Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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).