Select Page

Art of BI: OC4J Windows Service Configuration

Christian Screen | | November 17, 2009

In my previous post on Essbase Studio Server & OC4J as a Windows Service I mainly tailored that information to Essbase Studio.  I received a bit of feedback on making sure I added the OC4J component in a similar fashion and here it is.  Don’t forget to watch the video tutorial for full disclosure.
[simage=86,512,y,center]

Installation

Here is the OC4J Windows Service files download.

I recommend extracting the Zip file to the following root path, ORACLEBI_HOMEserver.
[simage=88,320,y,center]

Similar to the Essbase Studio windows service files you will need to update the RegisterService.bat and ServiceRegistration.reg files to point to your installation’s correct OC4J file paths.  Once that has been confirmed execute the _init_BuildAppAsWinServiceWrapper.bat to launch the process.  Click ‘OK’ for all registry update prompts.

Gotchas

There are no gotchas to this solution that I have yet found.  If you spy any please leave a comment and I will seek to provide an update.  The main thing to note is that this solution was developed for the 10.1.3.4 release of OBIEE which is the 10.1.3.1.0 release of OC4J and the Embedded Java Containers.  If you run the following command in a command window you will be able to see the version of OC4J that your machine is running:

  • ORACLEBI_HOMEoc4j_bibinoc4j.cmd -version

[simage=87,400,y,center]

Conclusion

Again, once one knows how to use the inherent code for Windows Servers it is actually quite straightforward to implement this type of solution.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS