Friday, December 28, 2012

Establishing Multiple Instances of Essbase as Windows Services on a Single Server


Purpose


This tutorial shows you how to establish two instances of Essbase as Windows services on the same server.

Overview


Essbase Release 9.3 and later enables you to install multiple instances of Essbase server as Windows services on the same server. You might find this useful if, for example, you need to run your Essbase development and test activities on the same machine.

Scenario


In this tutorial, you establish two Essbase instances of Release 9.3 as Windows services on server WIN3KB.

Prerequisites


Before starting this tutorial, you should:
1.
Have two instances of Essbase (Release 9.3 or later) installed in separate directories on one server.
2.
Conform with current Oracle licensing regulations.

Reviewing Software Directories


In Windows explorer, locate the first Essbase installation directory and expand it to show the standard folder structure.
1.
Screenshot for Step
2.
Navigate to the second Essbase installation directory and expand it to show the standard folder structure.
Screenshot for Step

Reviewing Services


Open Windows Services. This is where the Essbase instances will appear after we have established them as services.
Screenshot for Step

Installing the First Essbase Instance as a Windows Service


1.
The first instance can be established as a Windows service through a Run window. Click Start > Run to open a Run window.
Screenshot for Step
2.
In the Open text box, enter cmd and then click OK.
Screenshot for Step
3.
In the cmd window, enter essbase -service install and then press Enter.
Screenshot for Step
4.
A success message is displayed. Type exit and press Enter.
Screenshot for Step

Refreshing Services Display


Open Windows Services and from the control menu, select Action > Refresh.
Screenshot for Step
The first Essbase instance is displayed as a Windows service.
Screenshot for Step

Installing the Second Essbase Instance as a Windows Service


The second instance can be installed through a batch file, which provides a set of environment variables separate from those of the first instance.
Screenshot for Step

Editing the Batch File


Right-click the batch file and select Edit.
Screenshot for Step
The batch file provides a set of environment variables (ARBORPATH and PATH) separate from those of the first (default) instance of Essbase, then invokes Essbase with the password-service, and install parameters.
Screenshot for Step
Select File > Exit to exit the editor.

Running the Batch File


In Windows Explorer, double-click the batch file. Note the success message, then press any key to exit the script.
Screenshot for Step

Examining Results


Open the Services window and refresh the listing. The second Essbase instance is installed as a Windows service.
Screenshot for Step

Summary


In this lesson, you learned how to establish two instances of Essbase as Windows services on the same server.