{"id":11491,"date":"2018-08-14T20:03:15","date_gmt":"2018-08-14T18:03:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/"},"modified":"2018-08-14T20:03:15","modified_gmt":"2018-08-14T18:03:15","slug":"oda-database-been-stuck-in-deleting-status","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/","title":{"rendered":"ODA database been stuck in deleting status"},"content":{"rendered":"<p>Facing an internal inconsistency in the ODA derby database is very painful (see <a href=\"https:\/\/www.dbi-services.com\/blog\/oda-lite-what-is-this-odacli-repository\/\">https:\/\/www.dbi-services.com\/blog\/oda-lite-what-is-this-odacli-repository\/<\/a> for more info about the derby database).\u00a0I have recently faced a case where the database deletion was failing and the database remained then in &#8220;Deleting&#8221; status.\u00a0 Connecting directly to the internal derby database and doing some self cleaning is very risky and should be performed at your own and known risk. So, in most of the case, a database inconsistency issue ends with an Oracle Support ticket to get their help for cleaning. Before doing so I wanted to look closer to the issue and was very happy to fix it myself. I wanted to share my experience here.<\/p>\n<p><!--more--><\/p>\n<h3>Issue description<\/h3>\n<p>As explained in the introduction, the database deletion failed and the database remained in &#8220;Deleting&#8221; status.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">[root@prod1 ~]# odacli list-databases\n\nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\nea49c5a8-8747-4459-bb99-cd71c8c87d58     testtst1   Si       12.1.0.2             false      OLTP     Odb1s    ACFS       Deleting     80a2e501-31d8-4a5d-83db-e04dad34a7fa<\/pre>\n<p>Looking at the job activity log, we can see that the deletion is failing while trying to delete the FileSystem.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [20]\">[root@prod1 ~]# odacli describe-job -i 50a8c1c2-686e-455e-878f-eaa537295c9f\n\nJob details\n----------------------------------------------------------------\n                     ID:  50a8c1c2-686e-455e-878f-eaa537295c9f\n            Description:  Database service deletion with db name: testtst1 with id : ea49c5a8-8747-4459-bb99-cd71c8c87d58\n                 Status:  Failure\n                Created:  July 25, 2018 9:40:17 AM CEST\n                Message:  DCS-10011:Input parameter 'ACFS Device for delete' cannot be NULL.\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\ndatabase Service deletion for ea49c5a8-8747-4459-bb99-cd71c8c87d58 July 25, 2018 9:40:17 AM CEST       July 25, 2018 9:40:22 AM CEST       Failure\ndatabase Service deletion for ea49c5a8-8747-4459-bb99-cd71c8c87d58 July 25, 2018 9:40:17 AM CEST       July 25, 2018 9:40:22 AM CEST       Failure\nValidate db ea49c5a8-8747-4459-bb99-cd71c8c87d58 for deletion July 25, 2018 9:40:17 AM CEST       July 25, 2018 9:40:17 AM CEST       Success\nDatabase Deletion                        July 25, 2018 9:40:18 AM CEST       July 25, 2018 9:40:18 AM CEST       Success\nUnregister Db From Cluster               July 25, 2018 9:40:18 AM CEST       July 25, 2018 9:40:19 AM CEST       Success\nKill Pmon Process                        July 25, 2018 9:40:19 AM CEST       July 25, 2018 9:40:19 AM CEST       Success\nDatabase Files Deletion                  July 25, 2018 9:40:19 AM CEST       July 25, 2018 9:40:19 AM CEST       Success\nDeleting FileSystem                      July 25, 2018 9:40:21 AM CEST       July 25, 2018 9:40:22 AM CEST       Failure<\/pre>\n<p>I decided to have a look why it would have failed on the file system deletion step, and I was very surprised to see there was no data volume for this database anymore. This can be seen in the below volinfo command output. Not sure what happened, but it is weird : why failing if what you want to delete is no more existing and stopping processing further.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">ASMCMD&gt; volinfo --all\nDiskgroup Name: DATA\n\n         Volume Name: COMMONSTORE\n         Volume Device: \/dev\/asm\/commonstore-265\n         State: ENABLED\n         Size (MB): 5120\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage: ACFS\n         Mountpath: \/opt\/oracle\/dcs\/commonstore\n\nDiskgroup Name: RECO\n\n         Volume Name: RECO\n         Volume Device: \/dev\/asm\/reco-403\n         State: ENABLED\n         Size (MB): 304128\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage: ACFS\n         Mountpath: \/u03\/app\/oracle\/<\/pre>\n<h3>\u00a0Solution<\/h3>\n<p>So why not trying to give the ODA what he is expecting to see? Therefore I tried to create the ACFS volume with exact naming and I was very happy to see that this solved the problem. There was no other relation key than the name of the volume. Let&#8217;s look in details the steps I performed.<\/p>\n<p>Let&#8217;s create the database expected data volume.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,3,17]\">ASMCMD&gt; volcreate -G DATA -s 10G DATTESTTST1\n\nASMCMD&gt; volinfo -G DATA -a\nDiskgroup Name: DATA\n\n         Volume Name: COMMONSTORE\n         Volume Device: \/dev\/asm\/commonstore-265 \n         State: ENABLED\n         Size (MB): 5120\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage: ACFS\n         Mountpath: \/opt\/oracle\/dcs\/commonstore\n\n         Volume Name: DATTESTTST1\n         Volume Device: \/dev\/asm\/dattesttst1-265\n         State: ENABLED\n         Size (MB): 10240\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage:\n         Mountpath:<\/pre>\n<p>Let&#8217;s create the file system for the newly created volume.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">grid@prod1:\/home\/grid\/ [+ASM1] mkfs.acfs \/dev\/asm\/dattesttst1-265\nmkfs.acfs: version                   = 12.2.0.1.0\nmkfs.acfs: on-disk version           = 46.0\nmkfs.acfs: volume                    = \/dev\/asm\/dattesttst1-265\nmkfs.acfs: volume size               = 10737418240  (  10.00 GB )\nmkfs.acfs: Format complete.<\/pre>\n<p>Let&#8217;s check the expected mount points needed for the corresponding database.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,9]\">[root@prod1 ~]# odacli describe-dbstorage -i 31d852f7-bdd0-40f5-9224-2ca139a2c3db\nDBStorage details\n----------------------------------------------------------------\n                     ID: 31d852f7-bdd0-40f5-9224-2ca139a2c3db\n                DB Name: testtst1\n          DBUnique Name: testtst1_RZ1\n         DB Resource ID: ea49c5a8-8747-4459-bb99-cd71c8c87d58\n           Storage Type: Acfs\n          DATA Location: \/u02\/app\/oracle\/oradata\/testtst1_RZ1\n          RECO Location: \/u03\/app\/oracle\/fast_recovery_area\/\n          REDO Location: \/u03\/app\/oracle\/redo\/\n   FLASH Cache Location:\n                  State: ResourceState(status=Configured)\n                Created: July 18, 2018 10:28:39 AM CEST\n            UpdatedTime: July 18, 2018 10:29:01 AM CEST<\/pre>\n<p>In order to add and start the appropriate file system.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">[root@prod1 testtst1_RZ1]# cd \/u01\/app\/12.2.0.1\/grid\/bin\/\n[root@prod1 bin]# .\/srvctl add filesystem -volume DATTESTTST1 -diskgroup DATA -path \/u02\/app\/oracle\/oradata\/testtst1_RZ1 -fstype ACFS -autostart ALWAYS -mountowner oracle\n[root@prod1 bin]# .\/srvctl start filesystem -device \/dev\/asm\/dattesttst1-265<\/pre>\n<p>Let&#8217;s check the mounted file system.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1; highlight: [1,16]\">[root@prod1 bin]# df -h\nFilesystem            Size  Used Avail Use% Mounted on\n\/dev\/mapper\/VolGroupSys-LogVolRoot\n                       30G   24G  4.1G  86% \/\ntmpfs                 189G  1.3G  187G   1% \/dev\/shm\n\/dev\/md0              477M   40M  412M   9% \/boot\n\/dev\/sda1             500M  320K  500M   1% \/boot\/efi\n\/dev\/mapper\/VolGroupSys-LogVolOpt\n                       59G   13G   44G  22% \/opt\n\/dev\/mapper\/VolGroupSys-LogVolU01\n                       99G   25G   69G  27% \/u01\n\/dev\/asm\/commonstore-265\n                      5.0G  319M  4.7G   7% \/opt\/oracle\/dcs\/commonstore\n\/dev\/asm\/reco-403     297G   14G  284G   5% \/u03\/app\/oracle\n\/dev\/asm\/dattesttst1-265\n                       10G  265M  9.8G   3% \/u02\/app\/oracle\/oradata\/testtst1_RZ1<\/pre>\n<p>Let&#8217;s now try to delete the database again. Option -fd is mandatory to force deletion.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">[root@prod1 bin]# odacli delete-database -i ea49c5a8-8747-4459-bb99-cd71c8c87d58 -fd\n{\n  \"jobId\" : \"976c8689-a69d-4e0d-a5e0-e40a30a77d29\",\n  \"status\" : \"Running\",\n  \"message\" : null,\n  \"reports\" : [ {\n    \"taskId\" : \"TaskZJsonRpcExt_471\",\n    \"taskName\" : \"Validate db ea49c5a8-8747-4459-bb99-cd71c8c87d58 for deletion\",\n    \"taskResult\" : \"\",\n    \"startTime\" : \"July 25, 2018 10:04:24 AM CEST\",\n    \"endTime\" : \"July 25, 2018 10:04:24 AM CEST\",\n    \"status\" : \"Success\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_469\",\n    \"jobId\" : \"976c8689-a69d-4e0d-a5e0-e40a30a77d29\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"July 25, 2018 10:04:24 AM CEST\"\n  } ],\n  \"createTimestamp\" : \"July 25, 2018 10:04:23 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Database service deletion with db name: testtst1 with id : ea49c5a8-8747-4459-bb99-cd71c8c87d58\",\n  \"updatedTime\" : \"July 25, 2018 10:04:23 AM CEST\"\n}<\/pre>\n<p>The database deletion is now successful.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [7]\">[root@prod1 bin]# odacli describe-job -i 976c8689-a69d-4e0d-a5e0-e40a30a77d29\n\nJob details\n----------------------------------------------------------------\n                     ID:  976c8689-a69d-4e0d-a5e0-e40a30a77d29\n            Description:  Database service deletion with db name: testtst1 with id : ea49c5a8-8747-4459-bb99-cd71c8c87d58\n                 Status:  Success\n                Created:  July 25, 2018 10:04:23 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nValidate db ea49c5a8-8747-4459-bb99-cd71c8c87d58 for deletion July 25, 2018 10:04:24 AM CEST      July 25, 2018 10:04:24 AM CEST      Success\nDatabase Deletion                        July 25, 2018 10:04:24 AM CEST      July 25, 2018 10:04:24 AM CEST      Success\nUnregister Db From Cluster               July 25, 2018 10:04:24 AM CEST      July 25, 2018 10:04:24 AM CEST      Success\nKill Pmon Process                        July 25, 2018 10:04:24 AM CEST      July 25, 2018 10:04:24 AM CEST      Success\nDatabase Files Deletion                  July 25, 2018 10:04:24 AM CEST      July 25, 2018 10:04:25 AM CEST      Success\nDeleting Volume                          July 25, 2018 10:04:30 AM CEST      July 25, 2018 10:04:32 AM CEST      Success<\/pre>\n<p>Let&#8217;s check the volume and file system to make sure they have been removed.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,28]\">ASMCMD&gt; volinfo --all\nDiskgroup Name: DATA\n\n         Volume Name: COMMONSTORE\n         Volume Device: \/dev\/asm\/commonstore-265\n         State: ENABLED\n         Size (MB): 5120\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage: ACFS\n         Mountpath: \/opt\/oracle\/dcs\/commonstore\n\nDiskgroup Name: RECO\n\n         Volume Name: RECO\n         Volume Device: \/dev\/asm\/reco-403\n         State: ENABLED\n         Size (MB): 304128\n         Resize Unit (MB): 512\n         Redundancy: MIRROR\n         Stripe Columns: 8\n         Stripe Width (K): 1024\n         Usage: ACFS\n         Mountpath: \/u03\/app\/oracle\/\n\ngrid@prod1:\/home\/grid\/ [+ASM1] df -h\nFilesystem            Size  Used Avail Use% Mounted on\n\/dev\/mapper\/VolGroupSys-LogVolRoot\n                       30G   24G  4.1G  86% \/\ntmpfs                 189G  1.3G  187G   1% \/dev\/shm\n\/dev\/md0              477M   40M  412M   9% \/boot\n\/dev\/sda1             500M  320K  500M   1% \/boot\/efi\n\/dev\/mapper\/VolGroupSys-LogVolOpt\n                       59G   13G   44G  22% \/opt\n\/dev\/mapper\/VolGroupSys-LogVolU01\n                       99G   25G   69G  27% \/u01\n\/dev\/asm\/commonstore-265\n                      5.0G  319M  4.7G   7% \/opt\/oracle\/dcs\/commonstore\n\/dev\/asm\/reco-403     297G   14G  284G   5% \/u03\/app\/oracle\ngrid@prod1:\/home\/grid\/ [+ASM1]<\/pre>\n<p>Listing the database would show that the unique database has now been deleted.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">[root@prod1 bin]# odacli list-databases\nDCS-10032:Resource database is not found.<\/pre>\n<p>To complete the test and make sure all is ok, I created a new database, which I expected would be successful.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1; highlight: [6,7,26,30]\">[root@prod1 bin]# odacli describe-job -i cf896c7f-0675-4980-a63f-a8a2b09b1352\n\nJob details\n----------------------------------------------------------------\n                     ID:  cf896c7f-0675-4980-a63f-a8a2b09b1352\n            Description:  Database service creation with db name: testtst2\n                 Status:  Success\n                Created:  July 25, 2018 10:12:24 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nSetting up ssh equivalance               July 25, 2018 10:12:25 AM CEST      July 25, 2018 10:12:25 AM CEST      Success\nCreating volume dattesttst2              July 25, 2018 10:12:25 AM CEST      July 25, 2018 10:12:36 AM CEST      Success\nCreating ACFS filesystem for DATA        July 25, 2018 10:12:36 AM CEST      July 25, 2018 10:12:44 AM CEST      Success\nDatabase Service creation                July 25, 2018 10:12:44 AM CEST      July 25, 2018 10:18:49 AM CEST      Success\nDatabase Creation                        July 25, 2018 10:12:44 AM CEST      July 25, 2018 10:17:36 AM CEST      Success\nChange permission for xdb wallet files   July 25, 2018 10:17:36 AM CEST      July 25, 2018 10:17:36 AM CEST      Success\nPlace SnapshotCtrlFile in sharedLoc      July 25, 2018 10:17:36 AM CEST      July 25, 2018 10:17:37 AM CEST      Success\nRunning DataPatch                        July 25, 2018 10:18:34 AM CEST      July 25, 2018 10:18:47 AM CEST      Success\nupdating the Database version            July 25, 2018 10:18:47 AM CEST      July 25, 2018 10:18:49 AM CEST      Success\ncreate Users tablespace                  July 25, 2018 10:18:49 AM CEST      July 25, 2018 10:18:51 AM CEST      Success\n\n\n\n[root@prod1 bin]# odacli list-databases\n\nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\ne0e8163d-dcaa-4692-85c5-24fb9fe17291     testtst2   Si       12.1.0.2             false      OLTP     Odb1s    ACFS       Configured   80a2e501-31d8-4a5d-83db-e04dad34a7fa<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Facing an internal inconsistency in the ODA derby database is very painful (see https:\/\/www.dbi-services.com\/blog\/oda-lite-what-is-this-odacli-repository\/ for more info about the derby database).\u00a0I have recently faced a case where the database deletion was failing and the database remained then in &#8220;Deleting&#8221; status.\u00a0 Connecting directly to the internal derby database and doing some self cleaning is very risky [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[1046,79,96],"type_dbi":[],"class_list":["post-11491","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-engineered-system","tag-oda","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ODA database been stuck in deleting status - dbi Blog<\/title>\n<meta name=\"description\" content=\"This blog describes a workaround after a deletion database failure on ODA.\" \/>\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\/oda-database-been-stuck-in-deleting-status\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA database been stuck in deleting status\" \/>\n<meta property=\"og:description\" content=\"This blog describes a workaround after a deletion database failure on ODA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-14T18:03:15+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"ODA database been stuck in deleting status\",\"datePublished\":\"2018-08-14T18:03:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\"},\"wordCount\":411,\"commentCount\":0,\"keywords\":[\"Engineered system\",\"ODA\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\",\"name\":\"ODA database been stuck in deleting status - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-08-14T18:03:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"description\":\"This blog describes a workaround after a deletion database failure on ODA.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA database been stuck in deleting status\"}]},{\"@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\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ODA database been stuck in deleting status - dbi Blog","description":"This blog describes a workaround after a deletion database failure on ODA.","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\/oda-database-been-stuck-in-deleting-status\/","og_locale":"en_US","og_type":"article","og_title":"ODA database been stuck in deleting status","og_description":"This blog describes a workaround after a deletion database failure on ODA.","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/","og_site_name":"dbi Blog","article_published_time":"2018-08-14T18:03:15+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"ODA database been stuck in deleting status","datePublished":"2018-08-14T18:03:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/"},"wordCount":411,"commentCount":0,"keywords":["Engineered system","ODA","Oracle"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/","name":"ODA database been stuck in deleting status - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-08-14T18:03:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"description":"This blog describes a workaround after a deletion database failure on ODA.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-database-been-stuck-in-deleting-status\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA database been stuck in deleting status"}]},{"@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\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11491","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\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11491"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11491\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11491"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}