1. 云栖社区>
  2. PHP教程>
  3. 正文

PHP下的Oracle客户端扩展(OCI8)安装教程

作者:用户 来源:互联网 时间:2017-12-01 20:55:50

oracle客户端

PHP下的Oracle客户端扩展(OCI8)安装教程 - 摘要: 本文讲的是PHP下的Oracle客户端扩展(OCI8)安装教程,最近的项目需要用php访问oracle数据库,不得不在linux下给php安装oci8扩展。php也可以使用pdo访问oracle数据库,但还是需要安装客户端。首先到oracle官网的这个页面下载相关的文件,注意要连数据库服务器的版本,一定

最近的项目需要用php访问oracle数据库,不得不在linux下给php安装oci8扩展。php也可以使用pdo访问oracle数据库,但还是需要安装客户端。

首先到oracle官网的这个页面下载相关的文件,注意要连数据库服务器的版本,一定要对应,否则安装成功也会连不上,同时也要区分32位、64位服务器,比如我要连的数据库服务器是oracle10.2.0.4,64位主机,那么我要下载下面三个文件:

oracle-instantclient-basic-10.2.0.4-1.x86_64.rpmoracle-instantclient-devel-10.2.0.4-1.x86_64.rpmoracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm

1.用以下命令安装

# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm oracle-instantclient-devel-10.2.0.4-1.x86_64.rpm    oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm

2.安装OCI8 PHP扩展

# yum install libaio# cd ~# wget http://pecl.php.net/get/oci8-1.3.5.tgz

3.然后执行命令

# tar zxvf oci8-1.3.5.tgz# cd oci8-1.3.5/# /usr/local/php5/bin/phpize  CFLAGS=/usr/lib/oracle/11.2/client64/ CXXFLAGS=/usr/lib/oracle/11.2/client64/# ./configure --with-php-config=/usr/local/php5/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2/client64/lib/# make# make install(这里多运行几次,直到出现如下提示) [[email protected] oci8-1.3.5]# make install/bin/sh /root/oci8-1.3.5/libtool --mode=install cp ./oci8.la /root/oci8-1.3.5/modulescp ./.libs/oci8.so /root/oci8-1.3.5/modules/oci8.socp ./.libs/oci8.lai /root/oci8-1.3.5/modules/oci8.laPATH="$PATH:/sbin" ldconfig -n /root/oci8-1.3.5/modules----------------------------------------------------------------------Libraries have been installed in:   /root/oci8-1.3.5/modulesIf you ever happen to want to link against installed librariesin a given directory, LIBDIR, you must either use libtool, andspecify 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 formore information, such as the ld(1) and ld.so(8) manual pages.----------------------------------------------------------------------Installing shared extensions:     /usr/local/php5/lib/php/extensions/no-debug-zts-20090626/# cd /usr/local/php5/lib

4.创建ext目录

# mkdir ext/


把oci8.so文件拷贝到php.ini 的ext目录里面

# cp /root/oci8-1.3.5/modules/oci8.so /usr/local/php5/lib/ext/

5.在php.ini里面加上extension=oci8.so

如下:

extension_dir = "/usr/local/php5/lib/ext"extension = "oci8.so"session.save_path = "/tmp/php"oci8.privileged_connect = on

重启apache服务:

/usr/local/apache2/bin/apachectl stop/usr/local/apache2/bin/apachectl start

刷新测试页面。发现oci8出现了,则大功告成.

以上是云栖社区小编为您精心准备的的内容,在云栖社区的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索oracle 客户端 ,以便于您获取更多的相关知识。