ODA: "odacli delete-database -i" Command Is Not Working, Still Shows "Deleting", "odacli list-dbhomes" or "odacli list-dbstorages" Also Could Report "Deleting" / "Creating" in ODA X6-2 S/M/L

Asset ID:	1-72-2264382.1
Update Date:	2017-09-13
Keywords:

Solution Type Problem Resolution Sure

Solution 2264382.1 : ODA: "odacli delete-database -i" Command Is Not Working, Still Shows "Deleting", "odacli list-dbhomes" or "odacli list-dbstorages" Also Could Report "Deleting" / "Creating" in ODA X6-2 S/M/L

Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

Please contact ODA Tier-1 or ODA DEV to assist on the solution for this issue

"odacli delete-database -i" command is not working, it is still showing Status = "Deleting" in ODA Lite:

[root@asmcloud0 ]# odacli list-databases

ID DB Name DB Version CDB Class Shape Storage Status
---------------------------------------- ---------- ------------------------------ -------- -------- ---------- ----------
9639046e-5a58-4322-ab34-23c7be8df031 PROD1 12.1.0.2 false OLTP odb8 ACFS Deleting
a476e3ae-fc6c-4381-b44f-9c1d0b1c3efb HRDB 12.1.0.2 false OLTP odb8 ACFS Configured
539a42eb-c7ea-4421-9aea-9bed20819075 DBTEST1 12.1.0.2 false OLTP odb8 ACFS Configured
c65d4fa8-ad81-4b1b-b76a-f064e3aa6794 DBTEST2 12.1.0.2 false OLTP odb8 ACFS Configured

[root@asmcloud0 ]# odacli delete-database -i
9639046e-5a58-4322-ab34-23c7be8df031
{
"jobId" : "dd32bd00-147c-4b54-8bd2-8e5b99615601",
"status" : "Running",
"message" : null,
"reports" : [ {
"taskId" : "TaskZJsonRpcExt_1004",
"taskName" : "Database Deletion",
"taskResult" : "Running",
"startTime" : "March 16, 2017 10:39:41 AM BRT",
"endTime" : "March 16, 2017 10:39:41 AM BRT",
"status" : "Running",
"taskDescription" : null,
"parentTaskId" : "TaskSequential_999",
"jobId" : "dd32bd00-147c-4b54-8bd2-8e5b99615601",
"tags" : [ ],
"reportLevel" : "Info",
"updatedTime" : "March 16, 2017 10:39:41 AM BRT"
} ],
"createTimestamp" : "March 16, 2017 10:39:41 AM BRT",
"resourceList" : [ ],
"description" : "Database service deletion with db name: PROD1 with id :
9639046e-5a58-4322-ab34-23c7be8df031",
"updatedTime" : "March 16, 2017 10:39:41 AM BRT"
}

[root@asmcloud0 ]# odacli describe-job -i
dd32bd00-147c-4b54-8bd2-8e5b99615601

Job details
----------------------------------------------------------------
ID: dd32bd00-147c-4b54-8bd2-8e5b99615601
Description: Database service deletion with db name: PROD1 with
id : 9639046e-5a58-4322-ab34-23c7be8df031
Status: Failure
Created: March 16, 2017 10:39:41 AM BRT
Message: Fail to run command Failed to delete the filesystem datPROD1

Task Name Start Time End Time Status
---------------------------------------- ---------------------------------------------------------------------- ----------
Database Deletion March 16, 2017 10:39:41 AM BRT March 16, 2017 10:39:41 AM BRT Success
Unregister Db From Cluster March 16, 2017 10:39:41 AM BRT March 16, 2017 10:39:41 AM BRT Success
Kill Pmon Process March 16, 2017 10:39:41 AM BRT March 16, 2017 10:39:41 AM BRT Success
Database Files Deletion March 16, 2017 10:39:41 AM BRT March 16, 2017 10:39:41 AM BRT Success
Deleting FileSystem March 16, 2017 10:39:43 AM BRT March 16, 2017 10:39:45 AM BRT Failure

Note: This problem could occur on the dbhomes and/or dbstorages, for example:

[root@]# odacli list-dbhomes

ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
24712878-b58d-421c-bfac-42c2e77d768b OraDB12102_home1 12.1.0.2.170418 (25817230, 25397136) /u01/app/oracle/product/12.1.0.2/dbhome_1 Configured
acfb0183-3db3-4ad6-818a-c18f340600dd OraDB11204_home1 11.2.0.4.170418 (23054319, 24732075) /u01/app/oracle/product/11.2.0.4/dbhome_1 Configured
f0cc08a2-d39d-4d5e-970b-db2c0f1f3f4c OraDB11204_home2 11.2.0.4.170418 (23054319, 24732075) /u01/app/oracle/product/11.2.0.4/dbhome_2 Deleting <(===== Here
d4015fbe-0595-4839-a96e-311f9dd3fbfc OraDB11204_home2 11.2.0.4.170418 /u01/app/oracle/product/11.2.0.4/dbhome_2 Creating <(===== Here
ce6a4785-d14e-407f-b435-861f53c0b546 OraDB11204_home2 11.2.0.4.170418 /u01/app/oracle/product/11.2.0.4/dbhome_2 Creating <(===== Here
bc5f0441-49f3-4e47-aeb5-823851028456 OraDB11204_home4 11.2.0.4.170418 (23054319, 24732075) /u01/app/oracle/product/11.2.0.4/dbhome_4 Configured

[root@]# odacli list-dbstorages

ID Type DBUnique Name Status
---------------------------------------- ------ -------------------- ----------
c12c0446-ec3d-4cce-84c3-07c7e1f587d7 Acfs hroda3 Configured
b9e68ea1-136a-45f2-84c4-78d7bccea920 Acfs hroda2 Creating <(===== Here
ea1af911-b4f9-4566-b844-b9bd17f0800e Acfs hroda1 Configured
5556dd77-eeba-4397-aac4-7a0d6a728114 Acfs oda01 Creating <(===== Here
26a61b5b-01af-4c4e-a0a1-d3ddb5186489 Acfs oda01 Creating <(===== Here
e9c60582-3e1d-4c84-a1e9-6d945ba8aa9f Acfs oda01 Creating <(===== Here

Cause

This problem is due to the following bugs (fixed in "12.1.2.11.0" ODA release):

Bug:25556947 - DATABASE HAS STATUS DELETING ALTHOUGH IT DOES NOT EXIST ANYMORE
Bug:25176658 - UNABLE TO DELETE DATABASE FROM ODA X6-2S USING ODACLI DELETE-DATABASE COMMAND
Bug:25735427 - ODACLI DELETE-DATABASE -I IS NOT WORKING STILL SHOWS DELETING
Bug:24299961 - FAIL TO DELETE THE DATABASE WITH STATUS FAILED

Solution

Please open a new ticket (Service Request) with Oracle Support, therefore we will be glad to assist you fixing this/these inconsistencies.

Community Discussions ODA

Still have questions? Use the communities window below to search for similar discussions or start a new discussion on this subject. (Window is the live community not a screenshot)

Click here to open in main browser window

References

<BUG:25735427> - ODACLI DELETE-DATABASE -I IS NOT WORKING STILL SHOWS DELETING : 3-14111977981
<BUG:25556947> - DATABASE HAS STATUS DELETING ALTHOUGH IT DOES NOT EXIST ANYMORE
<BUG:25176658> - UNABLE TO DELETE DATABASE FROM ODA X6-2S USING ODACLI DELETE-DATABASE COMMAND
<BUG:24299961> - BMIAAS-RAC: FAIL TO DELETE THE DATABASE WITH STATUS FAILED
/opt/oracle/dcs/log/

Attachments

This solution has no attachment