Business Intelligence – Oracle

Archive for February 15th, 2008

Oracle Data Miner 11g – Available for Download

Posted by Venkatakrishnan J on February 15, 2008

I came to know this via Charlie Berger, Oracle Data Mining Product Management. Oracle Data Miner UI for 11g is now out for download. One can download it from here. This contains some 2 new algorithms (Logistic Regression and Multiple Regression) and a number of enhancements. For more details i would recommend you to check this out here. I think its time for me to start blogging about some data mining features and how BI EE and data mining can actually work together. Charlie Berger had in fact offered me before to give a quick tutorial on the various data mining features(Thanks Charlie for that offer!!!, i believe i need it now!!!). Somehow, i never got around doing any of those before. Maybe its time for me to start working with Ramkumar Krishnan(his blog has some excellent technical details on ODM) and Charlie to blog about some interesting points of integration between BI EE and ODM.




Posted in All Posts, Data Mining | 4 Comments »

Oracle BI EE – 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.

Posted in All Posts, OBI EE Plus | 31 Comments »