Database Configuration - Practical Oracle Database Appliance - page 63

Listing 4-8. Select a Node for Installing an EE Database
Please select one of the following for Node Number [1 .. 2]:
1 => patty
2 => Selma
Once the single instance database installation is done, the database status can be viewed from the CRS stack
using the crsctl command. Listing 4-9 shows a sample of a CRS stack with a single instance.
Listing 4-9. Cluster Ready Services (CRS) Status for an EE Database
[grid@patty bin]$ ./crsctl status res -t
-------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
-------------------------------------------------------------------------------
Cluster Resources
-------------------------------------------------------------------------------
ora.bcsingle.db
1 ONLINE ONLINE patty Open
Database Deletion
We've just taken a look at how to create three different types of databases by using the oakcli command. What if you
want to remove a database from the Oracle Database Appliance? The oakcli command provides an option to do this
as well. As you reviewed at the beginning of the chapter, the oakcli command has a delete option.
The delete option of the oakcli command has the same command-line options as the create option. Listing 4-10
shows the available options.
Listing 4-10. oakcli Delete Options
[root@patty bin]# ./oakcli delete -h
Usage:
oakcli delete {database | dbhome | db_config_params} [<options>]
where:
database - deletes the database
dbhome - deletes the database home
db_config_params - deletes the database config parameter file
Now that you understand what the delete option can do, let's take a look at removing one of the databases that we
created earlier. To delete a database from the Oracle Database Appliance, issue the following:
[root@patty bin]# ./oakcli delete database -db bcodatst
When the delete option is invoked, you will be asked to provide the password for the root and oracle users.
The oakcli utility will then log in as those users, and connect by a secure shell (SSH) connection between the nodes
so that the database can be deleted. Listing 4-11 shows the complete output for removing a RAC database from the
Oracle Database Appliance.