Re: ora-07445

Do you have partitioned tables?

There are bugs in Oracle 8 and 8i which Oracle promises are fixed in 8.1.7 with respect to partitioned tables and statistics. Apparantly a cluster of bugs.

I've encountered this error every now and then on 8.0.5 and 8.1.6. I opened up a TAR, Oracle gave me one bug number which does show up in the 8.1.7 release notes as fixed.

Of course this error could be from other things as well. ----- Original Message -----
From: Shailesh Kumar <shailesh_kumar_at_indiainfo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, October 16, 2000 6:35 AM
Subject: Re: ora-07445

> Hi,
>
> May be some of your database user's objects became invalid. Confirm The No.
> of valid objects match to the previous state. and if everything is normal
> if U find, than contact Oracle support.
>
> Bye,
>
>
> At 07:51 PM 10/15/00 -0800, you wrote:
>
> >Below was found in the alertsid.log file.
> >ORA-07445: [SIGSEGV] [Address not mapped to object] [152905884] [] [] []
> >
> >platform: UnixWare7.1 and ORACLE8.0.4.4
> >
> >The server is still running and the applications seems not affected. But I
> >still worry about it.
> >Any one can tell me why this happend and how I correct it.
> >
> >Thanx in advance.
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: cyhu_at_eachnet.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).
>
> Shailesh Kumar
> DBA Oracle,
> shailesh_kumar_at_indiainfo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shailesh Kumar
> INET: shailesh_kumar_at_indiainfo.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 Oct 17 2000 - 16:25:45 CDT