Oracle Drivers will not work if MSVC++ Runtimes not Installed on OS

Synopsis:

The Oracle driver distributed with the Bitnami Windows installer is not present. Therefore, for enabling the option the database connection with Oracle in ProcessMaker, there are some additional steps to follow.

Bitnami recommends:

  1. Editing the file php.ini and enable/uncomment the line: extension=php_oci8_12c.dll
  2. Doing the step #1 should be enough according to Bitnami, however, it does not really work.
  3. Visit documentation https://docs.bitnami.com/installer/components/php/#how-to-install-the-oci8-module

Work-arounds:

Steps to enable Oracle in Windows

  1. Download Oracle Instant Client DLLs from here: https://transfer.sh/11uPt3/OracleInstantClient12.1DLLs.zip
  2. Extract DLLs in Bitnami Apache bin directory. 
    1. Directory example:  C:\Bitnami\processmaker-3.2-0\apache2\bin
  3. Edit Bitnami php.ini to include OCI 8 DLL. 
    1. Directory example:  C:\Bitnami\processmaker-3.2-0\php
    2. Uncomment oci8 extension in php.ini :  extension=php_oci8_12c.dll
  4. Restart Apache service.

This was successfully tested using Bitnami ProcessMaker 3.2 x64 and Oracle 11g DB.

Associated JIRA Tickets:

https://processmaker.atlassian.net/browse/KR-3345