Installing TopTeam Application Server for Oracle Database

This article describes how to install TopTeam Application Server for Oracle database.

If you want to install TopTeam Application Server for another database, refer to the article Installing TopTeam Application Server.

• TopTeam Administrators
• System Administrators
• IT Support
• Database Administrators

TopTeam Application Server can be installed on a personal computer or a Windows Server computer. When evaluating TopTeam, you can even install TopTeam Application Server on a laptop, however, for production usage you should use a desktop or a server class computer.

We recommend you to install TopTeam Application Server on the latest Windows Server computer.

To install TopTeam Application Server as a Windows Service, you should log into the computer as a Windows Administrator. You do not require Windows Administrator privileges if you want to run TopTeam Application Server as a Windows Application.

We recommend that you install TopTeam Application Server as a Windows Service for production usage.

You do not need to purchase a license upfront to install and evaluate TopTeam. By default, TopTeam Application Server will start in an evaluation mode if you do not provide a valid license key.
Upon expiration of the evaluation period, TopTeam Application Server will stop running.

To continue using TopTeam, you need to purchase a permanent license key or contact a TechnoSolutions sales representative for an extension key.

1. Download the latest TopTeam Application Server installer from TechnoSolutions Customer Portal (access to Customer Portal is available only to licensed customers) or use the download link provided by TechnoSolutions.

The installer file name format is:
TopTeamOraServerLic_Installer_<TopTeam Application Server Version>_DB_<TopTeam Database Schema Version Required>_<Release Date>.exe

e.g. TopTeamOraServerLic_Installer_5.0_Db_8.0_31Jul14.exe

In the example above:
5.0 – is the version number of TopTeam Application Server
8.0 – is the TopTeam database version which will be installed by this installer
31Jul14 – is the release date of this TopTeam Application Server

2. Ensure that Oracle Client libraries, needed for TopTeam Application Server to connect to Oracle database, are installed on the computer.
For more information, refer to the article Database Requirements for TopTeam Repository.

3. If you want to install and run TopTeam Application Server as a Windows Service, ensure that you have logged into the computer as a Windows Administrator.

4. Ensure that you have a valid username and password of an Oracle User Account that has the privileges to create database schema. This is required to install TopTeam database schema on Oracle.

• Ensure that the computer you have selected for installing TopTeam Application Server meets the System Requirements for TopTeam Application Server.

Double-click the TopTeam Application Server installation file.

• Choose option 1 (TopTeam Server for Oracle and Oracle DB Schema) if you want to install both TopTeam Application Server and the TopTeam Database Schema.
• Choose option 2 (TopTeam Server for Oracle) to install only TopTeam Application Server. Choose this option if the TopTeam Database Schema has already been installed.
• Choose option 3 (TopTeam Oracle DB Schema) if you have already installed TopTeam Application Server and now want to install the TopTeam Database Schema on Oracle database.

NOTE: This article describes the steps for the first option. The steps for options 2 and 3 are a sub-set of the steps for option 1.

Choose the folder where you want to install TopTeam Application Server for Oracle on your computer. Ensure that you have READ and WRITE permission on this folder. We recommend that you keep at least 2 GB of free disk space on the drive where you install TopTeam Application Server for log files which are created while the application is running.

Default Folder: C:\Program Files\TechnoSolutions TopTeam\Application Server for Oracle

TopTeam Application Server can be installed in two modes:

1. Install as Windows Service (Recommended)
Choose this option to install TopTeam Application Server as a Windows Service. You must log in as a Windows Administrator to install TopTeam Application Server as a Windows Service.

2. Install as Application
Choose this option to install TopTeam Application Server as a Windows Application. Use this option if you do not have Windows Administrator privileges on the computer and want to evaluate TopTeam.

We recommend you to go with option 1 unless you don’t have Windows Administrator privileges on this computer.

You can always change this configuration setting later.

Choose Yes to run the TopTeam User Database Schema installation wizard. TopTeam stores all your project data in this database schema.

This will run the TopTeam Database Schema installer for Oracle server.

Choose option 1 (In New Oracle Usercode) to install TopTeam repository by creating a new database Schema.
Choose option 2 (In Existing Oracle Usercode) to install TopTeam repository in an existing empty database schema.

This article describes the steps with option 1.

Enter Username and Password of the Oracle User and Oracle Database name that should be used to connect to the Oracle Server.
NOTE: You must login as a Database Administrator to create a new User and/or create tables, triggers, etc. in an existing schema.

1. Enter Database Username and Password of the new TopTeam Database Schema.

2. Choose Default Tablespace and Temporary Tablespace for the new TopTeam Database Schema.

3. Click Create User to create the user and proceed to the next step.

If you wish to review the SQL commands being used to install TopTeam Database Schema, you can view them in this step.

Click Install to begin the database installation process.

You have successfully installed TopTeam Database Schema.

Click Finish to exit the wizard and continue further with installation of TopTeam Application Server.

In case you encounter any error during installation, you can send the log file to TechnoSolutions support for analysis.

Log file is created on the computer on which TopTeam Database Schema installer was run.

The log file is created in the following folder –
C:\…\My Documents\TechnoSolutions\DB Schema Installer

In case you face any difficulty in installing the TopTeam database or any error is reported by the installer, TechnoSolutions support will need this log file to analyze the problem.
Keep a backup of this file for future reference.

Installation of Sample Database schema is optional. Sample database schema can be used as a sandbox for training and evaluation purpose.

Choose Yes if you wish to run the TopTeam database schema installer for installing Sample Data.

Sample Data will be installed using TopTeam Oracle DB Schema Installer.
Refer to the earlier steps in this article for installing TopTeam Database Schema to install TopTeam Sample database schema.

Check option to create a shortcut on the desktop for TopTeam Application Server.

Click Finish to exit the installation wizard.

After successful completion of installation, Management Console for the TopTeam Application Server will start automatically, if you have installed TopTeam Application Server as a Windows Service.
If you have installed TopTeam Application Server as a Windows Application, it will start in Application Mode and the Server Configuration Wizard will be launched automatically.

Refer to the article Configuring TopTeam Application Server using Configuration Wizard.

Revised: July 23rd, 2018