3
Administering an OLAP Service

Chapter summary

In this chapter, you will learn how to reconfigure, start, and stop an OLAP service. Typically, you will use OLAP Services Instance Manager, which is a graphical user interface, to perform these tasks. However, a command-line utility provides an alternative means of doing them. The OLAP service and both of these administrative tools operate in a service environment. Before you can start them, you must first start the service environment.

Access to OLAP Services Instance Manager is through Oracle Enterprise Manager. You will use Oracle Enterprise Manager to perform other administrative tasks, such as defining database user names and passwords for the OLAP service itself, other administrators, and application users.

List of topics

This chapter includes the following topics:

• Managing the Service Environment

• Introducing OLAP Services Instance Manager

• Starting OLAP Services

• Stopping or Pausing OLAP Services

• Acquiring System Administration Privileges

• Changing the Configuration Settings

• Unlocking Database Identities

• Managing Sessions

• Viewing Status Messages

• Creating New Services

• Command-line Administration

• Granting Access Rights to Users

• Configuring Instance Manager

• Configuring OLAP Services Agent