Blog - comments

Thank you very much..was struggling so hard !!! to run a simple sql statement!! u ve made my day!! ...
Sunny
Hi David, Your post is the best i have read so far on the subject. One remark : CASE WHEN "SUM(qp.ro...
Eyal Golombek
Hi Martin, No unfortunately I've no bug opened. SR were closed as resolved by customer. Increasing n...
Did you succeed in getting support to open a bug for this? Which agent versions are affected?Best re...
Martin Decker
Hi Christopher, It's there. I't not an option that you check at install. Just use it by setting inme...
Blog Hervé Schweitzer Take care while upgrading your Oracle DB with "DBUA"

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 & SharePoint, 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!

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.

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.

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.

Rate this blog entry:
1

Hervé Schweitzer is Chief Technology Officer (CTO) and Principal Consultant 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. Hervé Schweitzer is Oracle Certified Master 11g (OCM 11g). Prior to joining dbi services, Hervé Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Hervé Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Wednesday, 30 July 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter