Delete database on Oracle Database Appliance x6-2 Small,Medium and Large

This document describe step by step procedure to delete database in command line on Oracle Database Appliance x6-2 Small,Medium and Large .


1. list the databases to see the existing databases.

[root@oak ~]# odacli list-databases

ID                                       DB Name    DB Version           CDB        Class    Shape    Storage    Status
---------------------------------------- ---------- -------------------- ---------- -------- -------- ---------- ----------
63079e59-9239-45ad-8eef-822179fa3ccc     testdb     12.1.0.2             false      OLTP     odb1     ACFS       Configured

2. Execute the delete database to delete the database. use ID from list databases output.

[root@oak ~]# odacli delete-database -i 63079e59-9239-45ad-8eef-822179fa3ccc
{
  "jobId" : "985f1bb1-303d-47ae-b1c7-3802649f9e45",
  "status" : "Running",
  "message" : null,
  "reports" : [ {
    "taskId" : "TaskZJsonRpcExt_3600",
    "taskName" : "Database Deletion",
    "taskResult" : "Running",
    "startTime" : "June 15, 2017 18:13:03 PM PHT",
    "endTime" : "June 15, 2017 18:13:03 PM PHT",
    "status" : "Running",
    "taskDescription" : null,
    "parentTaskId" : "TaskSequential_3595",
    "jobId" : "985f1bb1-303d-47ae-b1c7-3802649f9e45",
    "tags" : [ ],
    "reportLevel" : "Info",
    "updatedTime" : "June 15, 2017 18:13:03 PM PHT"
  } ],
  "createTimestamp" : "June 15, 2017 18:13:03 PM PHT",
  "resourceList" : [ ],
  "description" : "Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc",
  "updatedTime" : "June 15, 2017 18:13:03 PM PHT"
}

3. Describe the job to see the deletion job status.

[root@oak ~]# odacli describe-job -i 985f1bb1-303d-47ae-b1c7-3802649f9e45

Job details
----------------------------------------------------------------
                     ID:  985f1bb1-303d-47ae-b1c7-3802649f9e45
            Description:  Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc
                 Status:  Running
                Created:  June 15, 2017 6:13:03 PM PHT
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database Deletion                        June 15, 2017 6:13:03 PM PHT        June 15, 2017 6:13:03 PM PHT        Running

4. Describe the job to see the deletion job status,if conpleted successfully.


[root@oak ~]# odacli describe-job -i 985f1bb1-303d-47ae-b1c7-3802649f9e45

Job details
----------------------------------------------------------------
                     ID:  985f1bb1-303d-47ae-b1c7-3802649f9e45
            Description:  Database service deletion with db name: testdb with id : 63079e59-9239-45ad-8eef-822179fa3ccc
                 Status:  Success
                Created:  June 15, 2017 6:13:03 PM PHT
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database Deletion                        June 15, 2017 6:13:03 PM PHT        June 15, 2017 6:13:54 PM PHT        Success
Unregister Db From Cluster               June 15, 2017 6:13:54 PM PHT        June 15, 2017 6:13:54 PM PHT        Success
Kill Pmon Process                        June 15, 2017 6:13:54 PM PHT        June 15, 2017 6:13:54 PM PHT        Success
Database Files Deletion                  June 15, 2017 6:13:54 PM PHT        June 15, 2017 6:13:55 PM PHT        Success
Deleting Volume                          June 15, 2017 6:14:07 PM PHT        June 15, 2017 6:14:09 PM PHT        Success

5. List the databases again to verify the existing databases.

[root@oak ~]# odacli list-databases