{"id":1644,"date":"2010-04-20T07:12:00","date_gmt":"2010-04-20T11:12:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/"},"modified":"2011-05-16T04:43:20","modified_gmt":"2011-05-16T08:43:20","slug":"oid-11g-installation-troubleshooting","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/","title":{"rendered":"OID 11g installation troubleshooting"},"content":{"rendered":"<p>I have done been doing OID 11g installation in windows environment recently and encountered an issue.In this case, there is also DB Vault installed with Oracle Database. So if you happen to install OID schema using RCU on such DB with Vault, then you have to follow these steps:<\/p>\n<p>1. Disable DB Vault: follow this <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b31222\/dvdisabl.htm#DVADM012\">guide\u00a0 <\/a>.<\/p>\n<p>2. Install OID Schema using RCU.<\/p>\n<p>3. Install OID<\/p>\n<p>4. Enable DB Vault again.<\/p>\n<p>If you are using Oracle DB 11.1.0.7, then you may need to patch it with this 7244497 and 7291157. You can also follow this <a href=\"http:\/\/fmwdocs.us.oracle.com\/doclibs\/fmw\/11gr1_final\/oid.1111\/e10029\/data_privacy.htm#BGBJBBJI\">guide<\/a>.\u00a0 As per the guide, you would need to apply 2 patches post OID installation i.e,\u00a0 7244497 and 7291157. If you are using windows machine then 7244497 is not available. However, you can simply apply 1 patch 9384493 as it covers the bugs of both patches 7244497 and 7291157.<\/p>\n<p>Though it happens to be the common error while installing OID 11g (11.1.1.2.0), it fails at step Creating OID instance\/ Starting OID instance.<\/p>\n<p>The error may look like this<\/p>\n<p>Error creating ASComponent oid1.<\/p>\n<p>Cause:<\/p>\n<p>An internal operation has failed: Exception in onCreate()<\/p>\n<p>Action:<\/p>\n<p>See logs for more details.<\/p>\n<p>Step Create Oracle Internet Directory\u00a0 failed<\/p>\n<p>Upon debugging the install logs, I found this &#8220;OID schema entry missing in schema_version_registry&#8221;.<\/p>\n<p>The way to debug is to execute the following sql queries to check the no. of rows it returns.<\/p>\n<p>select count(*) from schema_version_registry;<br \/>\nSELECT count(*) FROM all_objects WHERE object_name=&#8217;SCHEMA_VERSION_REGISTRY&#8217; AND object_type=&#8217;VIEW&#8217;;<\/p>\n<p>If both returns more than 1, then there is an issue. Hence we need to drop the\u00a0 OID schema using RCU and create it again.<\/p>\n<p>Later, run the OID installer and it went fine.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have done been doing OID 11g installation in windows environment recently and encountered an issue.In this case, there is [&hellip;]<\/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":[42],"tags":[31,466],"class_list":["post-1644","post","type-post","status-publish","format-standard","hentry","category-troubleshooting","tag-oid","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>OID 11g installation troubleshooting -<\/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\/2010\/04\/20\/oid-11g-installation-troubleshooting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OID 11g installation troubleshooting -\" \/>\n<meta property=\"og:description\" content=\"I have done been doing OID 11g installation in windows environment recently and encountered an issue.In this case, there is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-04-20T11:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-05-16T08:43:20+00:00\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/\",\"name\":\"OID 11g installation troubleshooting -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2010-04-20T11:12:00+00:00\",\"dateModified\":\"2011-05-16T08:43:20+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OID 11g installation troubleshooting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; 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":"OID 11g installation troubleshooting -","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\/2010\/04\/20\/oid-11g-installation-troubleshooting\/","og_locale":"en_US","og_type":"article","og_title":"OID 11g installation troubleshooting -","og_description":"I have done been doing OID 11g installation in windows environment recently and encountered an issue.In this case, there is [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/","article_published_time":"2010-04-20T11:12:00+00:00","article_modified_time":"2011-05-16T08:43:20+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/","url":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/","name":"OID 11g installation troubleshooting -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2010-04-20T11:12:00+00:00","dateModified":"2011-05-16T08:43:20+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/04\/20\/oid-11g-installation-troubleshooting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"OID 11g installation troubleshooting"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; 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\/1644","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=1644"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1644\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}