dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (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"

Thursday, 11 August 2011 Posted by Hervé Schweitzer Category Database Administration & Monitoring 0 comment

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.

tmp

Analysis

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/11.2.0.2/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.

My recommendation

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.

Tags: Oracle 11g, Oracle 10g to 8i, DBA, dbua, Migration

How to handle mutex issues after migrating to Oracle 11.1 You have recently migrated to Oracle Database 11g Release 1 (11.1) and have had some issues with so called "mutexes"? Don't worry, these nasty sound...
Getting rid of network acces issues after migrating to Oracle 11.2 Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you have to make sure the concerned PL/S...
Oracle Basics (2) - Data Storage What is finally the primary objective of a database? Storing Data The question is, how Oracle makes it. For many beginners, a confusing topic is to ...
LOB : « enq : HW contention » Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage. Nous rencontrons parfois...
How to avoid strange figures in the Oracle optimizer system statistics Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the corr...

About the author

Hervé Schweitzer

Hervé Schweitzer is Principal Consultant and responsible of High Availability solutions at dbi services.

He has more than ten years of experience in database and infrastructure management, engineering, and optimization.

He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters RAC, Oracle GoldenGate and Oracle Failsafe.

http://www.dbi-services.com