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.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

	Overview
	Scenario
	Prerequisites
	Reviewing Software Directories
	Reviewing Services
	Installing the First Essbase Instance as a Windows Service
	Refreshing Services Display
	Installing the Second Essbase Instance as a Windows Service
	Editing the Batch File
	Running the Batch File
	Examining Results
	Summary
	Related Information

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over each individual icon in the following steps to load and view only the screenshot associated with that step.

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.

Back to Topic List

Scenario

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

Back to Topic List

Prerequisites

Before starting this tutorial, you should:

Back to Topic List

Reviewing Software Directories

In Windows explorer, locate the first Essbase installation directory and expand it to show the standard folder structure.

Back to Topic List

Navigate to the second Essbase installation directory and expand it to show the standard folder structure.

Back to Topic List

Reviewing Services

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

Back to Topic List

Installing the First Essbase Instance as a Windows Service

The first instance can be established as a Windows service through a Run window. Click Start > Run to open a Run window.

In the Open text box, enter cmd and then click OK.

In the cmd window, enter essbase -service install and then press Enter.

A success message is displayed. Type exit and press Enter.

Back to Topic List

Refreshing Services Display

Open Windows Services and from the control menu, select Action > Refresh.

The first Essbase instance is displayed as a Windows service.

Back to Topic List

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.

Back to Topic List

Editing the Batch File

Right-click the batch file and select Edit.

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.

Select File > Exit to exit the editor.

Back to Topic List

Running the Batch File

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

Back to Topic List

Examining Results

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

Back to Topic List

Summary

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

Back to Topic List

Related Information

To learn more about establishing multiple instances of Essbase as Windows services on a single server, you can refer to:

	Essbase Online Technical Reference
	Essbase Database Administrators Guide

Back to Topic List

Place the cursor over this icon to hide all screenshots.