[FIXED] How to enable oci in xampp 5.6.3?

Issue

I am facing some issue while starting Apache server via XAMPP. I have installed XAMPP Version 5.6.3.

When I start the Apache server from xampp control panel, an error message is displayed as shown below:

On clicking 'OK' button, another dialog box is displayed as shown:

The thing is I wanted to use OCI instead of mysql. so I have commented out the mysql extensions and uncommented the OCI extension in php.ini file.

The php_oci8_12c.dll file is the only file available in the extensions (ext) folder of php in xampp. Hence I included the line in the php.ini as shown in the above image.

Since then I am getting this error.

I have installed instant client 12.1 as well but no luck. I also tried copying the OCI.dll from instantclient_12_1 and pasting it in c:/xampp/php and c:/xampp/apache/bin. The error still persists.

Need help..

UPDATE: I removed other oracle paths in PATH of environment variables, keeping only the instantclient path. Now I am getting this error..

Solution

I solved the issue. The problem was that I was trying to use a 64 bit DLL(php_oci8_12g.dll) in a 32 bit PHP. I downloaded a 32 bit instantClient and it works now! :-)

instantclient-basic-nt-12.1.0.2.0.zip

Answered By - Harshrossi

Answer Checked By - Katrina (PHPFixing Volunteer)