Forum Stats

  • 3,826,039 Users
  • 2,260,589 Discussions
  • 7,896,770 Comments

Discussions

cannot enable OCI8 using php5_6

ramonmitcs
ramonmitcs Member Posts: 13
edited Oct 25, 2016 3:08AM in PHP

hi,

I was able to install php 5.4 and oracle 11g with no problems at all using oracles guide. But I can't enable oci8_12c with php version 5.6 and apache 2.4. Been trying this for almost a week and from readings it seems to be incompatibility with oci8 and the oracle instant client. What i have been done so far:

Operating System windows 7 professional service pack 1

Using guide http://www.oracle.com/technetwork/articles/dsl/technote-php-instant-12c-2088811.html

Install apache 2.4 httpd-2.4.23-win32-vc11

Checked it thru httpd –v

Server version: Apache /2.4.23 (win32)

Server built: Jul 7 2016 11:13:22

Installed modules-2.4-win32-vc11 for mod_fcgid-2.3.9

  1. Fossies.org -> mod_fcgid.so

Checked httpd –t –D DUMP_MODULES

Installed Microsoft Visual C++2012 Redistributable(x86)-11.0.61030

Installed php-5.6.26-nts-Win32-VC11-x86

Installed instantclient-basic-nt-12.1.0.1.0

Copied php_oci8_12c.dll to php-5.6.26-nts-Win32-VC11-x86/ext

**** I tried this one at a time

  • default php_oci8_12c.dll that comes with php-5.6.26-nts-WIN32-VC11-x86
  • Installed php_oci8-2.0.8-5.6-nts-vc11-x86
  • Installed php_oci8-2.0.10-5.6-nts-vc11-x86
  • Installed php_oci8-2.0.11.5.6-nts-vc11-x86
  • Installed php_oci8-2.0.12.5.6-nts-vc11-x86

Installed instantclient-basic-nt-12.1.0.2.0

Copied php_oci8_12c.dll to php-5.6.26-nts-Win32-VC11-x86/ext

**** I tried this one at a time

  • default php_oci8_12c.dll that comes with php-5.6.26-nts-WIN32-VC11-x86
  • Installed php_oci8-2.0.8-5.6-nts-vc11-x86
  • Installed php_oci8-2.0.10-5.6-nts-vc11-x86
  • Installed php_oci8-2.0.11.5.6-nts-vc11-x86
  • Installed php_oci8-2.0.12.5.6-nts-vc11-x86

I can run phpinfo(), but the result shows no oci8 enabled.  From readings it says to copy files from instant client to php/ext but i don't know which files. I have checked the path and the instantclient_12_1 is written there. I never thought it would be so hard installing this version, has anyone been successful with this setup? Any tips, sites or guide is highly appreciated. I don't know what to do next.

thank you ,

Mon

Best Answer

  • ramonmitcs
    ramonmitcs Member Posts: 13
    edited Oct 25, 2016 3:08AM Answer ✓

    This problem was caused by the oci.dll of the oracle 11g xe database which was installed in the same computer where php/apache is installed. To resolve this i copied the oci.dll of the oracle client 12c to the php installation directory where php.exe resides. Also if you get an error of msvcr100.dll just download it and install it to the windows\system32 directory.

    Regards,

    Mon

Answers

This discussion has been closed.