Innovative ideas for every utility

UTA - Installation Summary

Anthony Shorten
Senior Principal Product Manager

The installation of an on-premise version of Utilities Testing Accelerator (UTA) has been improved upon in both versions and to allow customers to quickly establish product environments. This article is a summary of this process, which is also outlined in the Oracle Utilities Testing Accelerator installation Guides.


Before installing there are a number of prerequisites necessary for the installation:

  • Database. The database to house the Utilities Testing Accelerator objects must be available and accessible to the server you want to install Utilities Testing Accelerator upon. This an be local or remote and can be a separate schema or a PDB in the same location as the Oracle Utilities product. Utilities Testing Accelerator supports the UTA Repository as a separate schema existing on a PDB or non-PDB database or even as a separate PDB on the Multi-tenant database. It does not require any database access to the Oracle Utilities products it is being used against.

Note: The Oracle Utilities Testing Accelerator does not ship with a database license and reuses the existing database license for supported Oracle Utilities products. Customers with Unlimited License Agreement licenses for the Oracle Database have lesser restrictions in this regard.

  • Java. The Java JDK or JRE must be installed on the machine that will house Utilities Testing Accelerator. A Java support license is included with all Oracle products including Oracle Utilities Testing Accelerator.
  • XWindows. The Oracle installer used by the Oracle Utilities Testing Accelerator uses XWindows. This is the same installer used by Oracle Database and Oracle WebLogic and a host of other Oracle products so staff familiar with those products will be familiar with the installer.

Note: XWindows may be directly invoked or via a virtualization such as vnc according to your site standards.

Installation Process

After downloading the software from Oracle Software Delivery Cloud, the following steps are performed:

  • Create Database Resources. Create the Oracle Utilities Testing Accelerator schema user (UTA) and tablespaces in the database to house the UTA Repository objects using the database tool of your choice as per the installation guide. The installation guide outlines the minimum setup for the Oracle Utilities Testing Accelerator. Alter as your site standards. Remember the database settings used as the installer will ask you for them later. Create the following:
Data Tablespace
CREATE TABLESPACE uta_data DATAFILE '<datafile>' SIZE 500M AUTOEXTEND ON NEXT 200M MAXSIZE 1024M DEFAULT STORAGE ( INITIAL 10M NEXT 1M pctincrease 10 ) permanent online logging;

where <datafile> is the location and filename in Oracle database to store the Oracle Utilities Testing Accelerator repository.

Index Tablespace

where <indexfile> is the location and filename in Oracle database to store the Oracle Utilities Testing Accelerator repository.

  • Execute the Installer. Within XWindows as an appropriate user (usually the same user used to install Oracle Utilities products), execute the installer command. If this command fails, examine the logs and correct the error. The command to start the installer is as follows:

java -jar UTA_6.

Step By Step Installer process

The following section outlines the installer process step by step:

  • The Welcome Page is displayed outlining the steps that the installer will follow. Click Next to start the process. For example:

Welcome Page

  • Inventory Location. As per Oracle products provide the location of the Inventory directory and the group used for the installer. This will default to the group used by the user that initiated the install but can be altered to a group you desire. Click Next after providing the information. For example:

Inventory Location

  • Installation Location. Provide the directory you want to install the product into. This is effectively the UTA home directory. Click Next after specifying a location. For example:

Installation Location

  • Java Home and Application Details. Provide the following information as requested by the installer:
    • Java Home. Home location of the java JDK/JRE for use with Oracle Utilities Testing Accelerator. This will default to the location used for the installer but may reference other java installations if required.
    • Application Server Port. The port number to be used by the Oracle Utilities Testing Accelerator. Default: 8082.
    • Application Administrator User Name. The default user for the administrator. This is the initial user used to create other users. Default: system
    • Application Administrator User Password. The password (and confirmation password) for the Application Administrator User Name.

Note: This is NOT the database system user. It is a user defined to the Utilities Testing Accelerator product.

Java Home and Application Details

Click Next after specifying the information.

  • Application Keystore Details. As with all Oracle products, the Oracle Utilities Testing Accelerator is installed in secure by default mode. For this to occur a default keystore needs to be generated as part of the process. The information provided generates a unique key used by UTA for communications and encrpytion. Therefore the following information, used by the keytool utility for X.500 generation, via the RFC1779 standard, needs to be provided.
    • Common Name. Name of the organization, machine name (for machine scoped installs) or company root website name. For example: utility.com
    • Organization Unit. Name of Unit associated with use of Utilities Testing Accelerator.
    • Organization Name. Name of company (not web site name)
    • City. Name of Suburb or city.
    • State. Name of State
    • Country Code. The ISO-3166 2 character country code. Default: US (for USA). For other codes, refer to the ISO standard.
    • Keystore Password. Password (and confirmation) to secure keystore. This is used by the product to access the keystore.

Note: It is possible to replace the keystore after installation if your site has a company keystore. Refer to the Utilities Testing Accelerator documentation for post installation steps on how to replace the default keystore and use advanced keystore attributes.

Application Keystore

Click Next after specifying the information.

  • Target Database Connection Details. Provide the details of the database you want to use for the installation of the UTA Repository. The following information needs to be provided:
    • Database Host. The host name housing the database to house the UTA Repository.
    • Database Port. The listener port number of the database to house the UTA Repository.
    • Database Service Name. The PDB name or database service name of the database to house the UTA Repository.
    • Database Administrator User Name. The DBA user to be used to install the UTA Repository objects. This user MUST have DBA access to create the objects.
    • Database Administrator Password. The associated password (and confirmation) for the DBA user.
    • Application Database Schema Password. The password (and confirmation) for the UTA schema user created in the prerequisite steps.

Database Connection Details

Click Next after specifying the information.

  • Installation Summary. A summary of the information provided is presented prior to executing the Installation. Click Install to start the installation. For example:

Installation Summary

  • Installation Progress. The installation will be visually shown with progress. If any steps error refer to the log outlined in the previous step. Correct and restart. An example of the Installation Progress is shown below.

Installation Progress

  • Installation Complete. A dialog will link to the success or failure of the installation process with a link to the log (if desired). Click Finish to close the installer. For example:

Installation Complete

After finishing the install it is possible to start the Oracle Utilities Testing Accelerator using the following commands:

  • Navigate to the home directory specified on Page 3 of the installation (Oracle Home) as the user that installed the Oracle Utilities Testing Accelerator.
  • Use the ./startUTA.sh command to start UTA.
Refer to the Installation Guide for optional post installation processes including loading content packs into the Oracle Utilities Testing Accelerator.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.