Oracle BI EE 10.1.3.3/2 – Creating Windows Service for BI EE OC4J
Posted by Venkatakrishnan J on February 15, 2008
Update: Just realized Adrian has already blogged about this here. Thanks to Adrian for pointing it out.
Thanks to Matt Bedin and Dave Granholm(BI EE product management) for sharing this. This has been asked so many times before both in internal as well as external forums. So, i thought i would blog about it for the benefit of others. Just remember that, this method is not supported as yet by Oracle. As you would know, when you do a default install of BI EE, it would install OC4J which would act as a web server. This OC4J would start automatically when you start your OS and you can see the OC4J console in your system tray. Now, how do we go about converting this OC4J start/stop command script into a windows service? In order to do this, we would need an excellent Open Source Utility called JavaService-2.0.10. You can download this from here. Once you have downloaded this, unzip the utility to any folder.
Now, navigate to this folder from command line and enter the following command.
javaservice -install “Oracle BI EE OC4J” “C:\Program Files\Java\jdk1.5.0_11\jre\bin\client\jvm.dll” -XX:MaxPermSize=128m “-Djava.class.path=D:\Oracle\OracleBI\OC4J_BI\j2ee\home\oc4j.jar” -start oracle.oc4j.loader.boot.BootStrap -description “Oracle BI EE OC4J Service”
In the above command, C:\Program Files\Java\jdk1.5.0_11\jre\bin\client\jvm.dll points to the dll in your Java 1.5 JDK path. Also, D:\Oracle\OracleBI\OC4J_BI\j2ee\home\oc4j.jar points to the oc4j.jar within your BI EE instance.
Now, if you go to the Windows Services Manager, you would notice that a new service would have been created.
Now, you should be able to the control the start/stop of OC4J from the services console. Use this only on a test instance since this is not certified.
Adrian ward said
Copycat! I blogged about this yesterday.
Venkatakrishnan J said
Ouch. Strange that the google reader never showed your blog entry earlier. I have now updated the blog entry to reflect yours.
Joe said
Hi,
Thanks for such a nice blog.
but i am unable to generate getting an error in the cmd window.
C:\Utility>javaservice -install “Oracle BI EE OC4J” “C:\jdk1.5.0_07\jre\bin\clie
nt\jvm.dll” -XX:MaxPermSize=128m “-Djava.class.path=C:\OracleBI\OC4J_BI\j2ee\hom
e\oc4j.jar” -start oracle.oc4j.loader.boot.BootStrap -description “Oracle BI EE
OC4J Service”
Unrecognised or incorrectly-ordered parameters for install command
The last 4 parameters (from ‘BI’) were not recognised
JavaService install command parameters not valid, or incomplete
Please help me regarding.
Regards,
Joe
Venkatakrishnan J said
Joe – I think you have directly copied it. Problem with HTML display. Remove all the double quotes and manually type them again. It should work.
Joe said
Hi Venkat,
Thanks for ur immediate response. After the modifications it is perfect.
Once again thank you.
One small doubt dont we have any find button in OBI.
Regards,
Joe
Ugur MIHCI said
Hi frieds,
when i try this
javaservice -install “Oracle OC4J servisi” “C:\Program Files (x86)\Java\jre1.5.0_09\bin\client\jvm.dll” -XX:MaxPermSize=128m “-Djava.class.path=D:\oracle\bise1\bi\oc4j_bi\j2ee\home\oc4j.jar” -start oracle.oc4j.loader.boot.BootStrap -description “Oracle BI EE OC4J Service”
i got this error,
Unrecognised or incorrectly-ordered parameters for install command
The last 4 parameters (from ‘BI’) were not recognised
JavaService install command parameters not valid, or incomplete
please can you help?
thank you
Arjun said
Hi Venkat,
Can you please tell me direct command. I am also seeing the below error.
C:\Documents and Settings\ajoshi\Desktop\JavaService-2.0.10>javaservice -install
“Oracle BI EE OC4J” C:\Program Files\Java\jdk1.5.0_11\jre\bin\client\jvm.dll -X
X:MaxPermSize=128m “-Djava.class.path=D:\Oracle\OracleBI\OC4J_BI\j2ee\home\oc4j.
jar” -start oracle.oc4j.loader.boot.BootStrap -description “Oracle BI EE OC4J Se
rvice”
Unrecognised or incorrectly-ordered parameters for install command
The last 4 parameters (from ‘BI’) were not recognised
JavaService install command parameters not valid, or incomplete
C:\Documents and Settings\ajoshi\Desktop\JavaService-2.0.10>
Thanks
Joshi
Arjun said
Hi Venkat,
I got it.
Thanks
Joshi
Egide said
Hi Venkat,
Any idea why I’m not able to see the BI login screen, when I enter the url(http://egidej01:9704/analytics/saw.dll?Answers)
on a different machine than the one the BI server is running, after I’ve set up the oc4j service, as you described above?
On the machine where the BI server is installed, I’m able to startup BI.
When I stop the service and start the OC4J by the old fashioned way, everything works well.
Thanks,
Egide
Egide said
Hi Venkat,
Any idea why I’m not able to see the BI login screen, when I enter the url(http://egidej01:9704/analytics/saw.dll?Answers)
on a different machine than the one the BI server is running, after I’ve set up the oc4j service, as you described above?
On the machine where the BI server is installed, I’m able to startup BI.
When I stop the service and start the OC4J by the old fashioned way, everything works well.
Thanks,
Egide
Egide said
Hi Venkat,
Any idea why I’m not able to see the BI login screen, when I enter the url(http://egidej01:9704/analytics/saw.dll?Answers)
on a different machine than the one the BI server is running, after I’ve set up the oc4j service, as you described above?
On the machine where the BI server is installed, I’m able to startup BI.
When I stop the service and start the OC4J by the old fashioned way, everything works well.
Thanks,
Egide
Juan said
To avoid the “Unrecognised or incorrectly-ordered parameters for install command” error, remove from “-descrotion”. The javaservice program add its own descrition.
Regards,
Juan
Selva said
Hi Venkat,
I created the service successfully but the service is not starting. I saw an error message
“java.lang.NoClassDefFoundError:oracle/oc4j/loader/BootStrap”
in the error log file. What might be the cause for this problem?
Thanks,
Selva
Selva said
Hey, now its working good…… there is a typographical error..
Thanks – Selva
Den said
Hi Venkat,
I created the service successfully but the service is not starting. The exact message is “The Oracle BI EE OC4J service on Local Computer started and then stopped”. Do you know the cause why it is not starting? thanks!
Den
Ciaran said
I’m also getting the same error as Den,
Any ideas anyone?
Ciaran said
Dan,
Got it sorted,
You just need to place quotes around the “C:\Program Files\Java\jdk1.6.0_05\jre\bin\client\jvm.dll”
The service will not recognise the path if it has spaces and not surrounded by quotes.
Ciaran
ctxw said
Hi All,
I am facing the same issue as Egide, does anyone know might had went wrong?
Thanks in advance!
Quote from Egide:
Egide said
May 29, 2008 at 2:37 pm
Hi Venkat,
Any idea why I’m not able to see the BI login screen, when I enter the url(http://egidej01:9704/analytics/saw.dll?Answers)
on a different machine than the one the BI server is running, after I’ve set up the oc4j service, as you described above?
On the machine where the BI server is installed, I’m able to startup BI.
When I stop the service and start the OC4J by the old fashioned way, everything works well.
Thanks,
Egide
ctxw said
Hi All,
I am facing the same issue as Egide, does anyone know might had went wrong?
Thanks in advance!
Quote from Egide:
Egide said
May 29, 2008 at 2:37 pm
Hi Venkat,
Any idea why I’m not able to see the BI login screen, when I enter the url(http://egidej01:9704/analytics/saw.dll?Answers)
on a different machine than the one the BI server is running, after I’ve set up the oc4j service, as you described above?
On the machine where the BI server is installed, I’m able to startup BI.
When I stop the service and start the OC4J by the old fashioned way, everything works well.
Thanks,
Egide
Goutam said
Hi Venkat
Thanks a lot for this tip.
I succefully installed the service. First time it worked very well.
The next time I booted the computer, the service did not start automatically.
Also, When I started it in the services (manually), it started and stopped immediately. It gave a message indicating that, “the service started and then stopped, some windows services will be stopped if it is not used by other services or applications”. I tried restarting and the same message appeared. Please help. Thanking you again, I will wait for your reply.
Seems said
Hi Venkat,
I created the service using the above command & everything seems to be working fine except that the server didnot stop when I stopped the service.
However the issue I am facing now is that after starting the server from this newly created service, I am unable to work with any reports. Also cannot view the Demo reports. I see a folder path to the repository folder & it gives a xdo error.
Have you faced such an issue & have a solution for the same?
Thanks
Seems
David said
Hi all,
I’ve tried all the solutions mentioned above, but I still get the following error:
Error attempting to install the Oracle BI EE service
Access is denied.
Any help is welcome
kind regards,
David
Henk said
Hi all,
@David, I have the same problem. I am trying this under Vista, Vista I think is the problem since I have no had this problem under any other OS yet.
If anyone has a suggestion this would be more then welcome.
kind regards,
henk
Karn said
Hi Venkat,
I installed BI publisher desktop edition and then the jdk, jre, .net framework, when I try starting the service it says using the above command from cmd, it says unknown internal or external command (refers javaservice).
Please help.
Karn
Marek said
Hi,
If you’re facing problem with:
Error attempting to install the Oracle BI EE service
Access is denied.
try to set JAVA_HOME variable, and than try to start service – Java 1.6 SDK installation doesn’t set this variable by default.
Hope this helps.
Marek
Iain said
Tried this and it created the service but it didn’t actually work. eg I logged off and then it stopped. The only difference I can see is that I used the jre instead of jdk….and it was a slightly older iteration _02. However it still had the client.dll so I would have still expected it to work.
Doesn’t give any error to speak of. The service it self does start and stop fine….just seems to stop when i log out.
Cheers IAin
Luntu said
Hi Guys
i created oc4j as windows service using the following cmd script format:
“C:\Program Files\JavaService\JavaService.exe” -install “Oracle BI OC4J Server” “C:\Program Files\Java\jre1.5.0_19\bin\client\jvm.dll” – XX:MaxPermSize=128m -Xmx512m “- Djava.class.path=D:\OracleBI\oc4j_bi\j2ee\home\oc4j.jar” -start oracle.oc4j.loader.boot.BootStrap -description “Oracle BI Oc4J Service
After restarting my machine under services, all other services are started up but OC4J Server, is not started automatically, then when i tart it manualy it gives me an error:” The Oracle BI Server Service on Local Computer started and then stopped. Some services stop automaticaly if they have no work to do, for example, the Perfomance Logs and Alerts service. ”
Please help me guys.
Kind Regards,
Luntu
Vandana said
we are able to create the service but the service fails to start. It gives an error message “Could not start the service. the service dod not return an error. the problem could be an intrenal windows error or an internal server”
Christian said
Update on artofbi.com
Christian said
I put a recent post together which uses a more centralized, non third-party Microsoft solution that works even better for creating a windows services here, http://www.artofbi.com/index.php/2009/11/essbase-studio-oc4j-as-a-windows-service/
Bibin Kumar said
Worked perfectly. Thanks for the post.