数据库的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版本的升级有关。