OWB client is not installed on the Oracle server

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:

  1. 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).
  2. PATH - ensure %ORACLE_HOME%/bin is at the beginning of the Path Environment Variable, with %JAVA_HOME%\bin next.
  3. 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.
    • Oracle: C:\\oracle\\product\\11.2.0\\db_1\\jdbc\\lib\\ojdbc5.jar
    • UNIX: file://oracle/database/oracle112/jdbc/lib/ojdbc5.jar
Parent topic: BIApplication.properties, BIBootstrap.properties and Environment Variable Setup