WARNING: Oracle executable binary mismatch detected.
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



WARNING: Oracle executable binary mismatch... Expand / Collapse
Message
Posted 11/1/2009 1:36:46 PM Post #165
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
The OS admin applied OS Patch and after the reboot, the db came up fine but there were tons of messages in alert log:

Sun Nov  1 10:02:22 2009
Completed: ALTER DATABASE OPEN
Sun Nov  1 10:10:01 2009
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.
 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.
 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.
 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.
 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.
 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.
 Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages
Sun Nov  1 10:26:26 2009

Couldn't find much on the internet other then to open up tar with oracle.  In metalink couldn't find much info, then one of my co-workers mentioned that this is a known thing on hp servers.  Not sure why this does it the way it does.

Here is the info on the system:

HP-UX hpdnp290 B.11.11 U 9000/800 3154283422 unlimited-user license
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

I had to shutdown the database and issue relink all command to fix this issue.

So basically follow these steps:

1. Shutdown immediate

2. Stop listener

3.  relink all

4. start db

5. start listener.

Hope this helps you out.

Thanks,

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:28am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.064. 7 queries. Compression Disabled.