Using OEDA Utility – Oracle Exadata Deployment Assistant

To create databases on Exadata, Oracle recommends using Oracle Exadata Deployment Assistant (OEDA) or the OEDA Command Line Utility (OEDACLI), as both utilities implement the latest Exadata best-practice configuration settings for your Exadata system configuration. The Oracle Database Configuration Assistant (DBCA) is also available in the Oracle Database software bundle. However, DBCA is not recommended for new database creation on Exadata because it does not integrate with the OEDA XML configuration file (es.xml) and may not implement the recommended Exadata-specific configuration settings.

Starting with August 2017 Release of Oracle Exadata Deployment Assistant (OEDA), a command-line utility — oedacli — can be used for various routine tasks on Exadata

You can use the OEDA command-line interface (OEDACLI) to perform Exadata life cycle management tasks.

Supported tasks include:

• Add nodes to and remove nodes from a VM cluster
• Add or remove Oracle Database home directories
• Add or remove storage cells
• Resize Oracle ASM disk groups
• Add or remove additional databases

Adding a New Oracle Database Using OEDACLI

This example shows how to add a new database to the configuration.

Load the OEDA XML configuration file.

oedacli> LOAD FILE NAME=Oracle-test.xml
SUCCESS – file loaded OK
Customer : ora07adm01 – Oracle
Use the command LIST DATABASEHOMES to identify the databasehome_id associated with the target database home. This database home will be used to create the new database.

oedacli> LIST DATABASEHOMES
version : “CloneInstall”
cluster :
id : “c0_clusterHome”
databaseHomeName : “c0_DbHome_0”
databaseSwOwner : “c0_oracle”
databaseVersion : “12.2.0.1.170718”
databaseHomeLoc : “/u01/app/oracle/product/12.2.0.1/dbhome_1”
inventoryLocation : “/u01/app/oraInventory”
language : “all_langs”
machines :
machine : …
…
patches :
patch :
patchNumber : “26133434”
basedir : “/u01/app/oracle”
useZfs : “false”
id : “c0_databaseHome1”
Create an action for creating the new database. You must provide a name for the new database, and the names of the DATA and RECO disk groups that the new database should use. Also, use the ID retrieved in the previous step to specify the Oracle Home in which to create this database.

oedacli> ADD DATABASE DBNAME=’testdb’ DATADG=’DATAC1′ RECODG=’RECOC1′
WHERE DBHOMEID=’c0_databaseHome’
Save the action.

oedacli> SAVE ACTION
Merge all actions.

oedacli> MERGE ACTIONS
processMerge
processMergeActions
Merging Action : add database dbname=’testdb’ DATADG=’DATAC1′ RECODG=’RECOC1′
where DBHOMEID=’c0_databaseHome’
Merging ADD DATABASE
Action Validated and Merged OK
Save the action to a new Engineered Systems XML configuration file.

oedacli> SAVE FILE NAME =’cli-test-2databases.xml’
File : cli-test-2databases.xml saved OK
Deploy the actions.

oedacli> DEPLOY ACTIONS
Deploying Action ID : 4 add database dbname=’testdb’ DATADG=’DATAC1′ RECODG=’
RECOC1′ where DBHOMEID=’c0_databaseHome’
Deploying ADD DATABASE
Running datapatch on database ‘testdb’
Done…
Done