Creating the database for Oracle for the master domain manager

Before you begin

Ensure the following required tablespaces have been already created on the Oracle database server which hosts the master domain manager database:

tablespace for HCL Workload Automation data
tablespace for HCL Workload Automation log
tablespace for HCL Workload Automation plan

About this task

This picture describes the steps required for installing the master domain manager. You are now at step 3: creating and populating the HCL Workload Automationdatabase

You can perform a typical database procedure, as described in the following scenarios, or you can customize the database parameters, as described in FAQ - Database customizations.

You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.

Default values are stored in the configureDbOracle.properties file, located in image_location/TWS/interp_name.

If you need to modify any of the default values, edit the configureDbOracle.properties file, but do not modify the configureDbOracle.template file located in the same path.

To create and populate the HCL Workload Automation database and schema, perform the following steps:

Procedure

On the server where you plan to install the master domain manager, extract the HCL Workload Automation package to a directory of your choice.
Browse to image_location/TWS/interp_name.
Type the following command to create and populate the HCL Workload Automation database with typical settings:
On Windows operating systems
```
cscript configureDb.vbs --rdbmstype ORACLE --dbname service_name 
-–dbuser db_user --dbpassword DB_password --dbhostname DB_hostname 
--dbadminuser DB_administrator --dbadminuserpw DB_administrator_password
--iwstsname USERS --iwslogtsname USERS --iwsplantsname USERS
```
On UNIX operating systems
```
./configureDb.sh --rdbmstype ORACLE --dbname service_name
-–dbuser db_user --dbpassword DB_password --dbhostname DB_hostname 
--dbadminuser DB_administrator --dbadminuserpw DB_administrator_password
--iwstsname USERS --iwslogtsname USERS --iwsplantsname USERS 
```
where:

--rdbmstype

The database vendor.

--dbhostname db_hostname

The host name or IP address of database server.

--dbport db_port

The port of the database server.

--dbname db_name

The service name of the HCL Workload Automation database.

dbuser db_user

The user to be granted access to the HCL Workload Automation tables on the database server.

--dbpassword db_password

The password for the user that has been granted access to the HCL Workload Automation tables on the database server.

--dbadminuserdb_admin_user

The database administrator user that creates the HCL Workload Automation schema objects on the database server.

--dbadminuserpw db_admin_password

The password of the DB administrator user that creates the HCL Workload Automation schema objects on the database server.

--iwstsname|-tn table_space_name

The name of the tablespace for HCL Workload Automation data. This parameter is required.

--iwslogtsname|-ln log_table_space

The name of the tablespace for HCL Workload Automation log. This parameter is required.

--iwsplantsname|-pn plan_table_space

The name of the tablespace for HCL Workload Automation plan. This parameter is required.
Note: The following parameters specified with the configureDb command are also required when installing the server components and their values must be the same:
- rdbmstype
- dbhostname
- dbport
- dbname
- dbuser
- dbpassword

Results

You have now successfully created and populated the HCL Workload Automation database.

You can now proceed to Creating the database for Oracle for the Dynamic Workload Console.