Xampp 7.0.9 Portable, Apache issue with oci.dll 10.2.0.1

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Xampp 7.0.9 Portable, Apache issue with oci.dll 10.2.0.1

Postby mach128x » 13. September 2016 23:24

Hi gents,

First of I'm new here and I'm somewhat of a newbie at Xampp, Apache and PHP. While I wouldn't say I am an expert, I'm not a newbie at messing with computers or programming in general.

The issue
So I have a portable installation of Xampp v7.0.9 . Everything works fine with the bundled MySQL setup, but I'm having issues getting to a working setup with Oracle DB. I'm getting an error with oci.dll, as you will see below.
I have v10.2.0.1 of the full (not instant) Oracle Client installed (this is based on the version of oci.dll).
The PATH system variable points to the BIN of the Oracle Client i.e. C:\APP16\Oracle\Ora10g\client_1\BIN\
The ORACLE_HOME system variable is set to C:\APP16\Oracle\Ora10g\client_1

Details :

XAMPP version
version number : 7.0.9
bundle version : portable
install file type : xampp-portable-win32-7.0.9-1-VC14.zip

operating system version

Major version : Windows 7
edition : Professional
bit compilation : x64
Service Pack level : SP1

XAMPP installation path

C:\Data\pol\Apps\xampp\

any configuration changes made since installation
Did you execute some script? : I ran setup_xampp.bat to reset directories
Or used the XAMPP security script? : nope
Or changed anything in the config files? I un-comented the line "extension=php_pdo_oci.dll" in C:\Data\pol\Apps\xampp\php\php.ini

full qualified issue report

actions (What exactly do you do) : load Xampp Control Panel, then click to load Apache
expected reactions (What do you expect should happen) : Apache loads without errors
received reactions (What really happens) : I get this error message twice, "The procedure entry point OCILobClose could not be located in the dynamic link library OCI.dll"

XAMPP control panel log
Either from the XAMPP control panel log window itself or from the \xampp\control-panel.log file
---> I don't have this file... see Appache error log below

Log file contents of the specific component
Code: Select all
[Tue Sep 13 17:57:44.962998 2016] [mpm_winnt:notice] [pid 10472:tid 256] AH00455: Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9 configured -- resuming normal operations
[Tue Sep 13 17:57:44.962998 2016] [mpm_winnt:notice] [pid 10472:tid 256] AH00456: Apache Lounge VC14 Server built: Jul  1 2016 11:09:37
[Tue Sep 13 17:57:44.962998 2016] [core:notice] [pid 10472:tid 256] AH00094: Command line: 'c:\\data\\pol\\apps\\xampp\\apache\\bin\\httpd.exe -d C:/Data/POL/Apps/xampp/apache'
[Tue Sep 13 17:57:44.972997 2016] [mpm_winnt:notice] [pid 10472:tid 256] AH00418: Parent: Created child process 8688
[Tue Sep 13 17:57:45.942968 2016] [ssl:warn] [pid 8688:tid 268] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Sep 13 17:57:46.202960 2016] [ssl:warn] [pid 8688:tid 268] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning:  PHP Startup: Unable to load dynamic library '\\Data\\POL\\Apps\\xampp\\php\\ext\\php_pdo_oci.dll' - The specified procedure could not be found.\r\n in Unknown on line 0
[Tue Sep 13 17:57:46.922939 2016] [mpm_winnt:notice] [pid 8688:tid 268] AH00354: Child: Starting 150 worker threads.


Windows event log entries of the specific component

(only needed if running the component as windows service) --> not my case
mach128x
 
Posts: 4
Joined: 03. September 2016 19:19
XAMPP version: 7.0.9
Operating System: MS Windows 7 / 8 / 8.1 /10 Pro

Re: Xampp 7.0.9 Portable, Apache issue with oci.dll 10.2.0.1

Postby mach128x » 14. September 2016 17:40

I decided to bypass the Oracle full client installation.
I extracted v10.2.0.5 of the x86 Oracle Instant Client to some directory, edited the path system variable accordingly et voilà, problem solved.
Maybe it was some incompatibility btw Apache and the v10.2.0.1 client, or the installation was messed up, who knows. But all is well now 8)
mach128x
 
Posts: 4
Joined: 03. September 2016 19:19
XAMPP version: 7.0.9
Operating System: MS Windows 7 / 8 / 8.1 /10 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 133 guests