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
