问题描述
数据库的ASM实例碰到ORA-7445[pfrrun_no_tool]。
详细错误信息为:
Thu Sep 6 17:40:51 2007 WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these messages Thu Sep 6 17:40:51 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_15541.trc: ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] Thu Sep 6 17:40:51 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_15541.trc: ORA-07445: exception encountered: core dump [pfrlnitinit()+801] [SIGSEGV] [Address NOT mapped TO object] [0x000001000] [] [] ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these messages Thu Sep 6 17:41:44 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_17005.trc: ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] Thu Sep 6 17:41:44 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_17005.trc: ORA-07445: exception encountered: core dump [pfrlnitinit()+801] [SIGSEGV] [Address NOT mapped TO object] [0x000001000] [] [] ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these messages Thu Sep 6 17:42:59 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_18973.trc: ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] Thu Sep 6 17:42:59 2007 Errors IN file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_18973.trc: ORA-07445: exception encountered: core dump [pfrlnitinit()+801] [SIGSEGV] [Address NOT mapped TO object] [0x000001000] [] [] ORA-07445: exception encountered: core dump [pfrrun_no_tool()+113] [SIGSEGV] [Address NOT mapped TO object] [0x4000000070F898E3] [] [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [], [interpreter cannot interpret pcode], [], [], [], [], [], [] WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these messages
专家解答
这个错误信息和Bug 10322959 – Various ORA-7445s from PL/SQL code run by the job scheduler [ID 10322959.8]描述的比较接近,其中pfrrun_no_tool错误和pfrlnitinit错误在文档中都有体现,且错误发生在PL/SQL代码中也和文档描述的一致。唯一的区别在于这个文档描述的版本是11.1及以上,而当前错误发生在10.2版本上,且是ASM实例。
如果不是Bug 10322959,那么根据错误信息,问题应该与Oracle的可行性文件发生改变有关。在整个告警日志中,Oracle可执行二进制文件不匹配的问题都引发了这两个ORA-7445错误。
也就是说只要避免Oracle executable binary mismatch问题的产生就可以避免这两个错误的产生,而一般来说导致二进制文件改变的因素只有几种,排除人为破坏之外,一般与操作系统上的权限或目录的改变以及Oracle版本的升级有关。
最后修改时间:2019-04-14 11:04:04
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。