RE: ORA-00600 & ORA-07445 with 10.2.0.4.0

  • From: "William Wagman" <wjwagman@xxxxxxxxxxx>
  • To: "Guang Mei" <gmei@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 14 May 2008 11:01:09 -0700

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@xxxxxxxxxxx
(530) 754-6208

-----Original Message-----
From: Guang Mei [mailto:gmei@xxxxxxxxxxx] 
Sent: Wednesday, May 14, 2008 10:53 AM
To: William Wagman; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
Sent: Wednesday, May 14, 2008 1:21 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
(530) 754-6208

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: