Thursday, November 25, 2010

OBIEE11g - Stopping and Starting Services from Command Line

In the previous post I showed how to stop/start OBIEE 11g services using Fusion Middleware Control. This post shows how to achieve same using command line.

OBIEE 11g installer creates opmnctl.bat file for each instance. To manage services start command prompt and go to the bin folder of the instance \{MWH}\instances\instance1\bin

Run following command to check the status of all the services running under the instance.

opmnctl status

You can use ias-component name in the output to stop/start individual service.

For example, following command stops presentation service.

opmnctl stopproc ias-component=coreapplication_obips1

And following command starts presentation service

opmnctl startproc ias-component=coreapplication_obips1

Following commands can be used to stop/start all services in the instance.

opmnctl stopall
opmnctl startall

OBIEE11g - Stopping and Starting Services using Fusion Middleware Control

In OBIEE 10g all five services could be stopped and started from the windows services management console.

However, things have changed with OBIEE 11g because of the change in the architecture, specifically related to scalability. All the services are maintained through Oracle Process Manager and Notification (OPMN) server. Stopping/Starting this service will stop/start all BI services for that instance.

Most of the administration activities are performed using Fusion Middleware (FMW)
Control in OBIEE 11g. You can stop and start services from FMW Control too.

Logon to FMW Control using URL http://hostname:7001/em

Select coreapplication under Business Intelligence in the left tree in FMW Control. The "Overview" tab on the right will show number of services running (Generally 5, but may be different based on your scalability settings). You can Stop, Start or Restart all services using buttons provided.

To stop and start individual services, navigate to "Availability" tab under "Capacity Management" tab. You can stop/start all or selective services here.

Friday, November 12, 2010

OBIEE - Purge BI Server Cache from Analytic Web Manually

All of us knows how to purge BI Server cache manually from Analytic Administration Tool i.e. Go to Manage > Cache. Select cache entries, right click and purge.

But what if you are working on reports remotely using Analytic Web and need to clear the BI Server cache? Here's the trick.

Go to Settings > Administration

In the Administration dialog select "Issue SQL"

In the SQL Statement textbox in the "Issue SQL Directly" dialog, enter the following statement and click "Issue SQL" button.

Call SAPurgeAllCache();

Allow some time for BI server to clear the cache. The page will refresh with results message at the bottom saying operation is successful.

You can also use other cache purge functions based on your need.