Hi. I try to use persistent connection to database with tls protocol. Also i use nginx and php-fpm.
First 6 connections to db are established. Next connection is broken. This means that i have php warning: oci_parse(): supplied resource is not a valid oci8 connection resource.
For tests I use simple code:
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
function errorsHandler($errno , $errstr) {
echo "Errno: " . $errno . "\n";
echo "Errstr: " . $errstr . "\n";
die();
}
set_error_handler('errorsHandler');
$conn = oci_pconnect('/', '', 'SECUREDCONNECTION','AL32UTF8',OCI_CRED_EXT);
if (!$conn) {
die("Connection problems: " . oci_error());
}
$stid = oci_parse($conn, 'select * from p2p_accounts where account_number = :account_number');
$value = '4080************2622';
oci_bind_by_name($stid, ':account_number', $value, -1, SQLT_CHR);
oci_execute($stid);
echo "<table border='1'>\n";
while ($row = oci_fetch_assoc($stid)) {
echo "<tr>\n";
foreach ($row as $k => $v) {
echo " <td>" . $k . ' = ' . $v . "</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n";
oci_free_statement($stid);
Also if I use oci_connect() function, all works fine. Also if I use oci_pconnect() function without tls protocol all works fine.
I confused where I wrong?
PHP version: 7.0.15
Oracle Run-time Client Library Version 12.2.0.1.0
Oracle Compile-time Instant Client Version 12.2
Env variables are:
env[LD_LIBRARY_PATH] = /usr/lib/oracle/12.2/client64/lib
env[ORACLE_HOME] = /usr/lib/oracle/12.2/client64/