HCL Workload Automation, Version 9.4

Installing for an Oracle database

About this task

When you are installing for an Oracle database, both for server and client, follow the installation wizard prompts. The following list describes the fields that you might need to complete during the installation. Many of these fields are in common with the upgrade installation.

Database path

Specify the path of an Oracle installation that satisfies the HCL Workload Automation prerequisites. The fully qualified path must identify the Oracle path that includes the BIN folder containing the sqlplus executable file.

Net service 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 its backup, 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 its backup, 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 its backup, 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 its backup, 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.

Oracle administrator user

The database administrator user name (such as SYSTEM) required to authenticate to the Oracle database. This account must already exist.

If the ORACLE administrator already created the database tables using the procedure Creating or upgrading the database tables if you are using Oracle, the user name is the one that the ORACLE administrator specified in the MDL_USER property of the customizeORACLESQL.properties file.

Oracle administrator user password

The database administrator user password required to authenticate to the Oracle database.

HCL Workload Automation Oracle user

The owner of the HCL Workload Automation schema.

The name must comply with the Oracle naming rules.

If you are installing a:

Master domain manager: If you leave this field blank, this name is defaulted to <TWS_user>.
Master domain manager configured as backup: Enter the same name that you used in the master domain manager.
Dynamic domain manager: If you leave this field blank, this name is defaulted to <TWS_user>. Provide a name different from the one that you used when installing the master domain manager.
Dynamic domain manager configured as backup: Enter the same name that you used in the dynamic domain manager.

On a fresh installation of a:

Master domain manager: This user does not exist in the database. If this is not the case, it means that there is already a master domain manager or its backup instance pointing to the same database with this user name.
The installation process upgrades the current database schema to the new schema.
Dynamic domain manager: This user does not exist in the database. If this is not the case, it means that there is already a dynamic domain manager or its backup pointing to the same database with this user name.

If your existing instance is the current version, the installation process assumes that the schema is at the correct level and does not create the database objects (tables, views, clusters, procedures, indexes, and so on) for HCL Workload Automation.

Note:

If you identify an existing Oracle user as the HCL Workload Automation Oracle user, the installation process assumes that the configuration is complete and does not create the database objects for HCL Workload Automation. In this case, the installation completes successfully but you cannot use the database.

HCL Workload Automation Oracle user password

The password for the HCL Workload Automation Oracle user. It must comply with the Oracle naming rules.

Confirm the HCL Workload Automation Oracle user password

Confirm the password for the HCL Workload Automation Oracle user that you insert in the HCL Workload Automation Oracle user password field.

Create the HCL Workload Automation schema using the Oracle Partitioning option

Only for master domain manager and dynamic domain manager. 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. For more information about event-driven workload automation, see Overview.

Tablespace name

Only for master domain manager and dynamic domain manager. The name that identifies the table space where scheduling objects data, event rules data, job history runs data, and job statistics data is stored. This table space must have been previously created by the database administrator. The default for this field is USERS.

Plan tablespace name

Only for master domain manager and dynamic domain manager. The name that identifies the table space where planning data is stored. This table space must have been previously created by the database administrator. The default for this field is USERS.

Reports tablespace name

Only for master domain manager and dynamic domain manager. The name that identifies the table space where report data is to be stored. You can view the report data using the Dynamic Workload Console.

This table space must have been previously created by the database administrator. The default value for this field is USERS.

Temporary tablespace

Only for master domain manager and dynamic domain manager. The name that identifies the temporary table space. This table space must have been previously created by the database administrator. The default value for this field is TEMP.

Remote database host name or IP address :

(Only for an upgrade). The host name or IP address of the Oracle server.

Database port:

(Only for an upgrade). The port number of the Oracle server. The default value is 1521.

HCL Workload Automation database user password:

(Only for an upgrade) The password of the database user that accesses the HCL Workload Automation tables on the Oracle server.

Oracle net service name:

(Only for an upgrade). The Oracle net service name of the HCL Workload Automation database. The default is: ORCL.