eWorksheets - Free Evaluation

  1. Installation Guide

October 2015

External Document

VERSION 1.0


Support

For all support issues, please contact:

Product Development team – trinitiappsupport@triniti.com

© 2015 Triniti Corporation. All rights reserved. This document is for informational purposes only. Triniti Corporation makes no warranties expressed or implied in this document. Triniti, Triniti Corporation and the Triniti Logomark are either registered trademarks or trademarks of Triniti Corporation in the United States and/or other countries. All other marks noted are owned by their respective companies.

Oracle is a registered trademark, and Oracle8i, Oracle9i, PL/SQL, SQL*Plus are trademarks or registered trademarks of Oracle Corporation.

Microsoft, Windows, Win32 are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Java,  J2SE, Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries.

Red Hat and all Red Hat-based trademarks and logos are trademarks or registered trademarks of Red Hat, Inc. in the United States and other countries.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Linux is a registered trademark of Linus Torvalds.

PuTTY is copyright Simon Tatham.

SSH is either trademark or registered trademark of SSH Communications Security Corp.

Pentium is a registered trademark of Intel Corporation or its subsidiaries in the United States and other countries. 


Contact Information

  1. Triniti Corporate Offices

Triniti Corporation

2001 Gateway Place Suite 425E

San Jose, CA 95110

USA

T: 408-659-7752, 408-659-7764

Triniti Advanced Software Labs Pvt. Ltd.
1st, 2nd
 & 3rd Floors
1-8-301 Ashoka My Home Chambers
S.P. Road
Hyderabad 500 003
INDIA

T: (91) 40 27893939


Table of Contents

Environment Setup        

System Requirements        

Installation Prerequisite        

Background of Installer        

Installation of eWorksheets - Free Evaluation

Overview of eDapter Tookit - Free Evaluation

Installation of eWorksheets - Free Evaluation


Environment Setup

  1. System Requirements

eWorksheets - Free Evaluation should be installed on Linux platform. The server on which eWorksheets - Free Evaluation will be installed should meet the following system requirements:

Hardware

1

Memory

8 GB RAM or more

2

Disk Space

40 GB or more (determined by transaction volume)

3

Processor

Multi-CPU Machine

Software

1

Operating System

Linux / Oracle Linux 7

2

Database

Oracle 11g / 12C

3

Oracle Utilities

If database doesn’t exist on the same server, then install Oracle Utilities / Oracle client on the server.

The installer tested well on the below environments:

Processor

Memory

Disk space

OS

DB

2 Core i3-4010U CPU @ 1.70GHz

4 GB

30 GB

Oracle Linux 7

Oracle 12C

2 Core Intel(R) Core(TM)2 Duo CPU E7500@ 2.93GHz

8 GB

440 GB

Red Hat Enterprise Linux Server release 6.0 (Santiago)

Oracle 11g

IMPORTANT:  If you are connecting to a UNIX machine across the open Internet, Triniti recommends you use SSH for better security.

NOTE:  If you are installing from your MS Windows desktop, you need to have a Win32® Telnet and SSH® client along with an xterm terminal emulator (such as PuTTY, a free implementation that can be downloaded from the internet). You also need to have a PC X connectivity tool to run and display UNIX applications from your Microsoft® Windows® environment (such as VNC Viewer).

The clients that access the eWorksheets - Free Evaluation server should meet the following system requirements:

Hardware

1

Memory

1 GB RAM or more

2

Disk Space

Not applicable

3

Processor

1.5 GHz processor or above

Client Software

1

Operating System

Windows XP with Service Pack 4 / Windows 7

2

Browser

Internet Explorer ver. 9.0 or above

3

JRE

v1.6.0_33 for accessing java applet applications

  1. Installation Prerequisite

  1. A dedicated user <Triniti_Admin> must be created on the server with full permissions.

Note:        Installer will install Java, Tomcat and Deployment folder in this user. Custom schemas will be created by Installer.

  1. The size of folder, where the eWorksheets - Free Evaluation will be installed, should be 520 MB or more.
  1. Background of Installer

Basically, eWorksheets - Free Evaluation Installer performs the following steps:

  1. Install JAVA
  2. Install TOMCAT
  3. Update Environment variables for JAVA, TOMCAT in OS profile file (For Example .bash_profile in Linux)
  4. Deploy TrinitiApps (eWorksheets - Free Evaluation folder)
  5. Create Schemas with following size

Triniti Custom Schema

Size

TAS

20 MB

STATEGPS

2048 MB

Note:        It is a GUI based installer, so it requires VNC Viewer for installation. Ensure that VNC Server is running on the machine that you’re connecting to.

Installation should be done by DBA or IT person.

Reason: Installation needs Oracle SYSTEM User Password for creation of Triniti custom  

  schemas by the installer.


Installation of eWorksheets - Free Evaluation 

  1. Overview of eWorksheets - Free Evaluation 

eWorksheets - Free Evaluation is developed and supported by Triniti Framework, which is also deploy-able Web application that can run on any application server that conforms to the Servlet API specification version 2.2 or later. The Triniti Framework components will be installed first when you run eWorksheets - Free Evaluation installer.

As these components need to access different schemas in the database, we need to specify connection properties while installing eWorksheets - Free Evaluation.

  1. Installation of eWorksheets - Free Evaluation 

  1. Log on to the server using user credentials.

Note:   If installation is to be done remotely, a Win32 Telnet and SSH client along with an xterm terminal emulator (such as PuTTY) can be used.

  1. Copy the following files from the installation CD/FTP server: eWorksheets - Free Evaluation.bin to home directory

Note:   If installation is done remotely, the files from the CD inserted on the terminal’s CD-ROM drive can be transferred to the server using a Window-based FTP application (such as WinSCP).

Note:   If installation is to be done remotely using a Windows terminal, make sure that the PC X connectivity tool (such as VNC Viewer) is activated.

  1. If you use VNC Viewer for remote installation, ensure that VNC Server is running on the machine that you’re connecting to.
  2. Enter vncserver at the command prompt (in putty) to create a new session ID. Note down the session ID created by VNC Server.

Figure 1

New Session ID is 30.

  1. Now, start VNC Client on your desktop by entering the following details: <Server IP Address>:<VNC Session ID>

For example: 192.168.0.23:30

Figure 2

  1. Click OK. Then, enter VNC Server password and click OK.

Figure 3

  1. Open Terminal and run Installer bin file using sh command

Figure 5


You see the following screen after entering the commands mentioned above.

Figure 6

The screen displays a brief introduction of the installer. Click Next button.

  1. Choose a folder to install eWorksheets - Free Evaluation software. By default it shows <home folder>/TrinitiApps.

Figure 9

  1. On clicking Next, the following screen appears.

Figure 10

  1. Click OK if installer folder needs to be created automatically.
  2. Click Next. The following screen is displayed:

Figure 11

  1. Enter the Host name and Port on which application server will run.

20.Click Next. The following screen will be displayed.

21.Choose Oracle Home directory

NOTE:

If Oracle database is installed on the same machine, then provide the local oracle home directory path in the field.

Suppose Oracle database is installed on different machine, then provide the oracle home directory of that machine, which contains Oracle database in the field manually.

WARNING:

Oracle Utilities should be installed in this machine to connect to database in another machine.

22.Click Next. The following screen will be displayed.

Figure 13

  1. Enter database connection properties for SYSTEM.

  1. Click Next. You see the following screen:

Figure 15

  1. Select the data files for all schemas.

If database is available in another server, enter data file path manually in the Data File (.dbf) Location field.

The above panel allows the user to create schema on database server. The following details are to be entered.

  1. Click Next. You see the following screen:

Figure 19

  1. Create an admin user account by entering the user name and password. This user will be automatically created in the eWorksheets - Free Evaluation Security.
  2. Click Next. The Pre Installation Summary screen appears.

Figure 20

  1. Review the Pre-Installation Summary for TAS, TAB, TRI2, PDA, ETK, and Scheduler database connection properties. If all the details are correct, click Install.

The following screen is displayed indicating that the installation is in process.

Figure 21

When the process of installation is completed, the screen indicating successful completion of eWorksheets - Free Evaluation installation is displayed.

Figure 23

  1. Click Done.
  2. Start the tomcat using below commands in the same VNC session (DON’T USE PUTTY), which will start the eWorksheets - Free Evaluation server

NOTE: eDapter Toolkit - Free Evaluation server requires X server on linux, so we must run the .bash_profile and start the tomcat from the same VNC session which is used for installation.

Wait for server to start completely (log file shows “server started in <n> seconds).

And then start accessing eWorksheets - Free Evaluation using URL:

  1. http:<host name>:<port>/trinitiapps/logon.html for java applet application
  2. http:<host name>:<port>/trinitiapps/index.html for HTML application

NOTE: Replace <host name>:<port> with the values provided while installation.