Posted 11/1/2009 1:36:46 PM
|
|
|
|
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,
|
|
|
|