When completing a configuration of Service Desk Manager to an Oracle database the configuration fails to connect to the database. Within the configure.log file an error is logged "Unable to load the OCI library or DLL. Cannot continue!"
This error is typically seen if a 64bit Oracle client is installed on the Service Desk Manager server. Service Desk Manager requires the 32bit Oracle libraries in order to establish connection to the Oracle database.
1) Install the 32-bit Oracle Client software to a separate oracle base location
-do NOT install the "Instaclient" - but rather use the "Administrator" option
Include the path to the 32bit Oracle library (lib) directory in the windows PATH
After the client install completes point the LD_LIBRARY_PATH to the client's "lib" directory and the CA Service Desk Manager "lib" directory for the root user
Example: edit /etc/profile and set the LD_LIBRARY_PATH as follows
NOTE: If you are adding the “$LD_LIBRARY_PATH”, append it to the end of the export line. The client lib needs to come before any other oracle lib directory references as programs will go with whatever they find first.
3) Re-Run pdm_configure, which should now proceed.