PHP OCI8 and PDO_OCI extensions installation to access Oracle

Preamble

We have recently upgraded our internal DBA web site where we display publicly internal information and where we have few PHP pages connecting to an internal MySQL repository as well as few performance pages where we access Oracle databases. I know with recent web evolution (Vue, React, Node.js, …) it might sound a little bit weird to have PHP pages but to be honest to create what we know call Rest API I have not found anything better than PHP pages. The language is super rich and in any case to access a database backend your script must run on the server side and not on the client. Of course I could have a Node.js running on my web server but again this is so much easier to do this in PHP that I think I will continue to do it for a while…

In the past, to access MySQL, I was using the original MySQL API with procedures like mysql_connect, mysql_select_db and mysql_fetch_array. This extension has been made deprecated as of PHP 5.5.0, and has been removed as of PHP 7.0.0. To prepare it I have asked myself what to use between mysqli or PDO_MySQL. At that time I have decided to use PDO for the common way of working between different flavor of databases (MySQL and Oracle in my case).

When we have setup the new server I expected to configure OCI8 and PDO (PHP Data Objects) by just downloading a package on the official RedHat depot but as usual it did not go as expected and I have spent quite a few hours to sort it out…

Even if I personally like a lot the PDO approach for having a common langage regardless of the backend database Oracle is recommending to use OCI8 instead for its superior feature:

For the moment Oracle still recommends using PHP OCI8 in preference to PDO_OCI because OCI8 has superior features and can also take advantage of various Oracle client library connection and caching functionality.

I tend to say that if your are not chasing performance or top of the edge feature I would recommend PDO, particularly if like me you access multiple database flavors…

My server is a virtual machine running Red Hat Enterprise Linux Server release 7.9 (Maipo) and as the time of writing this blog post using Apache 2.4.37 and PHP Version 7.2.24. As a strong pre-requisite for all extensions (OCI or PDO_OCI) you obviously must have an Oracle client on your web server. This can be the normal, thick, client or the thin instant client. This installation has been done by a teammate and he has chosen the normal client 12.2.0.1.0 (obsolete already but whatever).

OCI8 from pecl

One option to install OCI8 modules is to go with pecl tool. To get pecl do:

[root@server ~]# dnf install php-pear

Download oci8 for PHP 7:

[root@server tmp]# php -v
PHP 7.2.24 (cli) (built: Oct 22 2019 08:28:36) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
[root@server tmp]# wget https://pecl.php.net/get/oci8-2.2.0.tgz
[root@server tmp]# pecl install oci8-2.2.0.tgz
11 source files, building
running: phpize
Can't find PHP headers in /usr/include/php
The php-devel package is required for use of this command.
ERROR: `phpize' failed

Install php-devel:

[root@server tmp]# dnf install php-devel

This time installation went well. Supply your Oracle home at the prompt and specify if you are using an instant client or not (display has been cut for clarity):

[root@server tmp]# pecl install oci8-2.2.0.tgz
11 source files, building
running: phpize
Configuring for:
PHP Api Version:         20170718
Zend Module Api No:      20170718
Zend Extension Api No:   320170718
Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : /oracle/software
building in /var/tmp/pear-build-rootIZwygS/oci8-2.2.0
running: /var/tmp/oci8/configure --with-php-config=/usr/bin/php-config --with-oci8=/oracle/software
checking for grep that handles long lines and -e... /usr/bin/grep
.
.
.
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: executing libtool commands
running: make
.
.
.
----------------------------------------------------------------------
Libraries have been installed in:
   /var/tmp/pear-build-rootIZwygS/oci8-2.2.0/modules
 
If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the '-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the 'LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the 'LD_RUN_PATH' environment variable
     during linking
   - use the '-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to '/etc/ld.so.conf'
 
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
 
Build complete.
Don't forget to run 'make test'.
 
running: make INSTALL_ROOT="/var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0" install
Installing shared extensions:     /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr/lib64/php/modules/
running: find "/var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0" | xargs ls -dils
 104162   0 drwxr-xr-x 3 root root     17 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0
2235876   0 drwxr-xr-x 3 root root     19 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr
3280107   0 drwxr-xr-x 3 root root     17 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr/lib64
 110674   0 drwxr-xr-x 3 root root     21 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr/lib64/php
1144553   0 drwxr-xr-x 2 root root     21 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr/lib64/php/modules
1144554 876 -rwxr-xr-x 1 root root 894144 Aug  4 12:30 /var/tmp/pear-build-rootIZwygS/install-oci8-2.2.0/usr/lib64/php/modules/oci8.so
 
Build process completed successfully
Installing '/usr/lib64/php/modules/oci8.so'
install ok: channel://pecl.php.net/oci8-2.2.0
configuration option "php_ini" is not set to php.ini location
You should add "extension=oci8.so" to php.ini

The oci8.so module is directly in good directory and you just need to change your PHP configuration, by adding a new file in /etc/php.d directory as below, to have it loaded:

[root@server php.d]# ll /usr/lib64/php/modules/oci8.so
-rw-r--r-- 1 root root 894144 Aug  4 12:30 /usr/lib64/php/modules/oci8.so
[root@server php.d]# chmod a+x /usr/lib64/php/modules/oci8.so
[root@server php.d]# cat /etc/php.d/30-oci8.ini
; Enable oci8 extension module
extension=oci8.so
[root@server php.d]# systemctl restart httpd
[root@server php.d]# systemctl restart php-fpm
[root@server php.d]# php -m
[PHP Modules]
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gettext
hash
iconv
json
libxml
mbstring
mysqli
mysqlnd
oci8
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zlib
 
[Zend Modules]
 
[root@server php.d]# php --ri oci8
 
oci8
 
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 2.2.0
Oracle Run-time Client Library Version => 12.2.0.1.0
Oracle Compile-time Version => 12.2
Compile-time ORACLE_HOME => /oracle/software
Libraries Used => -Wl,-rpath,/oracle/software/lib -L/oracle/software/lib  -lclntsh
 
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

I highly recommend to create a phpinfo() file on your web server to be able to quickly see how PHP is configured:

php_oci8
php_oci8

I have taken the example script in PHP official documentation and as it was not working I have tried directly on the server with:

[root@server html]# php oci8.php
PHP Warning:  oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories in /www/html/oci8.php on line 3
PHP Warning:  oci_connect(): Error while trying to retrieve text for error ORA-01804
 in /www/html/oci8.php on line 3
PHP Fatal error:   in /www/html/oci8.php on line 6

This above message is really strange and I solved it with:

[ora12c@server ~]$ cd $ORACLE_HOME
[ora12c@server software]$ find . -name libociicus.so
./instantclient/light/libociicus.so
[ora12c@server software]$ cp ./instantclient/light/libociicus.so lib
[ora12c@server software]$ ll ./lib/libociicus.so
-rw-r----- 1 ora12c dba 6352804 Aug  4 15:06 ./lib/libociicus.so

Then issuing again the script interactively worked but not via Apache with, so, an http request !!

As suggested I have tried to avoid cleaning of environment variables when forking php-fpm processes with (/etc/php-fpm.d/www.conf file):

[root@server php-fpm.d]# vi www.conf
[root@server php-fpm.d]# grep clear www.conf
; by clearing the environment in workers before env vars specified in this
clear_env = no
[root@server php-fpm.d]# systemctl restart php-fpm
[root@server php-fpm.d]# systemctl restart httpd

But it did not solve the problem as explained in few blog posts…. So I have finally changed www.conf again and added:

env[ORACLE_HOME] = /oracle/software
env[LD_LIBRAY_PATH] = /oracle/software/lib

This time all worked well and we now have a running OCI8 module !!

PDO_OCI

When you go to official PDO_OCI page on pecl the warning message is quite clear:

PDO_OCI
This package is not maintained anymore and has been superseded. Package has moved to channel http://www.php.net/pdo_oci package ext/pdo_oci.

So in other words the package is inside the source code of PHP. Okay cool, but then if like me (and most probably 99.9% of people) your PHP is coming from the RPM of the official depot of your Linux distribution ? System admin also do not like you recompile on server as it requires tons of headers that are coming with devel packages. So ideally you should do it on a separate server but as we will see I had nothing more to install so let’s say even your preferred system administrator teammate would be happy !

I have downloaded the PHP source code of the exact same version of my running PHP 7.2.24. It also raise the question when you upgrade PHP, I will continue to try to find a more elegant solution and/or if someone can suggest in comment section I would be happy to know.

Unzip the source code and go in ext/pdo_oci directory, export the ORACLE_HOME environment variable and use phpize (https://www.php.net/manual/en/install.pecl.phpize.php). I have cut the display as it would be too long.

Run phpize and ./configure command:

[root@server php-7.2.24]# cd ext/pdo_oci/
[root@server pdo_oci]# export ORACLE_HOME=/oracle/software
[root@server pdo_oci]# ll
total 88
-rwxrwxr-x 1 root root  7649 Oct 22  2019 config.m4
-rwxrwxr-x 1 root root  1494 Oct 22  2019 config.w32
-rwxrwxr-x 1 root root    40 Oct 22  2019 CREDITS
-rw-rw-r-- 1 root root 21968 Oct 22  2019 oci_driver.c
-rw-rw-r-- 1 root root 22353 Oct 22  2019 oci_statement.c
-rw-rw-r-- 1 root root  2326 Oct 22  2019 package2.xml
-rw-rw-r-- 1 root root  4172 Oct 22  2019 pdo_oci.c
-rw-rw-r-- 1 root root  1708 Oct 22  2019 php_pdo_oci.h
-rw-rw-r-- 1 root root  3135 Oct 22  2019 php_pdo_oci_int.h
drwxrwxr-x 2 root root  4096 Oct 22  2019 tests
[root@server pdo_oci]# phpize
Configuring for:
PHP Api Version:         20170718
Zend Module Api No:      20170718
Zend Extension Api No:   320170718
[root@server pdo_oci]# ll
total 1540
-rw-r--r-- 1 root root  86562 Aug  4 16:10 acinclude.m4
-rw-r--r-- 1 root root 418161 Aug  4 16:10 aclocal.m4
drwxr-xr-x 2 root root     54 Aug  4 16:10 autom4te.cache
drwxr-xr-x 2 root root    115 Aug  4 16:10 build
-rwxr-xr-x 1 root root  42938 Aug  4 16:10 config.guess
-rw-r--r-- 1 root root   1988 Aug  4 16:10 config.h.in
-rwxrwxr-x 1 root root   7649 Oct 22  2019 config.m4
-rwxr-xr-x 1 root root  35967 Aug  4 16:10 config.sub
-rwxr-xr-x 1 root root 455182 Aug  4 16:10 configure
-rw-r--r-- 1 root root   4684 Aug  4 16:10 configure.ac
-rwxrwxr-x 1 root root   1494 Oct 22  2019 config.w32
-rwxrwxr-x 1 root root     40 Oct 22  2019 CREDITS
-rw-r--r-- 1 root root      0 Aug  4 16:10 install-sh
-rw-r--r-- 1 root root 324152 Aug  4 16:10 ltmain.sh
-rw-r--r-- 1 root root   7156 Aug  4 16:10 Makefile.global
-rw-r--r-- 1 root root      0 Aug  4 16:10 missing
-rw-r--r-- 1 root root      0 Aug  4 16:10 mkinstalldirs
-rw-rw-r-- 1 root root  21968 Oct 22  2019 oci_driver.c
-rw-rw-r-- 1 root root  22353 Oct 22  2019 oci_statement.c
-rw-rw-r-- 1 root root   2326 Oct 22  2019 package2.xml
-rw-rw-r-- 1 root root   4172 Oct 22  2019 pdo_oci.c
-rw-rw-r-- 1 root root   1708 Oct 22  2019 php_pdo_oci.h
-rw-rw-r-- 1 root root   3135 Oct 22  2019 php_pdo_oci_int.h
-rw-r--r-- 1 root root  85864 Aug  4 16:10 run-tests.php
drwxrwxr-x 2 root root   4096 Oct 22  2019 tests
[root@server pdo_oci]# ./configure
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for a sed that does not truncate output... /usr/bin/sed
checking for cc... cc
checking whether the C compiler works... yes
.
.
.
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: executing libtool commands

Finally issue make and make test commands:

[root@server pdo_oci]# make
.
.
.
Libraries have been installed in:
   /tmp/php-7.2.24/ext/pdo_oci/modules
 
If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the '-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the 'LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the 'LD_RUN_PATH' environment variable
     during linking
   - use the '-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to '/etc/ld.so.conf'
 
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
 
Build complete.
Don't forget to run 'make test'.
 
[root@server pdo_oci]# make test
.
.
.
Number of tests :   33                 0
Tests skipped   :   33 (100.0%) --------
Tests warned    :    0 (  0.0%) (  0.0%)
Tests failed    :    0 (  0.0%) (  0.0%)
Expected fail   :    0 (  0.0%) (  0.0%)
Tests passed    :    0 (  0.0%) (  0.0%)
---------------------------------------------------------------------
Time taken      :    2 seconds
=====================================================================
 
This report can be automatically sent to the PHP QA team at
http://qa.php.net/reports and http://news.php.net/php.qa.reports
This gives us a better understanding of PHP's behavior.
If you don't want to send the report immediately you can choose
option "s" to save it.  You can then email it to qa-reports@lists.php.net later.
Do you want to send this report now? [Yns]: n

Then the compiled module is in modules directory. Copy it to target directory (/usr/lib64/php/modules/) and configure php-fpm to use it:

[root@server pdo_oci]# ll modules
total 204
-rw-r--r-- 1 root root    951 Aug  4 16:11 pdo_oci.la
-rwxr-xr-x 1 root root 202832 Aug  4 16:11 pdo_oci.so
[root@server pdo_oci]# cp modules/pdo_oci.so /usr/lib64/php/modules/
[root@server pdo_oci]# cat /etc/php.d/30-pdo_oci.ini
; Enable pdo_oci extension module
extension=pdo_oci
[root@server pdo_oci]# systemctl restart php-fpm
[root@server pdo_oci]# php --ri pdo
 
PDO
 
PDO support => enabled
PDO drivers => mysql, oci, sqlite

This can also be seen in phpinfo():

php_pdo_oci
php_pdo_oci

OCI8 from PHP source

When installing PDO_OCI I have realized that the extension directory also contains an oci8 directory that we could also install with the same strategy and not go through pecl. What is the difference with the version in the source code versus the one on pecl repository ? I feel like the one in PHP source is closer to what’s really running on your server and the one on pecl might have some bug correction…

Let’s see if we can compile and use it. We export ORACLE_HOME, run phpize and issue ./configure command:

[root@server php-7.2.24]# cd ext/oci8
[root@server oci8]# export ORACLE_HOME=/oracle/software
[root@server oci8]# ll
total 444
-rw-rw-r-- 1 root root  16048 Oct 22  2019 config.m4
-rw-rw-r-- 1 root root   3845 Oct 22  2019 config.w32
-rw-rw-r-- 1 root root    173 Oct 22  2019 CREDITS
-rw-rw-r-- 1 root root   3204 Oct 22  2019 LICENSE
-rw-rw-r-- 1 root root 119803 Oct 22  2019 oci8.c
-rw-rw-r-- 1 root root  24183 Oct 22  2019 oci8_collection.c
-rw-rw-r-- 1 root root   2334 Oct 22  2019 oci8_dtrace.d
-rw-rw-r-- 1 root root   5199 Oct 22  2019 oci8_failover.c
-rw-rw-r-- 1 root root  70256 Oct 22  2019 oci8_interface.c
-rw-rw-r-- 1 root root  27847 Oct 22  2019 oci8_lob.c
-rw-rw-r-- 1 root root  60056 Oct 22  2019 oci8_statement.c
-rw-rw-r-- 1 root root  48000 Oct 22  2019 package.xml
-rw-rw-r-- 1 root root   2703 Oct 22  2019 php_oci8.h
-rw-rw-r-- 1 root root  25333 Oct 22  2019 php_oci8_int.h
-rw-rw-r-- 1 root root    976 Oct 22  2019 README
drwxrwxr-x 2 root root  12288 Oct 22  2019 tests
[root@server oci8]# phpize
Configuring for:
PHP Api Version:         20170718
Zend Module Api No:      20170718
Zend Extension Api No:   320170718
[root@server oci8]# ll
total 1892
-rw-r--r-- 1 root root  86562 Aug  4 16:33 acinclude.m4
-rw-r--r-- 1 root root 418161 Aug  4 16:33 aclocal.m4
drwxr-xr-x 2 root root     54 Aug  4 16:33 autom4te.cache
drwxr-xr-x 2 root root    115 Aug  4 16:33 build
-rwxr-xr-x 1 root root  42938 Aug  4 16:33 config.guess
-rw-r--r-- 1 root root   2244 Aug  4 16:33 config.h.in
-rw-rw-r-- 1 root root  16048 Oct 22  2019 config.m4
-rwxr-xr-x 1 root root  35967 Aug  4 16:33 config.sub
-rwxr-xr-x 1 root root 454262 Aug  4 16:33 configure
-rw-r--r-- 1 root root   4684 Aug  4 16:33 configure.ac
-rw-rw-r-- 1 root root   3845 Oct 22  2019 config.w32
-rw-rw-r-- 1 root root    173 Oct 22  2019 CREDITS
-rw-r--r-- 1 root root      0 Aug  4 16:33 install-sh
-rw-rw-r-- 1 root root   3204 Oct 22  2019 LICENSE
-rw-r--r-- 1 root root 324152 Aug  4 16:33 ltmain.sh
-rw-r--r-- 1 root root   7156 Aug  4 16:33 Makefile.global
-rw-r--r-- 1 root root      0 Aug  4 16:33 missing
-rw-r--r-- 1 root root      0 Aug  4 16:33 mkinstalldirs
-rw-rw-r-- 1 root root 119803 Oct 22  2019 oci8.c
-rw-rw-r-- 1 root root  24183 Oct 22  2019 oci8_collection.c
-rw-rw-r-- 1 root root   2334 Oct 22  2019 oci8_dtrace.d
-rw-rw-r-- 1 root root   5199 Oct 22  2019 oci8_failover.c
-rw-rw-r-- 1 root root  70256 Oct 22  2019 oci8_interface.c
-rw-rw-r-- 1 root root  27847 Oct 22  2019 oci8_lob.c
-rw-rw-r-- 1 root root  60056 Oct 22  2019 oci8_statement.c
-rw-rw-r-- 1 root root  48000 Oct 22  2019 package.xml
-rw-rw-r-- 1 root root   2703 Oct 22  2019 php_oci8.h
-rw-rw-r-- 1 root root  25333 Oct 22  2019 php_oci8_int.h
-rw-rw-r-- 1 root root    976 Oct 22  2019 README
-rw-r--r-- 1 root root  85864 Aug  4 16:33 run-tests.php
drwxrwxr-x 2 root root  12288 Oct 22  2019 tests
[root@server oci8]# ./configure
checking for grep that handles long lines and -e... /usr/bin/grep
.
.
.
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: executing libtool commands

We run make and make test commands. My make test command is full of error but at the end I have been able to use the module:

[root@server oci8]# make
.
.
.
----------------------------------------------------------------------
Libraries have been installed in:
   /tmp/php-7.2.24/ext/oci8/modules
 
If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the '-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the 'LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the 'LD_RUN_PATH' environment variable
     during linking
   - use the '-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to '/etc/ld.so.conf'
 
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
 
Build complete.
Don't forget to run 'make test'.
 
[root@server oci8]# make test
 
Build complete.
Don't forget to run 'make test'.
 
 
=====================================================================
PHP         : /usr/bin/php
PHP_SAPI    : cli
PHP_VERSION : 7.2.24
ZEND_VERSION: 3.2.0
PHP_OS      : Linux - Linux server 4.18.0-305.3.1.el8_4.x86_64 #1 SMP Mon May 17 10:08:25 EDT 2021 x86_64
INI actual  : /tmp/php-7.2.24/ext/oci8/tmp-php.ini
More .INIs  :
CWD         : /tmp/php-7.2.24/ext/oci8
Extra dirs  :
VALGRIND    : Not used
=====================================================================
TIME START 2021-08-04 14:34:19
=====================================================================
FAIL oci_bind_array_by_name() and invalid values 1 [tests/array_bind_001.phpt]
FAIL oci_bind_array_by_name() and invalid values 2 [tests/array_bind_002.phpt]
FAIL oci_bind_array_by_name() and invalid values 3 [tests/array_bind_003.phpt]
FAIL oci_bind_array_by_name() and invalid values 4 [tests/array_bind_004.phpt]
FAIL oci_bind_array_by_name() and invalid values 5 [tests/array_bind_005.phpt]
FAIL oci_bind_array_by_name(), SQLT_CHR and default max_length [tests/array_bind_006.phpt]
FAIL oci_bind_array_by_name() and invalid values 7 [tests/array_bind_007.phpt]
.
.
.
---------------------------------------------------------------------
 
Number of tests :  363               358
Tests skipped   :    5 (  1.4%) --------
Tests warned    :    0 (  0.0%) (  0.0%)
Tests failed    :  346 ( 95.3%) ( 96.6%)
Expected fail   :    0 (  0.0%) (  0.0%)
Tests passed    :   12 (  3.3%) (  3.4%)
---------------------------------------------------------------------
Time taken      :   55 seconds
=====================================================================
 
=====================================================================
FAILED TEST SUMMARY
---------------------------------------------------------------------
oci_bind_array_by_name() and invalid values 1 [tests/array_bind_001.phpt]
oci_bind_array_by_name() and invalid values 2 [tests/array_bind_002.phpt]
oci_bind_array_by_name() and invalid values 3 [tests/array_bind_003.phpt]
.
.
.
Basic XMLType test #2 [tests/xmltype_02.phpt]
=====================================================================
 
You may have found a problem in PHP.
This report can be automatically sent to the PHP QA team at
http://qa.php.net/reports and http://news.php.net/php.qa.reports
This gives us a better understanding of PHP's behavior.
If you don't want to send the report immediately you can choose
option "s" to save it.  You can then email it to qa-reports@lists.php.net later.
Do you want to send this report now? [Yns]: n
make: *** [Makefile:136: test] Error 1

Same as for PDO_OCI the compiled module is in modules directory:

[root@server oci8]# ll modules
total 880
-rw-r--r-- 1 root root    930 Aug  4 16:34 oci8.la
-rwxr-xr-x 1 root root 894256 Aug  4 16:34 oci8.so
[root@server oci8]# ll /usr/lib64/php/modules/oci8.so
-rwxr-xr-x 1 root root 894144 Aug  4 12:30 /usr/lib64/php/modules/oci8.so

I have installed it in /usr/lib64/php/modules and it also works well. As said you are sure it is the same version as your running PHP version, 7.2.24 in my case.

References

Yannick Jaquier on LinkedinYannick Jaquier on RssYannick Jaquier on Twitter
Yannick Jaquier
Find more about me on social media.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>