|Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-01
Administering an OLAP Service, 4 of 15
OLAP Services operates either in manual or automatic mode. It is set initially to run in manual mode so that it only starts when you explicitly restart it. However, you can set OLAP Services to run in automatic mode, so that it restarts automatically whenever you restart your computer or the service environment.
Follow these steps to start an OLAP service:
A tree of options expands under the service name.
You see the State page of the Instance sheet.
Note: If you want to change the startup mode, then choose the Properties sheet.
Instance Manager will start the selected OLAP service.
The following figure shows the State page of the Instance sheet:
Upon installation, the environment variables and configuration settings used by OLAP Services during startup are set correctly. However, in the course of reconfiguring a service, installing other products, and so forth, you might make changes that will prevent OLAP Services from starting.
The following are some of the most common reasons why an OLAP service fails to start:
tnsnames.ora(located in the
network/adminsubdirectory of Oracle home).
olap/dbsubdirectory is first in the list. Check the names of the other directories to make sure that they exist and are spelled correctly.
OLAP Services sends messages to log files to help you diagnose any problems. You can access these log files through Instance Manager. For information about viewing these files, refer to "Viewing Status Messages".
If OLAP API applications cannot connect to an instance of OLAP Services that you know is up and running, then the problem might be that an environment variable has been reset and no longer points to the needed directories. The correct paths are set by a file named
olap.prm (located in the
olap subdirectory of Oracle home), which runs during startup of the service environment. You can run this file manually or restart the service environment.
Some platforms require that the OSAgentAddr and OSAgentPort configuration parameters be set for the OLAP API to locate that OLAP service. Check the values of these parameters, and refer to Instance Manager Help for information about the appropriate setting for your platform.
For information about starting an OLAP service, search Instance Manager Help for the following topics:
To learn about performing these tasks in a command-line or batch mode, refer to "Command-line Administration". In OLAP Service Manager, get help on the following commands: