Customizing the properties file for Oracle
- From the installation DVD or 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
- 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\tws92
- On UNIX and Linux systems:
- /tmp/TWA/tws92
- MDL_USER
- The database administrator
user name (such as SYSTEM) that accesses the Tivoli Workload Scheduler and the dynamic workload broker database. It is a user that must be created on Oracle; it is not
an operating system user.
When the IT administrator installs the product, he must specify this value in the Oracle administrator user field.
- TWS_PASSWORD
- The
password of the MDL_USER.
When the IT administrator installs the product, he must specify this value in the Oracle administrator user password field.
- TWS_USER
- Specify the Tivoli® Workload Scheduler 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 Tivoli Workload Scheduler data table space. The default for this field is USERS.
When the IT administrator installs the product, he must specify this value in the Tivoli Workload Scheduler data tablespace field.
- TWS_LOG_TS_NAME
- The name that identifies the Tivoli Workload Scheduler 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 Tivoli Workload Scheduler reports tablespace field.
- TWS_TS_TEMP_NAME
- The name that identifies the Tivoli Workload Scheduler 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 Tivoli Workload Scheduler 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 Tivoli dynamic workload broker. The dynamic agent uses it to connect to the Tivoli 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.