how to fix in IIS: PHP Warning: PHP Startup: Unable to load dynamic library 'php_oci8.dll' (tried: C:\php-7.4.33\ext\php_oci8.dll (Access is denied.)

JerryBE 0

Could you help me to solve this ?

In IIS with Oracle & php I have this on error log PHP:

PHP Warning: PHP Startup: Unable to load dynamic library 'php_oci8.dll' (tried: C:\php-7.4.33\ext\php_oci8.dll (Access is denied.)

I check on the net what I can do and nothing work.

Jerry

Yurong Dai-MSFT 2,776 Reputation points Microsoft Vendor

2023-03-17T05:38:50.8366667+00:00

Hi @JerryBE,
Please check if php_oci8.dll is available in C:\php-7.4.33\ext. Also, oci.dll is installed by oracle and php_oci8.dll is a PHP extension. Make sure oci.dll is available in your server's path. If oci.dll is not present on your server, php_oci8.dll will fail to load.
JerryBE 0 Reputation points

2023-03-21T12:21:34.4866667+00:00

Thanks for your answer, yes OCI.DLL in oracle and in php/ext I have the php*oci8_*19.dll are ok

now the error is oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries but I have the ORACLE_HOME=D:\Oracle\ora1970
Yurong Dai-MSFT 2,776 Reputation points Microsoft Vendor

2023-03-23T04:41:05.1433333+00:00
Hi @JerryBE,
You can check that the directory containing the Oracle Instant Client libraries is in your system's PATH environment variable by running the command prompt below. This will show you the list of directories that are currently included in your PATH. Make sure that the directory containing the Oracle Instant Client libraries is listed there. Also note that the version of the Oracle Instant Client library needs to match the version of Oracle you are connecting to.

echo %PATH%
MotoX80 31,566 Reputation points

2023-03-23T13:15:45.1733333+00:00

Or trace the failure with Process Monitor.

https://learn.microsoft.com/en-us/sysinternals/downloads/procmon

Add a filter for "process name is w3wp.exe" and recreate the problem. If IIS can't find a dll you will see an I/O looking for the dll in every folder defined in your PATH.