dbi services Blog
Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Take care while upgrading your Oracle DB with "DBUA"
Last week at a customer, I used DBUA to upgrade an Oracle database from 10g to 11g and the migration ran successfully. However, the day after I got a monitoring message that the diag directory is growing very rapidly.
I began checking why the diagnostic directory was growing so fast. And I found out that all 11g databases - the new one and all the other ones - reported the message below each second in the database alert.log file.
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
This problem occured because during the database upgrade procedure, DBUA recompiles the Oracle binary executable. Thus all databases using this Oracle executable file send WARNINGS that the executable was recompiled.
oracle@chbsslcmdbdb1:~/app/oracle/product/220.127.116.11/bin/ [DBACT411] ls -lrt
-rwxr-xr-x 1 oracle dba 3771 Oct 28 2010 emagentdeploy.pl
-rwxr-xr-x 1 oracle dba 6299 Oct 28 2010 dbca
-rwxr-xr-x 1 oracle dba 3552 Oct 28 2010 db2gc
-rwsr-s--x 1 oracle dba 228886356 Jun 9 09:59 oracle
How to fix this problem
A restart from all affected database must be done.
When you upgrade an 11g database on a server where you still have a 11g database running that you can not restart: Install a new ORACLE_HOME and this problem will only affect your new database which can be fixed with a simple restart of the database.