Normally if we install OBIEE it will run on "OC4J"Application Server , but i want to run my analytics file to run on Apache Tomcat Server
Prerequisites : Apache Tomcat Server 4 and above
Here is the link to download tomcat server : click on Windows service installer (under Core category).I used Tomcat 5.5,download it and install .Start the service
http://tomcat.apache.org/download-55.cgi
I will explain in two parts
Part1 : Deploying Analytics.war file (BI Answers,Dashboards,BI Delivers)
Part2 : Deploying XMLPSERVER.war file (BI Publisher)
Deploying Analytics.war file:
Step1 : Stop your Tomcat Server(if it's already started mode)
Step2 : Take a copy of anlaytics.war file from following location
"\OracleBI\oc4j_bi\j2ee\home\applications\analytics"
Step3 : Paste it under webapps folder of Apache server installed driver
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps
Step4: I had taken Myanaltyics.war
Create a folder called Myanalytics/your_name,paste your analytics.war file into this newly created folder
Prerequisites : Apache Tomcat Server 4 and above
Here is the link to download tomcat server : click on Windows service installer (under Core category).I used Tomcat 5.5,download it and install .Start the service
http://tomcat.apache.org/download-55.cgi
I will explain in two parts
Part1 : Deploying Analytics.war file (BI Answers,Dashboards,BI Delivers)
Part2 : Deploying XMLPSERVER.war file (BI Publisher)
Deploying Analytics.war file:
Step1 : Stop your Tomcat Server(if it's already started mode)
Step2 : Take a copy of anlaytics.war file from following location
"\OracleBI\oc4j_bi\j2ee\home\applications\analytics"
Step3 : Paste it under webapps folder of Apache server installed driver
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps
Step4: I had taken Myanaltyics.war
Create a folder called Myanalytics/your_name,paste your analytics.war file into this newly created folder
Open your command prompt: Goto your newly created folder structure
Enter the following command: Jar –xvf Myanalytics.war
Next ,Start your Tomcat Server
Start Menu-->All Pograms-->Apache Tomcat 5.5--->Welcome
Start Menu-->All Pograms-->Apache Tomcat 5.5--->Welcome
Click on Tomcat Manger -->It may ask username and password you need to give right credentials (if u specify at installation of apache)
Under the Application 's you will see "/MyAnalytics"
Under the Application 's you will see "/MyAnalytics"
Click on Myanalytics it will take you to our Normal OBIEE Login screen
Create your reports and dashboard all will work same as before
Part2 : Deploying XMLPSERVER.war file
Follow the same steps as above but , now take xmlpserver.war file at (C:\OracleBI\oc4j_bi\j2ee\home\applications\xmlpserver) location
Repeat the steps 1,2,3 from part1 but with xmlpserver.war file
When you start the services and go to tomcat welcome page it will show xmlpserver...click on that
Wait...before doing that we need to change file path xmlp-server-config.xml file
located at
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\xmlpserver\WEB-INF
{file path="C:\OracleBI\xmlp\XMLP"/}
point the path to obiee installed xmlp folder
Restart the server,BI Publisher will run on tomcat as Dashboards
URL's in my case
BIPublisher : http://127.0.0.1:1234/xmlpserver/
Dashboards : http://127.0.0.1:1234/Myanalytics/saw.dll?Dashboard/
Create your reports and dashboard all will work same as before
Part2 : Deploying XMLPSERVER.war file
Follow the same steps as above but , now take xmlpserver.war file at (C:\OracleBI\oc4j_bi\j2ee\home\applications\xmlpserver) location
Repeat the steps 1,2,3 from part1 but with xmlpserver.war file
When you start the services and go to tomcat welcome page it will show xmlpserver...click on that
Wait...before doing that we need to change file path xmlp-server-config.xml file
located at
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\xmlpserver\WEB-INF
{file path="C:\OracleBI\xmlp\XMLP"/}
point the path to obiee installed xmlp folder
Restart the server,BI Publisher will run on tomcat as Dashboards
URL's in my case
BIPublisher : http://127.0.0.1:1234/xmlpserver/
Dashboards : http://127.0.0.1:1234/Myanalytics/saw.dll?Dashboard/
Hi Sai Chand,
ReplyDeleteGood Post.For analytics its working good.But while doing the same for xmlpserver i am facing this error org.apache.jasper.JasperException: com/phaos/crypto/CipherException.
Suggest me solution for this...
Thanks Sai,for your comments
ReplyDeleteIn that case you need to copy the library files in \OracleBI\oc4j_bi\lib\.... from C:\Program Files\Apache Software Foundation\Tomcat 5.5\shared\lib\*... means tomcat installed shared\lib folder .
Good Post. I have installed OBIEE 10.1.3.2 on Linux machine where Apache is installed. Oc4j, BI server & presentation server are working fine.
ReplyDeleteBut i am not able to open the Login page for OBIEE. I have inserted default.jsp entry in .conf file, but it opens the default page. JSP page is not parsed. Hence unable to redirect to ...saw.dll?Dashboard
httpd is running. Also, saw.dll file is not available on the machine.
Any hints as to what could be wrong.
Why you are using oc4j again? Have tried with Apache link ? is that accessible or not
ReplyDeleteThanks for ur reply.
ReplyDeleteI have stopped Oc4j now. Apache server is started.
When i open localhost page, I can see a page which has following message
<%
response.sendRedirect("saw.dll?Dashboard");
%>
The page is not parsed.
saw.dll file is also missing.
I have used RH_Linux folder contents for the installation. Is it possible that some data might be missing on CD?
Kindly suggest something.
hi,
ReplyDeleteThanks for your comments
one thing why you have changed your default.jsp file ? I guess no need to change u can direclty use the url given by apache/analytics it will take u to default obiee login page.because if u observe the Analytics.war file there u have default.jsp,we are deploying the same thing on Apache.Finally no need to change the url .Thats what i explained by screen shot after it got deployed just use the apache url no need of changing any url.If you are facing any problem let me know
This comment has been removed by the author.
ReplyDeleteHI Sai Chand,
ReplyDeleteThanks for the post.Helpful.
I followed all the instrucation but while logging into tomcat manager with crct credentials am getting page with error:
HTTP Status 403 - Access to the requested resource has been denied
type Status report
message Access to the requested resource has been denied
description Access to the specified resource (Access to the requested resource has been denied) has been forbidden.
Apache Tomcat/5.5.31.
Please help me over here.
THanks,
AJay
Try it on Different version tomcat 6
ReplyDelete@Ajay,you can refer this
ReplyDeletehttps://issues.apache.org/jira/browse/JS2-496
THanks Sai. It works for me with Tomcat 6. Actualy am facing with the issue in production support project for HRBI apps that Apache.exe process is using 100% CPU causing other apps to cease and the server gets choke off. So Any idea regarding why this would happen ?
ReplyDeleteAny help is really appreciated.
Thanks