Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
You want to drop a database on Oracle Database Appliance (ODA) that is no more required or used. Use the “oakcli delete database” command to delete a database from ODA.



In this article we will demonstrate how to delete a database on Oracle Database Appliance.

Steps to Delete Database on ODA

Step 1: List the database currently running on ODA

[root@odanode01 ~]# oakcli show databases
Name     Type       Storage   HomeName             HomeLocation                               Version                     
—–    ——     ——–  ————–       —————-                           ———-                  
newdb    RAC        ACFS      OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1  12.1.0.2.170117(24732082,24828633)
odatest  RAC        ACFS      OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1  12.1.0.2.170117(24732082,24828633)

Step 2: Get the syntax to delete the database

[root@odanode01 ~]# oakcli delete database -h
Usage:
        oakcli delete database  -db  <db_name>

     where:
      db_name      –    name of the database  to be deleted

Step 3: Execute the “oakcli delete database” command to delete the database

[root@odanode01 ~]# oakcli delete database -db newdb
INFO: 2018-04-22 15:28:56: Look at the log file ‘/opt/oracle/oak/log/odanode01/tools/12.1.2.10.0/deletedatabase_newdb_39297.log’ for 

more details

Please enter the ‘root’  password :
Please re-enter the ‘root’ password:

Please enter the ‘SYS’  password :
Please re-enter the ‘SYS’ password:
INFO: 2018-04-22 15:29:30: Setting up SSH
…………Completed
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/opt/oracle/oak/onecmd –exclude=*zip –exclude=*gz —

exclude=*log –exclude=*trc –exclude=*rpm and it returned: RC=0

……….Completed
……
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2018-04-22 15:31:06: SSH has been successfully established
INFO: 2018-04-22 15:33:04: Successfully deleted the database ‘newdb’
INFO: 2018-04-22 15:33:09: Attempting to cleanup the SNAP entries for the database: newdb
INFO: 2018-04-22 15:33:09: Successfully deleted the SNAP entries

Step 4: Verify that the database is dropped

[root@odanode01 ~]# oakcli show databases
Name     Type       Storage   HomeName             HomeLocation                                Version                     
—–    ——     ——–  ————–       —————-                            ———-                  
odatest  RAC        ACFS      OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1   12.1.0.2.170117(24732082,24828633)

Conclusion

In this article we have learned how to Delete database on Oracle Database Appliance (ODA). Using oakcli delete database database is extremely simple and easy to drop a database which otherwise required to use database utilities like DBCA or SQL command to drop the database.

0