Linux php-oracle扩展安装
1.下载所需文件:
# wget http://download.csdn.net/detail/u010211892/9010157
# wget http://download.csdn.net/detail/happy_gao/8247809
# wget http://pecl.php.net/get/oci8-2.0.6.tgz
2.具体安装:
①基础客户端安装
# rpm -ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm
# rpm -ivh oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm
# echo '/usr/lib/oracle/11.2/client64/lib/' > /etc/ld.so.conf.d/oracle-x86_64.conf
②添加环境变量
# vim etc/profile
行尾加入以下几行
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64:$LD_LIBRARY_PATH
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
然后用以下语句使其立即生效
# source /etc/profile
③64位系统需要创建32位的软链接
# ln -s /usr/lib/oracle/11.2/client64 /usr/lib/oracle/11.2/client
# ln -s /usr/include/oracle/11.2/client64 /usr/include/oracle/11.2/client
④oracle扩展安装
# tar -zxvf oci8-2.0.6.tgz
# cd oci8-2.0.6
# /usr/local/php/bin/phpize
# ./configure --with-php-config=/usr/local/php/bin/php-config --with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client/lib
# make
# make install
成功安装后的扩展目录
/usr/local/php/lib/php/extensions/no-debug-non-zts-20121212/
⑤修改php.ini
# vim /usr/local/php/etc/php.ini 视具体PHP安装位置
打开ext扩展目录(去掉; 打开扩展)
extension_dir = "/usr/local/php/lib/php/extensions/no-debug-non-zts-20121212/"
extension=oci8.so
保存wq
⑥重启php-fpm
# /usr/local/php/init.d/php-fpm54 reload
或
# service php-fpm reload
⑦测试oci能连接否
# php -r '$con = oci_connect("user","pwd","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.254.11.1)(PORT=1521))(CONNECT_DATA=(SID=scprd)))","utf8");var_dump($con);'
成功结果:resource(5) of type (oci8 connection)