Case Description:
We would require to access (fetch and push) data from a local software (developed in asp.net with Oracle DB) into a PHP 8 based web application. One is offline, software kind- resides on the clients local machine and another one is pure web application hosted on a VPS server (Linux).
We installed OCI8 extension on the VPS server, but we cannot either connect to the Oracle Database (not connect) or the oci8 module related informations, not being shown in phpinfo file (phpinfo() output file),
https://www.bizboxdigital.in/phpinfo.php
https://www.bizboxdigital.in/projects/dna/test.php
https://www.bizboxdigital.in/testoci8.php
https://docs.oracle.com/database/121/TDPPH/img/chap2_php_config_oci8.png
https://www.bizboxdigital.in/php-bit-version.php
We feel that the "OCI8 extension" installation is perfect but some mapping with PHP8 is behaving differently. Please help us...
--------------
Our server Configuration are
OS: CentOS Linux 8.3.2011
PHP-FPM 8.0.7
64-bit version of PHP
---------------------------
OCI8 Support => enabled
OCI8 DTrace Support => enabled
OCI8 Version => 3.0.1
Oracle Run-time Client Library Version => 21.1.0.0.0
Oracle Compile-time Instant Client Version => 21.1
Directive => Local Value => Master Value
oci8.max_persistent => -1 => -1
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
oci8.default_prefetch => 100 => 100
oci8.old_oci_close_semantics => Off => Off
oci8.connection_class => no value => no value
oci8.events => Off => Off
Statistics =>
Active Persistent Connections => 0
Active Connections => 0
---------------------------