Oracle DB Installation

Revision as of 18:17, 16 December 2015

1. 1. Drivers
      1. Windows (Bitnami)

• Download the Oracle Instant Client [here](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html).
  • 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

• 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

1. 1. 1. Linux
         1. Bitnami Linux Install

• Download the Oracle Instant Client [here](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html).
  • You will need to download the appropriate version for your version of Oracle (i.e Instant Client 11 goes with Oracle 11g server.)
  • 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/build-setenv.sh )
  • Add the following to the end of the file, just before the line that says . /home/user/dreamfactory-2.0.2-0/scripts/build-setenv.sh

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

1. 1. 1. 1. Manual Install from Github on Linux

• These instructions are Ubuntu/Debian based
• Download the Oracle Instant Client [here](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html).
  • Get both the basic client and the sdk (two files)
  • You will need to download the appropriate version for your version of Oracle (i.e Instant Client 11 goes with Oracle 11g server.)
  • You will also need an Oracle login for this (free registration.)
• Extract the instant client basic zip file to your preferred location, such as /opt/instantclient_11_2
• Extract the sdk zip to the same location. There should be a sdk folder inside the main instantclient_11_2 folder
• Ensure that you have the php-pear and php5-dev packages installed on your system

  • $ sudo apt-get install php-pear php5-dev

• Use PECL to install the oci8 so file.

  • $ sudo pecl install oci8

  • You will be asked for the type of install and location of library. Use instantclient and the location where you extracted the files above. ex: "instantclient,/opt/instantclient_11_2"
  • If the the install generates any errors it will fail you. You will need to troubleshoot based on the error reported.
• Create a module file for your oci8 installation.

  • $ sudo touch /etc/php5/mods-available/oci8.ini

• Edit the file you just created in your preferred text editor.
  • There is a single line in the file it looks like this:

  • extension=oci8.so

• Enable the php extension

  • $ sudo php5enmod oci8

• Restart your web service service

  • $ sudo service apache2 restart

    or

  • $ sudo service nginx restart