标签归档:oracle

CentOS PHP 5.2.x 链接Oracle数据库

1、下载Oracle即时客户端程序包 — Basic: 运行 OCI、OCCI 和 JDBC-OCI 应用程序所需的所有文件

①、打开以下网址(本文以32位版为例):
http://www.oracle.com/technetwork/topics/linuxsoft-082809.html

②、下载以下几个文件:
oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm
oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm
oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm

2、安装Oracle即时客户端程序包

rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm
echo "/usr/lib/oracle/11.1/client/lib/" > /etc/ld.so.conf.d/oracle_client.conf
/sbin/ldconfig

3、安装OCI8 PHP扩展(使用PHP自带的OCI8,假设PHP程序安装在/usr/local/webserver/php/)

yum install libaio
wget http://pecl.php.net/get/oci8-1.4.4.tgz
cd oci8-1.4.4/
/usr/local/webserver/php/bin/phpize CFLAGS="-I/usr/include/oracle/11.2/client/" CXXFLAGS="-I/usr/include/oracle/11.2/client/"
./configure --with-php-config=/usr/local/webserver/php/bin/php-config --with-oci8=/usr/lib/oracle/11.2/client/
make
make install

make oci8出错的话,用这个编译试试

./configure --with-php-config=/usr/local/webserver/php/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2/client/lib/

4、修改PHP配置文件(/usr/local/webserver/php/etc/php.ini)
在extension_dir = “/usr/local/webserver/php/lib/php/extensions/no-debug-non-zts-20060613/”后增加一行:

extension = "oci8.so"

5、重启PHP

6、创建一个phpinfo.php文件(内容如下)并通过Web访问,如果有“oci8”这一项,则表明安装成功。

<?php
phpinfo();
?>