Currently we have deployed the Oracle BI Publisher 10.1.3.4.2 manually unpacking the xmlpserver.war
file to a separate folder in the server and deployed the BI Publisher as an application in
existing EBS residing Oracle Weblogic 10.3.6 and working as expected.
Currently we are working on implementing BI Publisher (10.1.3.4.2) on Apache Tomcat(v11)
because it doesn’t require Oracle Weblogic Suite (additional cost on Weblogic Suite license).
Note: In this approach, we tried as per oracle documentation Apache Tomcat/5.5.36
Initially, we have installed latest Apache Tomcat (v11) and configured the BI publisher but the BI publisher deployment didn’t start as the BI publisher version is quite old and it is not supported for the latest Apache tomcat.
Next, we tried to downgraded the Apache Tomcat (v9) and configured the BI publisher, here the deployment was successful but had issues in reaching the URL and logging into the BI publisher URL.
Currently, we have downgraded the Apache Tomcat further to (v5) and configured the BI publisher,
here the deployment was successful, URL reaching was successful and logging into the report server is also successful,
but currently we are facing issues while configuring the data source / db connection as the jar file and we have tried
use the jar files (ojdbc8.jar, ojdbc10.jar, ojdbc6.jar, ojdbc5.jar) from database binaries, webtier and wlserver_10.3
but the db connection is not establish.
Kindly guide us if any one have idea about install the BI publisher on Apache Tomcat/5.5.36.