Auto Start OBIEE With Windows

One of OBIEE’s idiosyncrasies is that, by default, only the user that installed the product can start the server from the Window’s Start menu.  For more information on this, please read this old post.

The solution outlined on that post enables ADDITIONAL users to start OBIEE. This is still borderline unacceptable on a production environment.  Ideally, we want OBIEE to start with the Windows Server.

What we want is OBIEE to start as a service on boot up.  The only original information I’ve found on this comes from Oracle itself.

Everything else ‘on the tubes’ so far is a copy/paste job from Oracle doc.  However, I have found no success stories from anyone.  I could not get this to work either for OBIEE.

This is where Windows Scheduler comes in.  Using Windows Scheduler, I was able to set OBIEE to start on system startup without any trouble. 

Here’s how:

1. From the Windows Start Menu, select to Add Scheduled Task from the Scheduled Tasks.

Image(6)

2. Press ‘Next’, then ‘Browse’ to enter the full path of the command specified on the OBIEE Windows Start Menu Item.

3. To obtain the path needed, go to the link on the Start Menu and select Properties for the Start BI Services option.

Image(7)

4. From the pop menu, select and copy the Target path to your clipboard.

Image(8)

5. Press ‘OK’ to close this popup menu.

6. Paste this path to the Select Program to Schedule dialog box previously opened.  Press ‘Open’ to set.

Image(9)

Note: For a default installation, the full path is c:\_obiee_\instances\instance1\bifoundation\OracleBIApplication\coreapplication\StartStopServices.cmd start_all.  Note the argument start_all passed to cmd.  We will add this argument to the task later to save us an error prompt here.

7. Give this scheduled task a name and specify this task to run when computer starts. Press ‘Next’.

Image(10)

8. Setup the task to start for the user that installed OBIEE in the first place.  If you prefer OBIEE starts under a different user (like SYSTEM), you will have to enable said user to have full control of task first as outlined in this post. Press ‘Next’ to proceed.

Image(11)

9. On final screen, select to open advanced features for this task.

Image(12)

10. On dialog box, add the start_all argument to the Run path.

Image(13)

11. Verify the user (now run as) credentials for user that installed OBIEE.

Image(14)

You are done.  You can proceed to Scheduled tasks and note that your new task is listed

Image(15)

Next time Windows starts, most likely 10 minutes afterwards:p, OBIEE should be up and running.

Advertisements

One thought on “Auto Start OBIEE With Windows

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s