CentOS 7 安装php的oracel扩展

先需要安装 instantclient（连接 Oracle 数据库的简单客户端），然后编译安装 php-oci8 扩展。

安装 Oracle Instance Client

查询系统是否已经安装 instanceclient：

sudo yum list installed | grep instantclient

下载相应版本的 instanceclient rpm 包文件。使用 yum install 命令安装：

注意：需要下载sdk，否则编译时会出异常，找不到oci.h

$ yum install oracle-instantclient-basic-21.12.0.0.0-1.el9.x86_64.rpm
$ yum install oracle-instantclient-devel-21.12.0.0.0-1.el9.x86_64.rpm

如果是debian系统，不能直接安装rpm包，需要使用alien，先运行 apt-get install alien安装好alien，然后执行`alien -i xx.rpm；

增加 PATH 环境变量：

export PATH=/usr/lib/oracle/21/client64/bin:$PATH

编译安装 oci8

官网下载 oci8 源码包，并进行编译安装：

wget https://pecl.php.net/get/oci8-3.0.0.tgz
tar xvf oci8-3.0.0.tgz
cd oci8-3.0.0
/usr/local/php/bin/phpize ./configure --with-oci8=shared,instantclient,/usr/lib/oracle/21/client64/lib --with-php-config=/usr/local/php/bin/php-config
make
make install

上面的 /usr/lib/oracle/21/client64/lib、/usr/local/php/bin/php-config 的路径不能错。

php.ini 增加启用 oci8 扩展，

vi /usr/local/php/etc/php.ini

[oci8]
extension = oci8.so

检查是否安装成功：

[root@localhost oci8-3.0.1]# php --ri oci8

oci8

OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 3.0.0
Oracle Run-time Client Library Version => 21.12.0.0.0
Oracle Compile-time Instant Client Version => 21.12

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

或者

[root@localhost oci8-3.0.1]# php -m |grep oci8
oci8

编译安装 pdo_oci

pdo_oci 扩展在 php 源码包里。因此在 https://www.php.net/releases/ 里找到已经安装好的 php 版本，并下载源码包，进行编译安装：

wget https://www.php.net/distributions/php-8.0.10.tar.xz
tar xvf php-8.0.10.tar.xz 
cd php-8.0.10
cd ext/pdo_oci
/usr/local/php/bin/phpize 
./configure --with-pdo-oci=instantclient,/usr/lib/oracle/21/client64/lib --with-php-config=/usr/local/php/bin/php-config
make & make install

再在 php.ini 文件里添加并启用 pdo_oci.so 扩展。

[root@localhost pdo_sqlsrv-5.9.0]# php --ri pdo_oci

PDO_OCI

PDO Driver for OCI 8 and later => enabled