Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot enable OCI8 using php5_6

ramonmitcsOct 20 2016 — edited Oct 25 2016

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

This post has been answered by ramonmitcs on Oct 25 2016
Jump to Answer

Comments

PHP 5.6 & OCI8 with 12c Oracle Client work - otherwise the OCI8 extension wouldn't build.

Have you tried command line scripts (i.e without Apache)?

ramonmitcs

thank you cj, can you elaborate what you mean with trying command line scripts?

ramonmitcs
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

Marked as Answer by ramonmitcs · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2016
Added on Oct 20 2016
3 comments
5,117 views