{"id":14194,"date":"2020-05-25T20:33:07","date_gmt":"2020-05-25T18:33:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/"},"modified":"2020-05-25T20:33:07","modified_gmt":"2020-05-25T18:33:07","slug":"issue-deleting-a-database-on-oda","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/","title":{"rendered":"Issue deleting a database on ODA?"},"content":{"rendered":"

I have recently faced an issue deleting database on an ODA. I was getting following error whatever database I wanted to delete : DCS-10001:Internal error encountered: null<\/em><\/strong>.<\/p>\n

Through this blog, I would like to share with you my experience on this case hoping it will help you if you are facing same problem. On this project I was using ODA Release 18.5 and 18.8 and faced the same problem on both versions. On 18.3 and previous releases this was not the case.<\/p>\n

<\/p>\n

Deleting the database<\/h3>\n

With odacli I tried to delete my TEST database, running following commands :<\/p>\n

[root@ODA01 bin]# odacli delete-database -in TEST -fd<\/strong>
\n{
\n\"jobId\" : \"bcdcbf59-0fe6-44b7-af7f-91f68c7697ed\",
\n\"status\" : \"Running\",
\n\"message\" : null,
\n\"reports\" : [ {
\n\"taskId\" : \"TaskZJsonRpcExt_858\",
\n\"taskName\" : \"Validate db d6542252-dfa4-47f9-9cfc-22b4f0575c51 for deletion\",
\n\"taskResult\" : \"\",
\n\"startTime\" : \"May 06, 2020 11:36:38 AM CEST\",
\n\"endTime\" : \"May 06, 2020 11:36:38 AM CEST\",
\n\"status\" : \"Success\",
\n\"taskDescription\" : null,
\n\"parentTaskId\" : \"TaskSequential_856\",
\n\"jobId\" : \"bcdcbf59-0fe6-44b7-af7f-91f68c7697ed\",
\n\"tags\" : [ ],
\n\"reportLevel\" : \"Info\",
\n\"updatedTime\" : \"May 06, 2020 11:36:38 AM CEST\"
\n} ],
\n\"createTimestamp\" : \"May 06, 2020 11:36:38 AM CEST\",
\n\"resourceList\" : [ ],
\n\"description\" : \"Database service deletion with db name: TEST with id : d6542252-dfa4-47f9-9cfc-22b4f0575c51\",
\n\"updatedTime\" : \"May 06, 2020 11:36:38 AM CEST\"
\n}<\/code><\/p>\n

The job was failing with DCS-10001 Error :<\/p>\n

[root@ODA01 bin]# odacli describe-job -i \"bcdcbf59-0fe6-44b7-af7f-91f68c7697ed\"<\/strong>
\n 
\nJob details
\n----------------------------------------------------------------
\nID: bcdcbf59-0fe6-44b7-af7f-91f68c7697ed
\nDescription: Database service deletion with db name: TEST with id : d6542252-dfa4-47f9-9cfc-22b4f0575c51
\nStatus: Failure
\nCreated: May 6, 2020 11:36:38 AM CEST
\nMessage: DCS-10001:Internal error encountered: null.<\/strong>
\n 
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\ndatabase Service deletion for d6542252-dfa4-47f9-9cfc-22b4f0575c51 May 6, 2020 11:36:38 AM CEST May 6, 2020 11:36:50 AM CEST Failure
\ndatabase Service deletion for d6542252-dfa4-47f9-9cfc-22b4f0575c51 May 6, 2020 11:36:38 AM CEST May 6, 2020 11:36:50 AM CEST Failure
\nValidate db d6542252-dfa4-47f9-9cfc-22b4f0575c51 for deletion May 6, 2020 11:36:38 AM CEST May 6, 2020 11:36:38 AM CEST Success
\nDatabase Deletion May 6, 2020 11:36:39 AM CEST May 6, 2020 11:36:39 AM CEST Success
\nUnregister Db From Cluster May 6, 2020 11:36:39 AM CEST May 6, 2020 11:36:39 AM CEST Success
\nKill Pmon Process May 6, 2020 11:36:39 AM CEST May 6, 2020 11:36:39 AM CEST Success
\nDatabase Files Deletion May 6, 2020 11:36:39 AM CEST May 6, 2020 11:36:40 AM CEST Success
\nDeleting Volume May 6, 2020 11:36:47 AM CEST May 6, 2020 11:36:50 AM CEST Success
\ndatabase Service deletion for d6542252-dfa4-47f9-9cfc-22b4f0575c51 May 6, 2020 11:36:50 AM CEST May 6, 2020 11:36:50 AM CEST Failure<\/code><\/p>\n

Troubleshooting<\/h3>\n

In the dcs-agent.log, located in \/opt\/oracle\/dcs\/log folder, you might see following errors :<\/p>\n

2019-11-27 13:54:30,106 ERROR [database Service deletion for 89e11f5d-9789-44a3-a09d-2444f0fda99e : JobId=05a2d017-9b64-4e92-a7df-3ded603d0644] [] c.o.d.c.j.JsonRequestProcessor: RPC request invocation failed on request: {\"classz\":\"com.oracle.dcs.agent.rpc.service.dataguard.DataguardActions\",\"method\":\"deleteListenerEntry<\/strong>\",\"params\":[{\"type\":\"com.oracle.dcs.agent.model.DB\",\"value\":{\"updatedTime\":1573023492194,\"id\":\"89e11f5d-9789-44a3-a09d-2444f0fda99e\",\"name\":\"TEST\",\"createTime\":1573023439244,\"state\":{\"status\":\"CONFIGURED\"},\"dbName\":\"TEST\",\"databaseUniqueName\":\"TEST_RZB\",\"dbVersion\":\"11.2.0.4.190115\",\"dbHomeId\":\"c58cdcfd-e5b2-4041-b993-8df5a5d5ada4\",\"dbId\":null,\"isCdb\":false,\"pdBName\":null,\"pdbAdminUserName\":null,\"enableTDE\":false,\"isBcfgInSync\":null,\"dbType\":\"SI\",\"dbTargetNodeNumber\":\"0\",\"dbClass\":\"OLTP\",\"dbShape\":\"odb1\",\"dbStorage\":\"ACFS\",\"dbOnFlashStorage\":false,\"level0BackupDay\":\"sunday\",\"instanceOnly\":true,\"registerOnly\":false,\"rmanBkupPassword\":null,\"dbEdition\":\"SE\",\"dbDomainName\":\"ksbl.local\",\"dbRedundancy\":null,\"dbCharacterSet\":{\"characterSet\":\"AL32UTF8\",\"nlsCharacterset\":\"AL16UTF16\",\"dbTerritory\":\"AMERICA\",\"dbLanguage\":\"AMERICAN\"},\"dbConsoleEnable\":false,\"backupDestination\":\"NONE\",\"cloudStorageContainer\":null,\"backupConfigId\":null,\"isAutoBackupDisabled\":false}}],\"revertable\":false,\"threadId\":111}
\n! java.lang.NullPointerException: null
\n! at com.oracle.dcs.agent.rpc.service.dataguard.DataguardOperations.deleteListenerEntry(DataguardOperations.java:2258)
\n! at com.oracle.dcs.agent.rpc.service.dataguard.DataguardActions.deleteListenerEntry(DataguardActions.java:24)
\n! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
\n! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
\n! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
\n! at java.lang.reflect.Method.invoke(Method.java:498)
\n! at com.oracle.dcs.commons.jrpc.JsonRequestProcessor.invokeRequest(JsonRequestProcessor.java:33)
\n! ... 23 common frames omitted
\n! Causing: com.oracle.dcs.commons.exception.DcsException: DCS-10001:Internal error encountered: null.
\n! at com.oracle.dcs.commons.exception.DcsException$Builder.build(DcsException.java:68)
\n! at com.oracle.dcs.commons.jrpc.JsonRequestProcessor.invokeRequest(JsonRequestProcessor.java:45)
\n! at com.oracle.dcs.commons.jrpc.JsonRequestProcessor.process(JsonRequestProcessor.java:74)
\n! at com.oracle.dcs.agent.task.TaskZJsonRpcExt.callInternal(TaskZJsonRpcExt.java:65)
\n! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:182)
\n! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:26)
\n! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:82)
\n! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:37)
\n! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:39)
\n! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:10)
\n! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:82)
\n! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:37)
\n! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:39)
\n! at com.oracle.dcs.agent.task.TaskZLockWrapper.call(TaskZLockWrapper.java:64)
\n! at com.oracle.dcs.agent.task.TaskZLockWrapper.call(TaskZLockWrapper.java:21)
\n! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:82)
\n! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:37)
\n! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:39)
\n! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:10)
\n! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:82)
\n! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:17)
\n! at java.util.concurrent.FutureTask.run(FutureTask.java:266)
\n! at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
\n! at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
\n! at java.lang.Thread.run(Thread.java:748)
\n2019-11-27 13:54:30,106 INFO [database Service deletion for 89e11f5d-9789-44a3-a09d-2444f0fda99e : JobId=05a2d017-9b64-4e92-a7df-3ded603d0644] [] c.o.d.a.z.DCSZooKeeper: DCS node id is - node_0
\n2019-11-27 13:54:30,106 DEBUG [database Service deletion for 89e11f5d-9789-44a3-a09d-2444f0fda99e : JobId=05a2d017-9b64-4e92-a7df-3ded603d0644] [] c.o.d.a.t.TaskZJsonRpc: Task[TaskZJsonRpcExt_124] RPC request 'Local:node_0@deleteListenerEntry()' completed: Failure<\/strong><\/code><\/p>\n

The key error to note would be : Local:node_0@deleteListenerEntry()’ completed: Failure<\/em><\/strong><\/p>\n

Explaination<\/h3>\n

This problem comes from the fact that the listener.ora file has been customized. As per Oracle Support, on an ODA, the listener.ora should never be customized and default listener.ora file should be used. I still have a SR opened with Oracle Support to clarify the situation as I’m fully convinced that this is a regression :<\/p>\n

    \n
  1. It was always possible in previous ODA versions to delete a database with a customized listener file<\/li>\n
  2. We need to customize the listener when setting Data Guard on Oracle 11.2.0.4 Version (still supported on ODA)<\/li>\n
  3. We need to customize the listener when doing duplication as dynamic registration is not possible when the database is in nomount state and database is restarted during the duplication.<\/li>\n<\/ol>\n

    Moreover other ODA documentations are still referring customization of the listener.ora file when using ODA :
    \nWhite paper : STEPS TO MIGRATE NON-CDB DATABASES TO ACFS ON ORACLE DATABASEAPPLIANCE 12.1.2<\/a>
    \n    Deploying Oracle Data Guard with Oracle Database Appliance – A WhitePaper (2016-7) (Doc ID 2392307.1)<\/a><\/p>\n

    I will update the post as soon as I have some feedback from Oracle support on this.<\/p>\n

    The workaround would be to set back the default listener.ora file time of the deletion, which would request a maintenance windows for some customer.<\/p>\n

    Solution\/Workaround<\/h3>\n

    Backup of the current listener configuration<\/h4>\n

    OK, so let’s backup our current listener configuration first :<\/p>\n

    grid@ODA01:\/home\/grid\/ [+ASM1] cd $TNS_ADMIN<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] cp -p listener.ora .\/history\/listener.ora.20200506<\/strong><\/code><\/p>\n

    Default ODA listener configuration<\/h4>\n

    The backup of the default listener configuration is the following one :<\/p>\n

    grid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] cat listener19071611AM2747.bak<\/strong>
    \nLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
    \nASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent
    \nENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent
    \nVALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent
    \nENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
    \nVALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent<\/code><\/p>\n

    Stopping the listener<\/h4>\n

    Let’s stop the listener :<\/p>\n

    grid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl stop listener -listener listener<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl status listener -listener listener<\/strong>
    \nListener LISTENER is enabled
    \nListener LISTENER is not running<\/code><\/p>\n

    Put default listener configuration<\/h4>\n

    grid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] mv listener.ora listener.ora.before_db_del_20200506<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] cp -p listener19071611AM2747.bak listener.ora<\/strong><\/code><\/p>\n

    Start the listener<\/h4>\n

    grid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl start listener -listener listener<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl status listener -listener listener<\/strong>
    \nListener LISTENER is enabled
    \nListener LISTENER is running on node(s): oda01<\/code><\/p>\n

    Delete database<\/h4>\n

    We will try to delete the database again by running the same odacli command :
    \n
    \n[root@ODA01 bin]# odacli delete-database -in TEST -fd<\/strong>
    \n{
    \n\"jobId\" : \"5655be19-e0fe-4452-b8a9-35382c67bf96\",
    \n\"status\" : \"Running\",
    \n\"message\" : null,
    \n\"reports\" : [ {
    \n\"taskId\" : \"TaskZJsonRpcExt_1167\",
    \n\"taskName\" : \"Validate db d6542252-dfa4-47f9-9cfc-22b4f0575c51 for deletion\",
    \n\"taskResult\" : \"\",
    \n\"startTime\" : \"May 06, 2020 11:45:01 AM CEST\",
    \n\"endTime\" : \"May 06, 2020 11:45:01 AM CEST\",
    \n\"status\" : \"Success\",
    \n\"taskDescription\" : null,
    \n\"parentTaskId\" : \"TaskSequential_1165\",
    \n\"jobId\" : \"5655be19-e0fe-4452-b8a9-35382c67bf96\",
    \n\"tags\" : [ ],
    \n\"reportLevel\" : \"Info\",
    \n\"updatedTime\" : \"May 06, 2020 11:45:01 AM CEST\"
    \n} ],
    \n\"createTimestamp\" : \"May 06, 2020 11:45:01 AM CEST\",
    \n\"resourceList\" : [ ],
    \n\"description\" : \"Database service deletion with db name: TEST with id : d6542252-dfa4-47f9-9cfc-22b4f0575c51\",
    \n\"updatedTime\" : \"May 06, 2020 11:45:01 AM CEST\"
    \n}<\/code><\/p>\n

    Unfortunately the deletion will fail with another error : DCS-10011:Input parameter ‘ACFS Device for delete’ cannot be NULL<\/em><\/strong>.<\/p>\n

    This is due to the fact that previous deletion has already removed the corresponding ACFS volume for the database (DATA and REDO). We will have to create them manually again. I have already described this solution in a previous post : Database deletion stuck in deleting-status<\/a>.<\/p>\n

    After restoring the corresponding ACFS Volume, we can retry our database deletion again :<\/p>\n

    [root@ODA01 bin]# odacli delete-database -in TEST -fd<\/strong>
    \n{
    \n\"jobId\" : \"5e227755-478b-46c5-a5cd-36687cb21ed8\",
    \n\"status\" : \"Running\",
    \n\"message\" : null,
    \n\"reports\" : [ {
    \n\"taskId\" : \"TaskZJsonRpcExt_1443\",
    \n\"taskName\" : \"Validate db d6542252-dfa4-47f9-9cfc-22b4f0575c51 for deletion\",
    \n\"taskResult\" : \"\",
    \n\"startTime\" : \"May 06, 2020 11:47:53 AM CEST\",
    \n\"endTime\" : \"May 06, 2020 11:47:53 AM CEST\",
    \n\"status\" : \"Success\",
    \n\"taskDescription\" : null,
    \n\"parentTaskId\" : \"TaskSequential_1441\",
    \n\"jobId\" : \"5e227755-478b-46c5-a5cd-36687cb21ed8\",
    \n\"tags\" : [ ],
    \n\"reportLevel\" : \"Info\",
    \n\"updatedTime\" : \"May 06, 2020 11:47:53 AM CEST\"
    \n} ],
    \n\"createTimestamp\" : \"May 06, 2020 11:47:53 AM CEST\",
    \n\"resourceList\" : [ ],
    \n\"description\" : \"Database service deletion with db name: TEST with id : d6542252-dfa4-47f9-9cfc-22b4f0575c51\",
    \n\"updatedTime\" : \"May 06, 2020 11:47:53 AM CEST\"
    \n}<\/code><\/p>\n

    Which this time will be successful :<\/p>\n

    [root@ODA01 bin]# odacli describe-job -i \"5e227755-478b-46c5-a5cd-36687cb21ed8\"<\/strong>
    \n 
    \nJob details
    \n----------------------------------------------------------------
    \nID: 5e227755-478b-46c5-a5cd-36687cb21ed8
    \nDescription: Database service deletion with db name: TEST with id : d6542252-dfa4-47f9-9cfc-22b4f0575c51
    \nStatus: Success<\/strong>
    \nCreated: May 6, 2020 11:47:53 AM CEST
    \nMessage:
    \n 
    \nTask Name Start Time End Time Status
    \n---------------------------------------- ----------------------------------- ----------------------------------- ----------
    \nValidate db d6542252-dfa4-47f9-9cfc-22b4f0575c51 for deletion May 6, 2020 11:47:53 AM CEST May 6, 2020 11:47:53 AM CEST Success
    \nDatabase Deletion May 6, 2020 11:47:53 AM CEST May 6, 2020 11:47:54 AM CEST Success
    \nUnregister Db From Cluster May 6, 2020 11:47:54 AM CEST May 6, 2020 11:47:54 AM CEST Success
    \nKill Pmon Process May 6, 2020 11:47:54 AM CEST May 6, 2020 11:47:54 AM CEST Success
    \nDatabase Files Deletion May 6, 2020 11:47:54 AM CEST May 6, 2020 11:47:54 AM CEST Success
    \nDeleting Volume May 6, 2020 11:48:01 AM CEST May 6, 2020 11:48:05 AM CEST Success
    \nDelete File Groups of Database TEST May 6, 2020 11:48:05 AM CEST May 6, 2020 11:48:05 AM CEST Success<\/code><\/p>\n

    Restore our customized listener configuration<\/h4>\n

    We can now restore our customized configuration as follows :<\/p>\n

    grid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl stop listener -listener listener<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl status listener -listener listener<\/strong>
    \nListener LISTENER is enabled
    \nListener LISTENER is not running
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] mv listener.ora.before_db_del_20200506 listener.ora<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl start listener -listener listener<\/strong>
    \n 
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] srvctl status listener -listener listener<\/strong>
    \nListener LISTENER is enabled
    \nListener LISTENER is running on node(s): oda01<\/code><\/p>\n

    We could also confirm that the listener started successfully by displaying the tnslsnr running processes :
    \n
    \ngrid@ODA01:\/u01\/app\/18.0.0.0\/grid\/network\/admin\/ [+ASM1] ps -ef | grep tnslsnr | grep -v grep<\/strong>
    \ngrid 14922 1 0 10:52 ? 00:00:00 \/u01\/app\/18.0.0.0\/grid\/bin\/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
    \ngrid 97812 1 0 12:07 ? 00:00:00 \/u01\/app\/18.0.0.0\/grid\/bin\/tnslsnr LISTENER -no_crs_notify -inherit<\/code><\/p>\n

    Updates from 13th of October 2020<\/h3>\n

    I recently had to delete databases again, and could test that restoring the default listener.ora configuration file is enough. There is no need to stop and start the listener to have the odacli delete-database command successes.<\/p>\n

    But I could see that the odacli command would anyhow restart a new listener process. I had 2 listener processes running :
    \ngrid@ODA01:\/u01\/app\/19.0.0.0\/grid\/network\/admin\/ [+ASM1] ps -ef | grep tnslsnr | grep -v grep
    \ngrid 13776 1 0 Sep03 ? 00:21:34 \/u01\/app\/19.0.0.0\/grid\/bin\/tnslsnr LISTENER -no_crs_notify -inherit
    \ngrid 13780 1 0 Sep03 ? 00:14:12 \/u01\/app\/19.0.0.0\/grid\/bin\/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
    \ngrid 65971 1 0 14:23 ? 00:00:00 \/u01\/app\/19.0.0.0\/grid\/bin\/tnslsnr LISTENER -no_crs_notify -inherit<\/code><\/p>\n

    Thus restarting the listener correctly and killing the unuseful one would be anyhow recommended.<\/p>\n

    Conclusion<\/h3>\n

    Starting ODA Release 18.5, database deletion will fail if the listener has been customized. Workaround is to to restore the listener default configuration for executing the deletion. This might imply for some customers to have a maintenance windows.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I have recently faced an issue deleting database on an ODA. I was getting following error whatever database I wanted to delete : DCS-10001:Internal error encountered: null. Through this blog, I would like to share with you my experience on this case hoping it will help you if you are facing same problem. On this […]<\/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":[43,79,1327,1956,96],"type_dbi":[],"class_list":["post-14194","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-listener","tag-oda","tag-odacli","tag-odacli-delete-database","tag-oracle"],"acf":[],"yoast_head":"\nIssue deleting a database on ODA? - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Issue deleting a database on ODA?\" \/>\n<meta property=\"og:description\" content=\"I have recently faced an issue deleting database on an ODA. I was getting following error whatever database I wanted to delete : DCS-10001:Internal error encountered: null. Through this blog, I would like to share with you my experience on this case hoping it will help you if you are facing same problem. On this […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-25T18:33:07+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=\"11 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\/issue-deleting-a-database-on-oda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Issue deleting a database on ODA?\",\"datePublished\":\"2020-05-25T18:33:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\"},\"wordCount\":632,\"commentCount\":0,\"keywords\":[\"Listener\",\"ODA\",\"odacli\",\"odacli delete-database\",\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\",\"name\":\"Issue deleting a database on ODA? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-05-25T18:33:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Issue deleting a database on ODA?\"}]},{\"@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":"Issue deleting a database on ODA? - dbi Blog","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\/issue-deleting-a-database-on-oda\/","og_locale":"en_US","og_type":"article","og_title":"Issue deleting a database on ODA?","og_description":"I have recently faced an issue deleting database on an ODA. I was getting following error whatever database I wanted to delete : DCS-10001:Internal error encountered: null. Through this blog, I would like to share with you my experience on this case hoping it will help you if you are facing same problem. On this […]","og_url":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/","og_site_name":"dbi Blog","article_published_time":"2020-05-25T18:33:07+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Issue deleting a database on ODA?","datePublished":"2020-05-25T18:33:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/"},"wordCount":632,"commentCount":0,"keywords":["Listener","ODA","odacli","odacli delete-database","Oracle"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/","name":"Issue deleting a database on ODA? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-05-25T18:33:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/issue-deleting-a-database-on-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Issue deleting a database on ODA?"}]},{"@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\/14194","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=14194"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14194\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14194"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}