{"id":8210,"date":"2015-07-27T15:12:04","date_gmt":"2015-07-27T19:12:04","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=8210"},"modified":"2015-07-27T15:12:04","modified_gmt":"2015-07-27T19:12:04","slug":"database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/","title":{"rendered":"Database validation failed while applying EBS R12.2 application patch : Oracle Apps DBA Training : Patches"},"content":{"rendered":"

This post is from our Oracle Apps DBA – R12 Training<\/a> ( next batch starts on 8th Aug, 2015<\/span>) where we cover installation, patching, cloning and other maintenance tasks. We also cover upgrade <\/strong>of Oracle E-Business Suite 12.2.0 <\/strong>to 12.2.4<\/strong> to show how to apply patches and new patch process in Oracle Apps.<\/p>\n

One of the trainee from previous batch encountered issue while applying EBS R12.2 application patches 19330775 and 20677045 where command used is highlighted below. The new utility to apply patch is adop<\/strong> (prior to 12.2 you apply patches using adpatch<\/strong>)<\/p>\n

adop phase=apply patches=19330775,20677045 hotpatch=yes merge=yes<\/strong><\/span><\/p>\n

But patch was failing with error message like:<\/p>\n

\u201c<\/span><\/strong>adop is not able to detect any valid application tier nodes in ADOP_VALID_NODES table. Ensure autoconfig is run on all nodes.<\/span>\u201d<\/span><\/strong><\/p>\n

So we run autoconfig<\/strong>\u00a0(there is dedciated topic on Autoconfig in our Oracle Apps\/R12 DBA Training<\/a><\/span>) on both Apps Tier & DB Tier by using below commands<\/p>\n

    \n
  1. Stop the application tier and Database tier<\/li>\n
  2. \u00a0Autoconfig on Database tier
    \na) Source the Oracle Database env
    \nb) cd $ORACLE_HOME\/appsutil\/scripts\/$CONTEXT_NAME
    \nc) sh adautocfg.sh<\/strong>
    \n(Check the autoconfig logfiles for any error at\u00a0$ORACLE_HOME\/appsutil\/log\/$CONTEXT_NAME<\/span>)<\/li>\n
  3. Autoconfig on Apps Tier
    \na) Please source the APPS environment
    \nb) cd $ADMIN_SCRIPTS_HOME
    \nc) sh adautocfg.sh<\/strong><\/li>\n<\/ol>\n

    After running autoconfig on both the tiers, we again run the command to apply the patch. This time patch failed to execute some SQL statements and showing below error messages:<\/p>\n

    [Error] \u00a0Failed to execute SQL statement :<\/span><\/p>\n

    declare<\/span><\/p>\n

    \u00a0 \u00a0 l_msg varchar2(4000);<\/span><\/p>\n

    \u00a0begin<\/span><\/p>\n

    \u00a0 \u00a0 ad_zd_adop.adop_database_validations(l_msg);<\/span><\/p>\n

    \u00a0 \u00a0 dbms_output.put_line(l_msg);<\/span><\/p>\n

    end;<\/span><\/p>\n

    [Error] \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Error Message :<\/span><\/p>\n

    [UNEXPECTED] Error occurred while performing database validations<\/span><\/p>\n

    \"blog\"<\/a><\/p>\n

    Solution:<\/strong><\/p>\n

    To fix this issue, apply database<\/strong> patch\u00a017693770<\/strong> as per the instructions mentioned in Readme.<\/p>\n

    After applying 17693770 patch on database tier, issue got resolved and we were able to apply the patches successfully.<\/p>\n

    You can learn more\u00a0from our expert team by registering to Oracle Apps DBA Training<\/a> (next batch starts 8th Aug 2015- register early before 30th July to get 100 USD OFF<\/span>)<\/p>\n

    K21 Technologies provide Full Money back Guarantee (If you are not happy after 2 sessions then you can ask for Full Money Back<\/span> )<\/div>\n

    For further details and registration check<\/p>\n

    http:\/\/k21technologies.com\/oracle-apps-dba-training<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    This post is from our Oracle Apps DBA – R12 Training ( next batch starts on 8th Aug, 2015) where […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[35,42],"tags":[],"class_list":["post-8210","post","type-post","status-publish","format-standard","hentry","category-r12","category-troubleshooting"],"yoast_head":"\nOracle Apps DBA Training : Patches & 12.2.4 Upgrade<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Apps DBA Training : Patches & 12.2.4 Upgrade\" \/>\n<meta property=\"og:description\" content=\"This post is from our Oracle Apps DBA – R12 Training ( next batch starts on 8th Aug, 2015) where […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-27T19:12:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/\",\"name\":\"Oracle Apps DBA Training : Patches & 12.2.4 Upgrade\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png\",\"datePublished\":\"2015-07-27T19:12:04+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database validation failed while applying EBS R12.2 application patch : Oracle Apps DBA Training : Patches\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Apps DBA Training : Patches & 12.2.4 Upgrade","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:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Apps DBA Training : Patches & 12.2.4 Upgrade","og_description":"This post is from our Oracle Apps DBA – R12 Training ( next batch starts on 8th Aug, 2015) where […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/","article_published_time":"2015-07-27T19:12:04+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/","url":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/","name":"Oracle Apps DBA Training : Patches & 12.2.4 Upgrade","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png","datePublished":"2015-07-27T19:12:04+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2015\/07\/blog-300x187.png"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2015\/07\/27\/database-validation-failed-while-applying-ebs-r12-2-application-patch-oracle-apps-dba-training-patches\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Database validation failed while applying EBS R12.2 application patch : Oracle Apps DBA Training : Patches"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/8210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=8210"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/8210\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=8210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=8210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=8210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}