Procedure to upgrade the HCL Workload Automation SQL tables for Oracle
To upgrade the HCL Workload Automation database,
perform 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\TWS\dbtools\ora\scripts
- On UNIX and Linux operating systems:
- TWSTEMPDIR/TWA/tws94/TWS/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 <TWS_DB> <TWS_USER> <TWS_USER_PW> <IS_PARTITIONED>
- On UNIX and Linux operating systems:
migratedb_root.sh <TWS_DB> <TWS_ADMIN_USER> <TWS_ADMIN_PW> <IS_PARTITIONED>
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. It must comply with the Oracle naming rules.
- <IS_PARTITIONED>
- If you are installing on Oracle Enterprise Edition, you can choose to implement the Oracle Partitioning option to improve the performance of event-driven workload automation. The possible values are false (Oracle Partitioning feature is not used when creating the HCL Workload Automation schema) or TRUE (Oracle Partitioning feature is used when creating the HCL Workload Automation schema). The default is TRUE.