Netsoftmate

Tag: oakcli delete

  • Delete Database On Oracle Database Appliance (ODA)

    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.