I have tried to make PHP and Oracle work together, but no success so far. It seems like there is a problem loading php_oci8.dll that may be due to Oracle configuration...

Good suggestions appreciated...
regards, Even Husby

some facts:

I have
- Oracle 9.2
- php5.0.1 available in c:\php5
- IUSER_... has read/execute rights to c:\php5
- php.ini is stored in c:\windows
- extensions enabled for php_oci8.dll
- phpinfo() verifies the existence of some extensions, but gives an error message for php_oci8.dll.
- The error is "PHP Startup: Unable to load dynamic library c:\php5\ext\php_oci8.dll - Access is denied."
- The keys under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE include

Name: inst_loc
Data: C:\Program Files\Oracle\Inventory

Name: ORACLE_HOME
Data: C:\oracle\ora92

Name: ORACLE_HOME_NAME
Data: OraHome92

Name: API
Data: C:\oracle\ora92\dbs

Name: ORACLE_GROUP_NAME
Data: Oracle - OraHome92

Name: NLS_LANG
Data: NA

Name: OLEDB
Data: C:\oracle\ora92\oledb\mesg

Name: VOBHOME2.0
Data: C:\oracle\ora92

Name: OO4O
Data: C:\oracle\ora92\oo4o\mesg

Name: TNS_ADMIN
Data: C:\oracle\ora92\network\admin\tnsnames.ora

Name: LD_LIBRARY_PATH
Data: c:\oracle\ora92\lib

Name: TWO_TASK
Data: c:\oracle\ora92\network\admin\tnsnames.ora

Name: ORACLE_SID
Data: even

    Hi,

    does IUSER_... have read/execute rights on the oracle directory ? This might be neccessary since PHP needs to access the client oracle client libraries. Additionally/alternatively, you need to make sure that ORACLE_HOME is part of the PATH environment variable.

    Also check if IUSER_.... has read/execute rights on the complete php5 directory (including subdirectories). I guess, this is the case since you would get error message for other PHP modules, too, if that wasn't the case.

    Thomas

      Thanks for your input Thomas,

      IUSR_... has access to both c:\php5 and c:\Oracle + sub-directories, and PATH includes c:\oracle\ora92 and c:\oracle\ora92\bin, and I'm still stuck 😉.

      I'm moving ahead with reinstallation of the Oracle client to see if that may change things.

        Write a Reply...