Warning: Oracle Executable Binary Mismatch Detected

Warning: Oracle Executable Binary Mismatch Detected

 

--------------------------

 

alert日志报Warning: Oracle Executable Binary Mismatch Detected
让设置隐含参数"_disable_image_check" = TRUE

 

查了下文档说如果对oracle二进制可执行文件进行了copy操作，或者改了参数或者打patch的话可能引起这个问题
出现问题的环境是一组rac，安装之后进行了升级
对于rac，第一个节点是正常的安装，第二个节点都是通过copy复制过去的
而且装完了还要升级，也是基本类似的操作
按照官方的解释，出现这种问题还是能解释的

 

处理方法：
重启数据库
或者设置隐含参数"_disable_image_check" = TRUE屏蔽alert中的warning
我觉得不理他其实也可以
或者允许停库的情况下重新relink下oracle软件

 

官方的解释在下面

------------------------------

 

Warning: Oracle Executable Binary Mismatch Detected [ID 369260.1]

--------------------------------------------------------------------------------
 
  修改时间 27-APR-2010     类型 PROBLEM     状态 MODERATED  

In this Document
  Symptoms
  Cause
  Solution

 

--------------------------------------------------------------------------------

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

 

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Alert log file has been getting a lot of messages regarding a mismatch detected on Oracle executable.
Thu May 4 09:00:15 2006
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
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
WARNING: Oracle executable binary mismatch detected. It is only a WARNING; an informational message. If your database is working and
you want to suppress the messages you can alter the system as mentioned above
to suppress the message.

_disable_image_check = TRUE

As documented above this will only suppress the messages until the next restart
of the instance. After that the message won't recur until the next time there a
change
in the binary is detected when the database is active.

Cause
These messages could start arising if you copied the binary from backup or re-ran make command, perhaps as part of a parameter change or patch.
There are many potential scenarios to get this message but they all drill down to there being a different version of the Oracle binary being used than that of the oracle executable that started the database.

Solution
It is only a WARNING; an informational message. If your database is working andyou want to suppress the messages you can alter the system as mentioned aboveto suppress the message.
   
alter system set "_disable_image_check" = TRUE
 
As documented above this will only suppress the messages until the next restartof the instance. After that the message won't recur until the next time there achange in the binary is detected when the database is active.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13177610/viewspace-691941/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13177610/viewspace-691941/