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.
I recommend extracting the Zip file to the following root path, ORACLEBI_HOMEserver.
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.
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
Again, once one knows how to use the inherent code for Windows Servers it is actually quite straightforward to implement this type of solution.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
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?