HCL Workload Automation, Version 9.4

Procedure to upgrade the dynamic workload broker SQL tables for Oracle

To upgrade the dynamic workload broker database, run the following steps:

Log on as Administrator on Windows operating systems and as root on UNIX and Linux operating systems.
Go to the following directory:
On Windows operating systems:

TWSTEMPDIR\TWA\tws94\TDWB\dbtools\ora\scripts

On UNIX and Linux operating systems:

TWSTEMPDIR/TWA/tws94/TDWB/dbtools/ora/scripts

Where TWSTEMPDIR is the directory you specified in the TWSTEMPDIR property of the configuration file. For more information about how to customize the property file, see Customizing the properties file for Oracle.
Run the following command:
On Windows operating systems:
```
migratedb_root.bat 
<ORACLE_NETSERVICE_NAME> <TWS_DB_USER> 
<TWS_DB_PW> <TWS_IS_DDM>
<TWS_IS_BDM>
```
On UNIX and Linux operating systems:
```
migratedb_root.sh 
<ORACLE_NETSERVICE_NAME> <TWS_DB_USER> 
<TWS_DB_PW> <TWS_IS_DDM>
<TWS_IS_BDM>
```
Where:
<ORACLE_NETSERVICE_NAME>
The name used by clients to identify an Oracle Net server and the specific system identifier or database for the Oracle Net connection. A net service name is mapped to a port number and protocol. It is also known as a connect string, database alias, host string, or service name.
If your Oracle database is:
Installed on the same system on which you are installing your master domain manager or a backup master domain manager, the net service name is the name of your Oracle database.

Installed on the same system on which you are installing your dynamic domain manager or a backup dynamic domain manager, the net service name is the name of your Oracle database.

Not installed on the system on which you are installing your master domain manager or a backup master domain manager, the net service name is the alias configured for the connection to the remote database.

Not installed on the system on which you are installing your dynamic domain manager or a backup dynamic domain manager, the net service name is the alias configured for the connection to the remote database.
Contact your database administrator to obtain the correct net service name.
<TWS_DB_USER>

The HCL Workload Automation Oracle user name that is the owner of the HCL Workload Automation schema.

<TWS_DB_PW>

The password for the HCL Workload Automation Oracle user.

<TWS_IS_DDM>

Specify if the HCL Workload Automation agent is a dynamic domain manager. Possible values are TRUE or FALSE.
Note: If you are managing a master domain manager or a backup dynamic domain manager, set the value to FALSE.

<TWS_IS_BDM>

Specify if the HCL Workload Automation agent is a backup dynamic domain manager. Possible values are TRUE or FALSE.
Note: If you are managing a master domain manager or a dynamic domain manager, set the value to FALSE.