Oracle EXADATA X6-2

2. List the databases contained in the XML configuration file, so that you can identify
the database ID associated with the database you want to delete.
oedacli> LIST DATABASES
version : "2"
databaseOwner : "c0_oracle"
databaseSid : "dbm01"
databaseBlockSize : "8192"
characterset : "AL32UTF8"
databaseHome :
id : "c0_databaseHome"
machines :
machine :
.....
.....
diskGroups :
diskGroup :
id : "c0_datadg"
id : "c0_recodg"
id : "c0_dbm01"
.....
.....
databaseHome :
id : "c0_databaseHome3"
machines :
machine :
....
....
databaseTemplate : "OLTP"
databaseStyle : "ADMIN"
language : "all_langs"
diskGroups :
diskGroup :
id : "c0_datadg"
id : "c0_recodg"
id : "c0_testdb01"
3. Create an action to delete the target database. Use the database id identified in
the previous step
oedacli> delete database where id='c0_testdb01'
4. Save the action.
oedacli> SAVE ACTION
5. Merge all actions.
oedacli> MERGE ACTIONS
processMerge
processMergeActions
Merging Action : delete database where id='c0_testdb01'
Merging DELETE DATABASE
Action Validated and Merged OK
6. Deploy the actions into the current configuration.
oedacli> DEPLOY ACTIONS
Deploying Action ID : 1 delete database where id='c0_testdb01'
Deploying DELETE DATABASE
Deleting database testdb
Done...
Done
Chapter 3
OEDA Command Line Interface
3-52