This is to fix the issues related to 32 Bit wamp server installed on windows 64
I have composed these steps after researching in many blogs/forums for the errors as
unable to load dynamic library php_oci8_12c.dll - the specified procedure could not be found
1. Download
wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10.exe
instantclient-basic-nt-12.2.0.1.0.zip (32 bit, check readme file)
1. Extract instantclient-basic-nt-12.2.0.1.0.zip into any local folder ex: d:\oracle32bitclient
2. Install wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10.exe
3. set path using system->Advanced system settings->environemnt variables->system variables
select path
click new
add d:\oracle32bitclient\instantclient_12_2 (where all DLLs are available)
4. goto command prompt, execute below path to make sure the above path is added in path variable, if not goto 5
echo %path%
5. goto command prompt
set path=%path%;d:\oracle32bitclient\instantclient_12_2
execute below command to see the above path can be seen
echo %path%
5. by default wamp points to version php5.6.25
goto C:\wamp\bin\php\php5.6.25
locate php.ini and open in notepad/textpad to edit
search for "extension_dir"
make sure there is no prefix of ';' and pointed to correct path (this is set by wamp installation)
ex: extension_dir ="c:/wamp/bin/php/php5.6.25/ext/"
in the same php.ini
search for oci8
you may find as below
extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
wamp installer comments this line by default
so remove ; before this line
save php.ini
6. start wamp server. Once started, on the system tray you can see wamp icon (in green color), click on this (not right click, its left click)
verify below
under "PHP"
verion
is defaults to 5.6.25
PHP extensions
php_oci8_12c -- this is not selected by default
now select this
7. again click on wamp server (if you see it is green, if not green wait until it turns green as it might have restarted for above changes)
8. select restart all services
9. Once wamp server is ready with green you can verify (step 6 again)
10. open command prompt
11. cd c:/wamp/bin/php/php5.6.25/ (for you where php 5.6.25 is located)
12. execute the below
php -v
this should give current php version without any warnings
php --ri oci8
this gives the current statuses of oci8
13. create a simple oci8 test script whether you can connect oracle
make sure you have any local database or remote database connection with below information
server name or localhost
database name, user and password
if it is xe database, create a simple php file as below
make sure user, password, database are correct
<?php
$conn = oci_connect('system','welcome', 'xe');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
echo "connected"
?>
and save as testoci8.php under C:\wamp\www
14. now, open any browser and execute the url
http://localhost/testoci8.php
it should display "connected" without any other information
fatal error call to undefined function oci_connect
15. If you still see any fatal error with undefined oci_connect
copy the below files from instant client location (in this example d:\oracle32bitclient\instantclient_12_2)
oci.dll
oraociei12.dll
oraons.dll
to wamp/bin/apche/apache<version>/bin -- version is your current version
and restart apache and try http://localhost/testoci8.php
(** I have faced this issue during installation on one of my laptops)
I have same configuration as other and wamp, instant client all are same but I could not use oci_connect
not sure why it did not connect, after researing for 3 to 4 day I found this fix in one of the blogs
