Tuesday, July 7, 2015

Configuring XAMPP 1.8.1, Oracle XE 11G R2 x64 & Windows x64

System requirement:
  1. VC9
  2. XAMPP 1.8.1
  3. Oracle XE 11G R2
I assumed those requirement already install.
NOTE:
XAMPP 1.8.1 is 32 bits application, therefor, it needs Oracle Instance
Here is steps to configure XAMPP 1.8.1 & Oracle XE 11G x64 work in the same PC:
  1. Download instant client and SDK use this link: http://www.oracle.com/technetwork/topics/winsoft-085727.html
    1. oracle instant client instantclient-basic-nt-11.2.0.4.0.zip
    2. oracle SDK instantclient-sdk-nt-11.2.0.4.0.zip
  2. Extract into C:\instantclient_11_2
    1. oracle instant client instantclient-basic-nt-11.2.0.4.0.zip
    2. oracle SDK instantclient-sdk-nt-11.2.0.4.0.zip
  3. set and or add into path
    C:\instantclient_11_2;C:\oraclexe\app\oracle\product\11.2.0\server\bin;
    Note: DO NOT put C:\instantclient_11_2 after C:\oraclexe\app\oracle\product\11.2.0\server\bin;
  4. Edit php.ini, unset
    ;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
    extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
    Note: only 1 dll can be activated, for Express edition use extension=php_oci8_11g.dll
  5. Restart apache

No comments:

Post a Comment