Oracle DB Installation

Drivers

Bitnami Windows Install

Note: These instructions are applicable for DreamFactory 2.1.0-4 and older. Starting in DreamFactory 2.1.1 you will need to use Oracle Instant Client 12

• Download the Oracle Instant Client here
  • You will need to download the appropriate version for your version of Oracle (i.e Instant Client 11 goes with Oracle 11g server.)
  • Since the Windows Bitnami stack is only 32-bit you need to download the 32-bit instant client
  • You will also need an Oracle login for this (free registration.)
• Extract the zip file to your preferred location, such as C:\instantclient_11_2
• Edit the php.ini file (C:\Bitnami\dreamfactory-x.x.x-x\php\php.ini)
  • Uncomment (remove the semicolon) from the line that says

    ;extension=php_oci8_11g.dll

  • For Oracle Instant Client 12, the line will be denoted with a comment indicating it requires uncommenting

    ;extension=php_oci8_12c.dll  ; Use with Oracle Database 12c Instant Client

• Edit your PATH variable.
  • Go to Control Panel->System->Advanced System Settings
  • Click on Environment Variables
  • Under System variables, double click on Path.
  • At the end of the Variable value, add the path to the instant client directory (see above.) Use a semicolon to separate this new entry from the current last entry.

    ;C:\instantclient_11_2

• Restart the system

Linux

Bitnami Linux Install

• Download the Oracle Instant Client here
  • You will need to download the 11.2 Instant Client basic
  • You will also need an Oracle login for this (free registration.)
• Extract the zip file to your preferred location, such as ~/instantclient_11_2
• Edit the php.ini file (~/dreamfactory-x.x.x-x/php/php.ini)
  • Uncomment (remove the semicolon) from the line that says

    ;extension=oci8.so

• Edit the setenv.sh file ( ~/dreamfactory-2.0.2-0/scripts/setenv.sh ) Note: Paths specified are user supplied and specific to your environment. Please make corresponding changes if required.
  • Add the following to the end of the file and save, just before the line that says . /home/user/dreamfactory-2.0.2-0/scripts/build-setenv.sh add

LD_LIBRARY_PATH=/home/user/instantclient_11_2:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

• Edit the envvars file (/dreamfactory-2.0.2-0/apache2/bin/envvars)
  • Add the following to the end of the file and save

DYLD_FALLBACK_LIBRARY_PATH=/home/user/instantclient_11_2

• Restart Apache

Manual Install from Github on Linux

These instructions are Ubuntu/Debian based===SQLSRV===

• DreamFactory specific instructions for Ubuntu 16.04:
  • OCI8 on Ubuntu 16.04