Creating the database for Oracle and Amazon RDS for Oracle for the Dynamic Workload Console

Instructions for creating and populating the Dynamic Workload Console database for Oracle and Amazon RDS for Oracle

Ensure the required tablespace for Dynamic Workload Console data has been already created on the Oracle database server which hosts the Dynamic Workload Console database.

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.

Default values are stored in the configureDbOracle.properties file, located in image_location. 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.

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

To create and populate the Dynamic Workload Console database, perform the following steps:

On the server where you plan to install the Dynamic Workload Console, extract the Dynamic Workload Console package to a directory of your choice.
Browse to the directory where you extracted the package.
Type the following command to populate the Dynamic Workload Console 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 
```
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
```
where:

--rdbmstype

The database vendor.

--dbname db_name

The service name of the Dynamic Workload Console database.

-–dbuser db_user

The user to be granted access to the Dynamic Workload Console tables on the database server.

--dbpassword db_password

The password for the user that has been granted access to the Dynamic Workload Console tables on the database server. Special characters are not supported.

--dbhostname db_hostname

The host name or IP address of database server.

--dbadminuserdb_admin_user

The database administrator user that creates the Dynamic Workload Console schema objects on the database server.

--dbadminuserpw db_admin_password

The password of the DB administrator user that creates the Dynamic Workload Console schema objects on the database server. Special characters are not supported.

--iwstsname|-tn table_space_name

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

You have now successfully created and populated the Dynamic Workload Console database.

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

You can now proceed to Installing the Dynamic Workload Console.