Re:Alert Log

From: <dgoulet_at_vicr.com>
Date: Tue, 06 Feb 2001 16:39:26 -0800
Message-ID: <F001.002ACF2A.20010206144330@fatcity.com>

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 <msklq_at_yahoo.com>
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_at_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_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: 
  INET: dgoulet_at_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_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 Tue Feb 06 2001 - 18:39:26 CST