{"id":2263,"date":"2011-08-11T12:36:00","date_gmt":"2011-08-11T10:36:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/"},"modified":"2011-08-11T12:36:00","modified_gmt":"2011-08-11T10:36:00","slug":"take-care-while-upgrading-your-oracle-db-with-qdbuaq","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/","title":{"rendered":"Take care while upgrading your Oracle DB with &#8220;DBUA&#8221;"},"content":{"rendered":"<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif\" alt=\"tmp\" width=\"550\" height=\"389\" \/><\/p>\n<h3>Analysis<\/h3>\n<p>I began checking why the diagnostic directory was growing so fast. And I found out that all 11g databases &#8211; the new one and all the other ones &#8211; reported the message below each second in the database alert.log file.<\/p>\n<p><code>WARNING: Oracle executable binary mismatch detected.<br \/>\nBinary of new process does not match binary which started instance<br \/>\nissue alter system set \"_disable_image_check\" = true to disable these messages<\/code><\/p>\n<p>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.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@chbsslcmdbdb1:~\/app\/oracle\/product\/11.2.0.2\/bin\/ [DBACT411] ls -lrt\n ....\n -rwxr-xr-x 1 oracle dba\u00a0\u00a0\u00a0\u00a0\u00a0 3771 Oct 28\u00a0 2010 emagentdeploy.pl\n -rwxr-xr-x 1 oracle dba\u00a0\u00a0\u00a0\u00a0\u00a0 6299 Oct 28\u00a0 2010 dbca\n -rwxr-xr-x 1 oracle dba\u00a0\u00a0\u00a0\u00a0\u00a0 3552 Oct 28\u00a0 2010 db2gc\n -rwsr-s--x 1 oracle dba 228886356 Jun\u00a0 9 09:59 oracle<\/pre>\n<h3>How to fix this problem<\/h3>\n<p>A restart from all affected database must be done.<\/p>\n<h3>My recommendation<\/h3>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.dbi-services.com\/wp-insides\/uploads\/images\/stories\/blog\/Herve\/tmp.gif\" \/><\/p>\n","protected":false},"author":8,"featured_media":2264,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[23,279,15,33,17],"type_dbi":[],"class_list":["post-2263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-dba","tag-dbua","tag-migration","tag-oracle-10g-to-8i","tag-oracle-11g"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Take care while upgrading your Oracle DB with &quot;DBUA&quot; - dbi Blog<\/title>\n<meta name=\"description\" content=\"Take care when you upgrade your database with the Oracle Database Upgrade Assistant &quot;dbua&quot;!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Take care while upgrading your Oracle DB with &quot;DBUA&quot;\" \/>\n<meta property=\"og:description\" content=\"Take care when you upgrade your database with the Oracle Database Upgrade Assistant &quot;dbua&quot;!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-11T10:36:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"756\" \/>\n\t<meta property=\"og:image:height\" content=\"535\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Herv\u00e9 Schweitzer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Herv\u00e9 Schweitzer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/\"},\"author\":{\"name\":\"Herv\u00e9 Schweitzer\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"headline\":\"Take care while upgrading your Oracle DB with &#8220;DBUA&#8221;\",\"datePublished\":\"2011-08-11T10:36:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/\"},\"wordCount\":183,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/tmp.gif\",\"keywords\":[\"DBA\",\"dbua\",\"Migration\",\"Oracle 10g to 8i\",\"Oracle 11g\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/\",\"name\":\"Take care while upgrading your Oracle DB with \\\"DBUA\\\" - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/tmp.gif\",\"datePublished\":\"2011-08-11T10:36:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"description\":\"Take care when you upgrade your database with the Oracle Database Upgrade Assistant \\\"dbua\\\"!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/tmp.gif\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/tmp.gif\",\"width\":756,\"height\":535},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Take care while upgrading your Oracle DB with &#8220;DBUA&#8221;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7fb08fbefcb9b2c146ef4533cfee00c7\",\"name\":\"Herv\u00e9 Schweitzer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"caption\":\"Herv\u00e9 Schweitzer\"},\"description\":\"Herv\u00e9 Schweitzer 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\u00e9 Schweitzer is \\\"Oracle Certified Master 11g (OCM 11g)\\\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/herve-schweitzer\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Take care while upgrading your Oracle DB with \"DBUA\" - dbi Blog","description":"Take care when you upgrade your database with the Oracle Database Upgrade Assistant \"dbua\"!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/","og_locale":"en_US","og_type":"article","og_title":"Take care while upgrading your Oracle DB with \"DBUA\"","og_description":"Take care when you upgrade your database with the Oracle Database Upgrade Assistant \"dbua\"!","og_url":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/","og_site_name":"dbi Blog","article_published_time":"2011-08-11T10:36:00+00:00","og_image":[{"width":756,"height":535,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif","type":"image\/gif"}],"author":"Herv\u00e9 Schweitzer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Herv\u00e9 Schweitzer","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/"},"author":{"name":"Herv\u00e9 Schweitzer","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"headline":"Take care while upgrading your Oracle DB with &#8220;DBUA&#8221;","datePublished":"2011-08-11T10:36:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/"},"wordCount":183,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif","keywords":["DBA","dbua","Migration","Oracle 10g to 8i","Oracle 11g"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/","url":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/","name":"Take care while upgrading your Oracle DB with \"DBUA\" - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif","datePublished":"2011-08-11T10:36:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"description":"Take care when you upgrade your database with the Oracle Database Upgrade Assistant \"dbua\"!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tmp.gif","width":756,"height":535},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/take-care-while-upgrading-your-oracle-db-with-qdbuaq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Take care while upgrading your Oracle DB with &#8220;DBUA&#8221;"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7","name":"Herv\u00e9 Schweitzer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","caption":"Herv\u00e9 Schweitzer"},"description":"Herv\u00e9 Schweitzer 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\u00e9 Schweitzer is \"Oracle Certified Master 11g (OCM 11g)\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2263"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2264"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2263"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}