Forum Stats

  • 3,816,609 Users
  • 2,259,213 Discussions
  • 7,893,518 Comments

Discussions

OCI8 Extension Installation/Connection failure (PHP 8)

User_ZRL66
User_ZRL66 Member Posts: 1 Green Ribbon

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

---------------------------