0

ORA-07445 [SIGSEGV]

Bethune 2016-02-23
532
When trying to insert, update, or delete on a table that has at least one trigger on it, that results in ORA-07445 in alert log: ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] There can be various types of call stacks in Call Stack Trace from the trace file. You can find the functions below in the call stack: kglsim_pin_simhp kxsGetRuntimeLock kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxtexe kxtex1 rpiswu2 kxtexe delrow qerdlFetch delexe opiexe kpoal8 OR kglpnp kxtplt1 kxtlpt kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxtexe kxtex1 rpiswu2 kxtexe delrow qerdlFetch delexe OR kgskgactive ktuchg ktbchg2 kddchg kdddrp kdddel kaudel delrow qerdlFetch delexe opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 CHANGES The error only happens on Sun Operating System x86-64 bit 5.10 and Oracle version 10.2.0.2 or 10.2.0.3. CAUSE This is caused by an OS compiler issue with Sun 5.10, investigated in Sun's unpublished bug 6499691. It is identified by following Oracle bugs that are closed as a Vendor OS Problem: Bug 6620357 Abstract: ORA-7445 [SIGSEGV] WHEN UPGRADING Attempt to insert/update table results in ORA-07445. Bug 5666714 Abstract: ORA-7445 ON DELETE Attempt to delete table results in ORA-07445 Bug 6499995 ORA-07445: [SIGSEGV] ERROR DELETING ROWS FROM A TABLE SOLUTION The possible solutions are: This OS compiler issue is fixed in Oracle release 10.2.0.4.0. Please see Sun incident 6499691. The problem is with the Compile optimization options.Until the official Sun patch is out, Sun recommends as a workaround to use options "-Wd,-noiropt" in compile line which will disable all optimizations. Oracle Sun confirmed that the fix is included in Sun Studio 11 or higher versions. If you are
「喜欢文章,快来给作者赞赏墨值吧」
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部