{"id":9922,"date":"2016-03-16T04:22:47","date_gmt":"2016-03-16T08:22:47","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=9922"},"modified":"2016-05-14T03:29:45","modified_gmt":"2016-05-14T07:29:45","slug":"rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/","title":{"rendered":"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed"},"content":{"rendered":"

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

Recently, one of our trainee\u00a0came across the error when he was trying to drop RCU Schema\u00a0that Prerequisite ” Oracle Platform Security services<\/strong>”\u00a0 failed\u00a0 . In this post,\u00a0we will cover how to find what is the error and how to resolve this issue but before that one should know what is RCU.<\/p>\n

RCU:<\/strong><\/span> Repository Creation Utility is tool to create schema and load repository in existing database for Fusion Middleware components. If you want to learn more about RCU then look at Post here<\/a>.<\/p>\n

You can use RCU to create or Drop Schema as shown in screenshot above<\/span><\/p>\n

How to check Error:<\/strong><\/span><\/p>\n

Check rcu log files for error and find error messages as given below.<\/p>\n

RCU Log file location:<\/strong><\/em><\/p>\n

RCU_HOME\/rcu\/log\/logdir.date_timestamp\/<\/strong><\/em><\/p>\n

In rcu.log file, It was showing\u00a0that\u00a0“RCU-6083:Failed \u2013 The Schema Owner DEV_OPSS Is Connected To The Database. Please Disconnect And Try Again<\/span>”\u00a0which was causing this issue.<\/i><\/b><\/p>\n

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

Fix<\/span>\u00a0:<\/strong><\/p>\n

To resolve this issue,\u00a0Restart Database and Listener\u00a0as by doing this, it will disconnect the DEV_OPSS from Database\u00a0and then we can drop RCU schema without any issue.<\/p>\n

For stop and start database and listener you can use following steps:<\/p>\n

To stop database and Listener:<\/strong><\/span><\/p>\n

1. Login to host where database is running.<\/p>\n

2. Set environment variable of OAM Database.<\/p>\n

[code language=”bash”]
\n. dbiam.env
\n[\/code]<\/p>\n

3. stop Listener<\/p>\n

[code language=”bash”]
\nlsnrctl stop
\n[\/code]<\/p>\n

4. Connect to the database as ‘sysdba’<\/p>\n

[code language=”bash”]
\nsqlplus “\/as sysba”
\n[\/code]<\/p>\n

5. stop database<\/p>\n

[code language=”sql”]
\nSQL>shutdown immediate
\n[\/code]<\/p>\n

To start database and listener:<\/strong><\/span><\/p>\n

1. Login to host where database is running.<\/p>\n

2. Set environment variable of OAM Database.<\/p>\n

[code language=”bash”]<\/p>\n

. dbiam.env<\/p>\n

[\/code]<\/p>\n

3. stop Listener<\/p>\n

[code language=”bash”]<\/p>\n

lsnrctl start<\/p>\n

[\/code]<\/p>\n

4. Connect to the database as ‘sysdba’<\/p>\n

[code language=”bash”]<\/p>\n

sqlplus\u00a0 “\/as sysdba”<\/p>\n

[\/code]<\/p>\n

5. stop database<\/p>\n

[code language=”sql”]<\/p>\n

SQL> startup<\/p>\n

[\/code]<\/p>\n

If you want to learn more on Oracle Access Manager (OAM), then register for our free Minicourse by clicking on below image.<\/p>\n

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

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Recently, one of our trainee\u00a0came across the error when he was trying to drop RCU Schema\u00a0that Prerequisite ” Oracle Platform […]<\/p>\n","protected":false},"author":115,"featured_media":10499,"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":[442],"tags":[],"class_list":["post-9922","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-access-manager"],"yoast_head":"\nRCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -<\/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\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -\" \/>\n<meta property=\"og:description\" content=\"Recently, one of our trainee\u00a0came across the error when he was trying to drop RCU Schema\u00a0that Prerequisite ” Oracle Platform […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-16T08:22:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-14T07:29:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png\" \/>\n\t<meta property=\"og:image:width\" content=\"782\" \/>\n\t<meta property=\"og:image:height\" content=\"228\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/\",\"name\":\"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png\",\"datePublished\":\"2016-03-16T08:22:47+00:00\",\"dateModified\":\"2016-05-14T07:29:45+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png\",\"width\":782,\"height\":228},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed\"}]},{\"@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":"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -","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\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/","og_locale":"en_US","og_type":"article","og_title":"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -","og_description":"Recently, one of our trainee\u00a0came across the error when he was trying to drop RCU Schema\u00a0that Prerequisite ” Oracle Platform […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/","article_published_time":"2016-03-16T08:22:47+00:00","article_modified_time":"2016-05-14T07:29:45+00:00","og_image":[{"width":782,"height":228,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png","type":"image\/png"}],"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\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/","url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/","name":"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png","datePublished":"2016-03-16T08:22:47+00:00","dateModified":"2016-05-14T07:29:45+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/Oracle_RCU_onlineAppsDBA.png","width":782,"height":228},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/16\/rcu-6083-failed-dropremove-schema-using-rcu-prerequisite-opss-failed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"RCU-6083 : Failed Drop\/Remove Schema using RCU : Prerequisite OPSS failed"}]},{"@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\/9922","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=9922"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/9922\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/10499"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=9922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=9922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=9922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}