I have a Linux redhat6 server, with apache+nginx servers. To get the data from remote Oracle db I compiled pdo_oci.so for my php 5.3 and it was working perfectly. There were a lot of troubles with configuring TCPS connection with wallet, but they were solved and were working.
But our server machine was rebooted from snapshot, which was made an hour earlier, and this connections fall down. I have checked sqlplus connections, to find out where is the main trouble, and it was not working either. I set up environment variables $ORACLE_HOME
, $TNS_ADMIN
and $LD_LIBRARY_PATH
again, and sqlplus connection was restored. BUT not the pdo_oci connection. I am searching google for any info, but cannot remember the solution.
The error that I'm getting looks like this:
Failed to execute your db connection: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-28759: failure to open file (/usr/local/src/php-5.3.3/ext/pdo_oci/oci_driver.c:579)
Any help and variants are highly appreciated!