Business Intelligence – Oracle

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.

About these ads

31 Responses to “Oracle BI EE 10.1.3.3/2 – Creating Windows Service for BI EE OC4J”

  1. Adrian ward said

    Copycat! I blogged about this yesterday. :)

  2. 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.

  3. 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

  4. 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.

  5. 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

  6. 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

  7. 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

  8. Arjun said

    Hi Venkat,
    I got it.
    Thanks
    Joshi

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. Selva said

    Hey, now its working good…… there is a typographical error..
    Thanks – Selva

  15. 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

  16. Ciaran said

    I’m also getting the same error as Den,

    Any ideas anyone?

  17. 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

  18. 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

  19. 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

  20. 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.

  21. 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

  22. 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

  23. 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

  24. 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

  25. 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

  26. 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

  27. 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”

  28. Christian said

    Update on artofbi.com

  29. 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/

  30. Worked perfectly. Thanks for the post.

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

 
Follow

Get every new post delivered to your Inbox.

Join 151 other followers

%d bloggers like this: