RE: ORA-00600 & ORA-07445 with 10.2.0.4.0
Date: Wed, 14 May 2008 11:01:09 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A07ABDCD9@VEXBE2.ex.ad3.ucdavis.edu>
Guang,
Thanks for the reply, no, there are no clobs, blobs or lobs in this table.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: Guang Mei [mailto:gmei_at_centive.com]
Sent: Wednesday, May 14, 2008 10:53 AM
To: William Wagman; oracle-l_at_freelists.org
Subject: RE: ORA-00600 & ORA-07445 with 10.2.0.4.0
Does your ORA-07445 error involving inserting into a table with clob column? I saw similar error on 10.2.0.3 (both linux, unix and windows platforms) when insert into a clob column. I think it is a bug.
Guang
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman
Sent: Wednesday, May 14, 2008 1:21 PM
To: oracle-l_at_freelists.org
Subject: ORA-00600 & ORA-07445 with 10.2.0.4.0
Greetings,
I am running Oracle EE 10.2.0.4.0 and using Data Guard (I'm not sure that is relevant) on RHEL 2.6.9-67.ELsmp x86_64. The upgrade to 10.2.0.4.0 was recent but as part of the upgrade migrated to new boxes and Data Guard. Within a couple of days after the upgrade we started seeing the following in the alert log...
Wed May 14 08:20:40 2008
Errors in file
/home/oracle/product/10.2.0/dbms/admin/edrs/udump/edrs_ora_26773.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A9734AB10], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds],
[0x2A97341B80], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10]
[SIGSEGV] [Address not mapped to object] [0x2A97357000] [] []
Searching find several references to this error but nothing which specifically matches our situation and the reports cover other versions of Oracle as well. The error is generated intermittently and the query reported in the trace files is indicating updates to one particular table. I did find bug 7020582 which merely reports a bug after upgrade to 10.2.0.4.0 but it is apparently a bug in other releases and platforms. I have opened an SR and am waiting for a definitive answer. If anyone has any insights or suggestions for dealing with this I would appreciate it.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 14 2008 - 13:01:09 CDT