HCL Workload Automation, Version 9.4

Customizing the properties file for Oracle

To customize the properties file, perform the following steps:
  1. From the eImage containing the master domain manager or the dynamic domain manager, open the following properties file:
    On Windows operating systems:
    <images_dir>\dbtools\customizeWinOracleSql.properties
    On UNIX and Linux systems:
    <images_dir>/dbtools/customizeUnixOracleSql.properties
    where: <images_dir> specifies the directory where you extracted the product image.
  2. Customize the SQL properties with the values appropriate for your needs:
    TWSTEMPDIR
    The directory where you want to store the SQL scripts to create the database tables. The default value is:
    On Windows operating systems:
    C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\TWA\tws
    On UNIX and Linux systems:
    /tmp/TWA/tws
    MDL_USER
    The Oracle user that will access the HCL Workload Automation database.
    TWS_PASSWORD
    The password of the MDL_USER.
    TWS_USER
    Specify the HCL Workload Automation user name.

    It can contain alphanumeric, dash (-), and underscore (_) characters; it cannot contain national characters. The first character of the user name must be a letter.

    When the IT administrator installs the product, he must specify this value in the User_name field.

    TWS_TS_NAME
    The name that identifies the HCL Workload Automation data table space. The default for this field is USERS.

    When the IT administrator installs the product, he must specify this value in the HCL Workload Automation data tablespace field.

    TWS_LOG_TS_NAME
    The name that identifies the HCL Workload Automation table space where report data is to be stored. You can view the report data by using the Dynamic Workload Console. The default value for this field is USERS.

    When the IT administrator installs the product, he must specify this value in the HCL Workload Automation reports tablespace field.

    TWS_TS_TEMP_NAME
    The name that identifies the HCL Workload Automation temporary table space. The default value for this field is TEMP.

    When the IT administrator installs the product, he must specify this value in the HCL Workload Automation temporary tablespace field.

    COMPANY_NAME
    The name of the company. You can use spaces and the maximum field length is 40 characters. The default is MYCOMPANY.

    When the IT administrator installs the product, he must specify this value in the Company field.

    EIF_PORT
    The port used by the event management processor to receive events. The valid range is from 1 to 65535. The default value is 31131.

    When the IT administrator installs the product, he must specify this value in the Event Processor field.

    HOST_NAME
    The fully qualified host name or IP address on which the dynamic domain manager is contacted by the dynamic agent.

    When the IT administrator installs the product, he must specify this value in the dynamic agent configuration information Host name or IP address field.

    WAS_SEC_PORT
    The HTTPS port of the dynamic workload broker. The dynamic agent uses it to connect to the dynamic workload broker. The valid range is from 1 to 65535. The default value is 31116. If you leave the field blank, it defaults to 0.

    When the IT administrator installs the product, he must specify this value in the dynamic workload brokerHTTPS port number field.

    ORACLE_HOME
    Specify the path of the Oracle installation.