Oracle DB

From DreamFactory
Jump to: navigation, search
(Bitnami Windows Install)
(Bitnami Windows Install)
 
Line 1: Line 1:
  
 
===Bitnami Windows Install===
 
===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  
+
'''Note:''' These instructions are applicable for DreamFactory 2.1.1+ and you will need to use Oracle Instant Client 12.1.0.2.0 +
 
*Download the Oracle Instant Client [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html  here]
 
*Download the Oracle Instant Client [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html  here]
 
**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 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
+
**Since the Windows Bitnami stack is 64-bit you need to download the 64-bit instant client
 
**You will also need an Oracle login for this (free registration.)
 
**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
 
*Extract the zip file to your preferred location, such as C:\instantclient_11_2

Latest revision as of 23:00, 24 October 2018

Bitnami Windows Install

Note: These instructions are applicable for DreamFactory 2.1.1+ and you will need to use Oracle Instant Client 12.1.0.2.0 +

  • 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 64-bit you need to download the 64-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