|Oracle9i OLAP Services Concepts and Administration Guide for Windows
Release 1 (9.0.1) for Windows
Part Number A90371-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.
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.
When the Windows Application Event Log is full, you will probably still be able to start OLAP Services, but you will get a warning message. Use the Windows Event Viewer to reconfigure the Event Log so that it overwrites old events. Then this condition cannot occur.
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.
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: