RE: How to resolve core dumps from ORA-07445: exception encountered: [audfro()+4976]
Date: Sun, 7 Jun 2020 17:05:36 +0000
Message-ID: <CH2PR02MB666486680E7603056E7E0538D4840_at_CH2PR02MB6664.namprd02.prod.outlook.com>
Charles,
In production where this happens, is the sequence of events that cause the core dumps consistent, in that can predict what will generate this specific core dump? I'm wondering if you can find out a way to avoid the issue causing the core dump. We've had issues in the past where errors like this were generated by application users who, in turns out, where performing operations that weren't necessary so instead of patching/upgrading we were able to stop the behavior.
Regards,
Dave
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Charles Schultz
Sent: Wednesday, June 3, 2020 7:27 AM
CAUTION: This email originated from outside of D&B. Please do not click links or open attachments unless you recognize the sender and know the content is safe.
Good day!
We have been receiving, on average, about 30 core dumps per day in one of our production databases:
ORA-07445: exception encountered: core dump [audfro()+4976] [SIGSEGV] [ADDR:0x49D594984] [PC:0x10C82C930] [Application data integrity
precise] [2]
We have an open SR with Oracle Support for the past 5 months. We _had_ a work around (disable ORA_SECURECONFIG and ORA_LOGON_FAILURES) that put a stop to the core dumps; however, as of the January 2020 RU that workaround no longer works and we are again getting core dumps (even though no audit policies are currently enabled). Due to several factors, we are unable to apply any more recent RU until August. At this point, we do not have enough business justification to roll back the January RU, as the core dumps are not yet impacting business operations (they do fill up the filesystem, which we are currently managing with cron jobs).
We are seeking help and expertise in how to prevent further core dumps. Anyone have any bright ideas?
Bugs found by Oracle Support as being possibly related:
--
To: ORACLE-L <oracle-l_at_freelists.org>
Subject: How to resolve core dumps from ORA-07445: exception encountered: [audfro()+4976]
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 07 2020 - 19:05:36 CEST