RE: ORA-07445

From: Lord David <dlord_at_haysits.co.uk>
Date: Tue, 01 May 2001 00:54:04 -0700
Message-ID: <F001.002F6158.20010501002557@fatcity.com>

We had (and still have) a similar problem - ORA7445's & ORA00600's. Do you have any invalid objects (pl/sql procedures/functions/packages or possibly views)? If so, recompile them.

After a lot of head-scratching by us and OWS we tied it down to a problem with 'on-the-fly' recompilation of invalid objects. When a session uses an invalid object, it is recompiled on-the-fly and if successful, the session *should* then continue as normal. However, in 8.1.6, the object is compiled, but the session then dies with ORA-03113: end-of-file on communication channel and the above errors appear in the alert log. We also suspect that it can cause pmon to crash occasionally.

Its now a bug (1520530) and is fixed in 8.1.7.99 apparently (not that that will be of any use to you, as it isn't out yet).

HTH
David Lord

-----Original Message-----
Sent: 30 April 2001 16:31
To: Multiple recipients of list ORACLE-L

Hello All

This message is appearing in the alert log periodically.. anyone know hat it means and how I can get rid of it

ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] []

Thanks

--

Sajid Iqbal
Database Team Leader

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sajid Iqbal
INET: siqbal_at_vianetworks.co.uk

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).

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lord David
INET: dlord_at_haysits.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------