•
HOSTNAMES
: Specifies a comma-separated list of host names on which the database
should run. The default value is the list of nodes registered with the database
home.
•
RECODG
: (Mandatory) Specifies the name of the RECO disk group for the new
database. This argument is not required for pluggable databases.
The following arguments are available in the
WHERE
clause:
•
DBHOMEID
: Specifies the
es.xml
ID of the database home.
•
CLUSTERNUMBER
: Specifies the cluster number in the
es.xml
, starting at 1
•
CLUSTERNAME
: Specifies the name of the cluster
•
CLUSTERID
: Specifies the
es.xml
ID of the cluster
•
DBHOMELOCATION
: Specifies the path for the target database home.
•
CDBNAME
: Specifies the database name for the container database. This argument
is required only when
DBTYPE
is set to PDB.
Example 3-8 Adding a New Oracle Database Using OEDACLI
This example shows how to add a new database to the configuration.
1.
Load the OEDA XML configuration file.
oedacli> LOAD FILE NAME=Oracle-test.xml
SUCCESS - file loaded OK
Customer : ora07adm01 - Oracle
2.
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"
3.
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'
4.
Save the action.
Chapter 3
OEDA Command Line Interface
3-49
