Application Server Configuration Guide

for Prevail8/Marquee8 Implementation

Contents
Contents...............................................................................................................................................................1
Required Areté Components & 3rd Party Applications............................................................................................3
Areté Components...............................................................................................................................................4
Overview..........................................................................................................................................................4

Areté Inc.

Application Server Configuration Guide

Download Areté Components..........................................................................................................................4

Verify Areté Components................................................................................................................................4
MSXML6.............................................................................................................................................................5
Overview..........................................................................................................................................................5
Verify MSXML6.DLL....................................................................................................................................5
Download MSXML6.DLL..............................................................................................................................5
Oracle 11g, Oracle ODBC Components and Required Programs...........................................................................6
Overview..............................................................................................................................................................6
NOTE...............................................................................................................................................................6
Downloading Oracle Database 11g Client Release 2..........................................................................................6
Installing Oracle ODBC components..................................................................................................................7
Step 1: Extracting File.....................................................................................................................................7
Step 2: Select Installation Type.......................................................................................................................8
Step 3: Download Software Updates...............................................................................................................9
Step 4: Select Product Languages..................................................................................................................10
Step 5: Specify Installation Location.............................................................................................................11
Step 6: Perform Prerequisite Checks.............................................................................................................12
Step 7: Summary............................................................................................................................................13
Step 8: Install Product....................................................................................................................................14
Step 9: Finish.................................................................................................................................................15
Configuring Oracle TNS Names.......................................................................................................................16
©2012 Areté Inc.
 Option 1: Net Configuration Assistant..........................................................................................................16
Option 2: TNSNAMES.ORA........................................................................................................................27
Verifying Connection........................................................................................................................................28
Confirming ODBC Driver Information.............................................................................................................29
Windows 32-Bit.............................................................................................................................................29
Windows 64-Bit.............................................................................................................................................30
Installing other required programs.....................................................................................................................31
Database Administration / Query Software...................................................................................................31

©Areté Inc. Application Server Configuration Guide 1

Required Areté Components & 3rd Party Applications
Clients need to acquire and install Areté components and several 3rd party applications to run all functionalities of Prevail8. The
following software applications have to be installed on the client’s application server:

 Areté Component
 Microsoft Excel 2003Pro or Excel 2007
 Printer drivers
 Zip / unzip application
 MSXML6.dll
 Oracle 11g, Oracle ODBC Components and Required Programs

Microsoft Excel is required to use the Excel Export function of Prevail8. Prevail8 is compatible with Excel 2003Pro and Excel 2007.
Printer drivers are required to print reports out of Prevail8. Zip/unzip application is required for backup and archiving on the
application server and for compressing Oracle data dump files. Note that Prevail8 database backup is achieved through Oracle’s
backup utilities.

©Areté Inc. Application Server Configuration Guide 2

Areté Components

OVERVIEW

Areté Component is required to run Prevail8.

DOWNLOAD ARETÉ COMPONENTS

It is available from the following website:

http://www.areteinc.com/downloads/AreteComp8.exe

VERIFY ARETÉ COMPONENTS

Go to Control Panel > Add or Remove Programs. Make sure AreteAppComponentsForEOS8 is listed there. (Note:
AreteAppComponents is used by Prevail6)

©Areté Inc. Application Server Configuration Guide 3

MSXML6

OVERVIEW

MSXML6.dll is a required library for Prevail8. It is shipped with Microsoft SQL Server 2005, Visual Studio 2005, .NET Framework 3.0,
Windows Vista, Windows 7 and Windows XP Service Pack 3. MSXML 6 is not supported on Windows 9x. Windows XP SP3 includes
MSXML 6.0 SP2.

VERIFY MSXML6.DLL

DOWNLOAD MSXML6.DLL

If the DLL file is not available on the application server, it can be downloaded from the following website:

http://www.microsoft.com/downloads/details.aspx?FamilyID=993C0BCF-3BCF-4009-BE21-27E85E1857B1&displaylang=en

©Areté Inc. Application Server Configuration Guide 4

Oracle 11g, Oracle ODBC Components and Required Programs

Overview
A Prevail8/Marquee8 implementation against an Oracle database requires installing Oracle ODBC components with latest patches as
well as a Database Administration/Query tool on the Client’s application server. This document provides guidelines to acquire and
install these programs.

NOTE

1. Regardless of whether the application server is running 32-bit or 64-bit Windows, the 32-bit version of Oracle needs to
be installed in order to run Prevail8 / Marquee8.

Downloading Oracle Database 11g Client Release 2

File name: p10098816_112020_WINNT_3of6.zip

©Areté Inc. Application Server Configuration Guide 5

Installing Oracle ODBC components
Oracle ODBC components need to be installed on the application server once Oracle has been set up on the database server.
Configuration is a multiple-step process as detailed below.

STEP 1: EXTRACTING FILE

Start Oracle Database 11g Client Release 2 (11.2.0.2.0) by unzipping the downloaded file and double-clicking on the file named
SETUP.EXE. Click Next unless noted in the steps below.

©Areté Inc. Application Server Configuration Guide 6

STEP 2: SELECT INSTALLATION TYPE

When prompted to select Installation Type, choose Administrator then click Next.

©Areté Inc. Application Server Configuration Guide 7

STEP 3: DOWNLOAD SOFTWARE UPDATES

Choose Skip Software Updates then click Next.

©Areté Inc. Application Server Configuration Guide 8

STEP 4: SELECT PRODUCT LANGUAGES

Choose English then click Next.

©Areté Inc. Application Server Configuration Guide 9

STEP 5: SPECIFY INSTALLATION LOCATION

Update Oracle Base to d:\oracle\ and Software Location to d:\oracle\product\11.2.0\client_1

©Areté Inc. Application Server Configuration Guide 10

STEP 6: PERFORM PREREQUISITE CHECKS

(No action)

©Areté Inc. Application Server Configuration Guide 11

STEP 7: SUMMARY

Verify the values of Install type, Oracle Base and Oracle Home Location and click Install.

©Areté Inc. Application Server Configuration Guide 12

STEP 8: INSTALL PRODUCT

(No action)

©Areté Inc. Application Server Configuration Guide 13

STEP 9: FINISH

Click Close.

©Areté Inc. Application Server Configuration Guide 14

Configuring Oracle TNS Names

OPTION 1: NET CONFIGURATION ASSISTANT

STEP 1: LAUNCH ORACLE NET CONFIGURATION ASSISTANT

©Areté Inc. Application Server Configuration Guide 15

STEP 2: WELCOME
Choose Local Net Service Name configuration then click Next.

©Areté Inc. Application Server Configuration Guide 16

STEP 3: NET SERVICE NAME CONFIGURATION
Choose Add then click Next.

©Areté Inc. Application Server Configuration Guide 17

STEP 4: SERVICE NAME
Enter Service Name then click Next. Service Name is usually the same as the database name.

©Areté Inc. Application Server Configuration Guide 18

STEP 5: SELECT PROTOCOLS
Choose TCP then click Next.

©Areté Inc. Application Server Configuration Guide 19

STEP 6: TCP/IP PROTOCOLS
Enter Host Name then click Next.

©Areté Inc. Application Server Configuration Guide 20

STEP 7: TEST
Choose No, do not test, click Next.

©Areté Inc. Application Server Configuration Guide 21

STEP 8: NET SERVICE NAME
Enter Net Service Name, click Next.

©Areté Inc. Application Server Configuration Guide 22

STEP 9: ANOTHER NET SERVICE NAME
Choose No then click Next.

©Areté Inc. Application Server Configuration Guide 23

STEP 10: DONE
Click Next.

©Areté Inc. Application Server Configuration Guide 24

STEP 11: FINISH
Click Finish.

©Areté Inc. Application Server Configuration Guide 25

OPTION 2: TNSNAMES.ORA

You need to copy the TNSNAMES.ORA file from the Database Server to the Admin folder under the Oracle Home folder in the
Application Server. For example:

D:\Oracle\Product\10.2.0\client_1\Network\Admin\TNSNAMES.ORA

©Areté Inc. Application Server Configuration Guide 26

Verifying Connection

Verify that the Oracle database can be accessed from the Application Server by running this command on the Windows Command
Prompt:

TNSPING <OracleDBName>
- where <OracleDBName> is the name of the Oracle Database given during the Database installation.

©Areté Inc. Application Server Configuration Guide 27

Confirming ODBC Driver Information

WINDOWS 32-BIT

Go to Control Panel > Administrative Tools > Data Sources (ODBC). Click Drivers tab and confirm Oracle Client ODBC Driver is
correct.

©Areté Inc. Application Server Configuration Guide 28

WINDOWS 64-BIT

Launch to c:\windows\syswow64\odbcad32. Click Drivers tab and confirm Oracle Client ODBC Driver is correct.

©Areté Inc. Application Server Configuration Guide 29

Installing other required programs

DATABASE ADMINISTRATION / QUERY SOFTWARE

Areté requires Clients to have Database Administration/Query software on their application and database servers prior to the on-site
implementation. A Database Administration/Query tool allows Areté implementers to connect to the Database server and work on
the Client’s data during the implementation and permits Database administrators to maintain Prevail8 data after going live with the
application. There is a myriad of Database Administration/Query software that the Client can choose from. Any software that can
connect to Oracle 11g would be sufficient for Areté implementers. Areté’s recommended option is the Oracle SQL Developer
software that can be downloaded for free using the following link:

http://www.oracle.com/technology/software/products/sql/index.html

It is strongly suggested that Clients thoroughly read the license agreement prior to accepting. If the license agreement is accepted,
Areté suggests Clients to download the Oracle SQL Developer for 32-bit Windows (including JDK) option which also includes the
Java Development Kit required for the application to run on the server. This version of the application is suggested for 64-bit
Windows servers as well. The product’s installation wizard provides step-by-step guidelines that the Client can follow during set up.

©Areté Inc. Application Server Configuration Guide 30