If the Oracle Server and OWB Client are not on a single machine please read the Oracle Warehouse Builder Installation and Administration Guide to ensure a valid Oracle/OWB configuration exists.
When the reporting build commands are running on a machine that only has the OWB Client installed i.e. no Oracle instance, then:
- Set ORACLE_HOME to the parent directory of OWB_HOME. This is to enable the build scripts to find the loadjava.bat and javac.exe files. (ORACLE_HOME dependencies: loadjava.bat & jdk).
- PATH - ensure %ORACLE_HOME%/bin is at the beginning of the Path Environment Variable, with %JAVA_HOME%\bin next.
- In the BIApplication.Properties file set the environment.jdbc.jar to the path of the jdbc driver that contains the driver defined in the driver properties =
- (Path in OWB machine)\ojdbc5.jar for Oracle 11gR2
E.g.
- C:\\oracle\\product\\11.2.0\\db_1\\jdbc\\lib\\ojdbc5.jar