ZRS fails with database connection error

  • 7004585
  • 01-Oct-2009
  • 08-Nov-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2 Business Objects Reporting

Situation

When running any report from one specific reporting server, the following error message happens:
 
A database error occured. The database error text is: (CS) "DBDRIVER failed to load: /opt/novell/zenworks/share/boe/bobeje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/libdbd_oci10.so (libclntsh.so.10.1: cannot open shared object file: No such file or directory)" . (WIS 10901)

Resolution

Check the rights to the root and subdirectories of the Oracle client directory structure. Verify that 'read' and 'execute' rights (755) recursively, are set.

Additional Information

System is configured with an external Oracle database,ZRS and BOE installed on SLES 10sp2.
 
This is a general error message indicating a failure to connect to the database.  If environment variables such as LD_LIBRARY_PATH or rights for the zenworks user are incorrect, this error may also occur.