ZENworks Reporting Server fails to find Oracle Client version

  • 7001798
  • 05-Nov-2008
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Business Objects Reporting

Situation

Error during installation of ZENworks Reporting Server version 10.1 or higher using Oracle external database.
 
ERROR:  "Setting ORACLE_CLIENT_INSTALLED to false "

Resolution

Be sure that the Oracle client is the correct version for 10g to match the back end database version.  Be sure that ORACLE_HOME points to the correct location of the Oracle client setup and that tnsping works.

Additional Information

To test the setup on Windows run:
 
reg query HKLM\SOFTWARE\ORACLE\ /s /f ORACLE_HOME /t REG_SZ /c /e
 
this should return the proper path to the ORACLE_HOME .  In that path under bin directory should be tnsping.exe .  Running tnsping.exe should return proper version information.
 
For linux, the ORACLE_HOME is defined in the environment (env ).
 
In one case where an earlier Oracle client version 9 had been uninstalled, there were two registry entries for ORACLE_HOME .  After the improper (non existent path location) was removed from the registry, the install was successful.