•
DBVERSION
: (Mandatory) Specifies the version of the software in the database
home, including the bundle patch, for example 12.1.0.2.170418.
•
DBHOMELOC
: (Mandatory) Specifies the file system path for the new Oracle database
home directory.
•
DBHOMENAME
: Specifies the name of the new database home. The default value is
the standard template name, for example,
dbhome_1
.
•
INVLOC
: Specifies the location of the Oracle inventory directory. The default value
is derived from the cluster home.
•
DBLANG
: Specifies the language to use with the Oracle home. The default value is
all_langs
.
•
MACHINELIST
: Specifies a list of nodes to create the Oracle home on. The default
value is list of nodes registered with the Grid home.
•
PATCHLIST
: Specifies a comma-separated list of patches for the database home.
The default value is derived from
DBVERSION
.
•
BASEDIR
: Specifies the location of the Oracle Base directory. The default value is
derived from
OWNER
.
•
VOLUMESIZE
: Specifies the size of the home directory volume. The default value is
50 GB. This argument is applicable only for database homes for Oracle VM
clusters.
The following arguments are available in the
WHERE
clause:
•
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
Example 3-10 Adding a Database Home to a Deployment using OEDACLI
This example shows how to add a new Oracle home.
dbversion
should specify both
the base version and the target Bundle Patch version. In this example, we are setting
up a new Oracle database home with 12.1.0.2 DBBP 170418. The software will be
installed under /u01/app/oracle/product/12.1.0.2/dbhome_2.
./oedacli
oedacli> LOAD FILE NAME=Oracle-test12.xml
SUCCESS - file loaded OK
Customer : ora07adm01 - Oracle
oedacli> ADD DATABASEHOME OWNER='oracle' DBVERSION='12.1.0.2.170418' DBHOMELOC='/u0
1/app/oracle/product/12.1.0.2/dbhome_2' WHERE CLUSTERNUMBER=1
oedacli> SAVE ACTION
oedacli> MERGE ACTIONS
processMerge
processMergeActions
Merging Action : add databasehome owner='oracle' dbversion='12.1.0.2.170418'
dbhomeloc='/u01/app/oracle/product/12.1.0.2/dbhome_2' where clusternumber=1
Merging ADD DATABASEHOME
Action Validated and Merged OK
oedacli> DEPLOY ACTIONS
Deploying Action ID : 1 add databasehome owner='oracle' dbversion='12.1.0.2.170418'
Chapter 3
OEDA Command Line Interface
3-54