RE: ORA-00600 & ORA-07445 with 10.2.0.4.0

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 14 May 2008 13:16:14 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A07ABDDD3@VEXBE2.ex.ad3.ucdavis.edu>


Finn,

We did make several changes. Character set = WE8IS08859P1, National Character set = AL16UTF16. The interesting thing is that searching Metalink for kgh_heap_sizes returns several reports of the error for various versions and platforms which doesn't help. We are in the process of performing the tests support has requested.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Finn Jorgensen Sent: Wednesday, May 14, 2008 12:59 PM
To: William Wagman
Cc: oracle-l_at_freelists.org
Subject: Re: ORA-00600 & ORA-07445 with 10.2.0.4.0

Bill,

Please keep us posted on this as I will soon be going live on 10.2.0.4 on the same platform, also using dataguard.

Did you have this error in prior versions of Oracle? It sounds like you guys made quite a few changes all at the same time, so you may not know. What char set are you on?

Thanks,
Finn

On 5/14/08, William Wagman <wjwagman_at_ucdavis.edu> wrote:
> 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-l


--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 14 2008 - 15:16:14 CDT

Original text of this message