ORACLE安装教程
最近的项目需要用php访问oracle数据库,不得不在linux下给php安装oci8扩展。php也可以使用pdo访问oracle数据库,但还是需要安装客户端。
首先到oracle官网的这个页面下载相关的文件,注意要连数据库服务器的版本,一定要对应,否则安装成功也会连不上,同时也要区分32位、64位服务器,比如我要连的数据库服务器是oracle10.2.0.4,64位主机,那么我要下载下面三个文件:
<br />oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm<br />oracle-instantclient-devel-10.2.0.4-1.x86_64.rpm<br />oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm<br />
1.用以下命令安装
<br /># 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<br />
2.安装OCI8 PHP扩展
<br /># yum install libaio<br /># cd ~<br /># wget http://pecl.php.net/get/oci8-1.3.5.tgz<br />
3.然后执行命令
<br /># tar zxvf oci8-1.3.5.tgz<br /># cd oci8-1.3.5/<br /># /usr/local/php5/bin/phpize CFLAGS=/usr/lib/oracle/11.2/client64/ CXXFLAGS=/usr/lib/oracle/11.2/client64/<br /># ./configure --with-php-config=/usr/local/php5/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2/client64/lib/<br /># make<br /># make install(这里多运行几次,直到出现如下提示)<br /> <br />[root@webserver02 oci8-1.3.5]# make install<br />/bin/sh /root/oci8-1.3.5/libtool --mode=install cp ./oci8.la /root/oci8-1.3.5/modules<br />cp ./.libs/oci8.so /root/oci8-1.3.5/modules/oci8.so<br />cp ./.libs/oci8.lai /root/oci8-1.3.5/modules/oci8.la<br />PATH="$PATH:/sbin" ldconfig -n /root/oci8-1.3.5/modules<br />----------------------------------------------------------------------<br />Libraries have been installed in:<br /> /root/oci8-1.3.5/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.
———————————————————————-
Installing shared extensions: /usr/local/php5/lib/php/extensions/no-debug-zts-20090626/
# cd /usr/local/php5/lib
4.创建ext目录
<br /># mkdir ext/<br />
把oci8.so文件拷贝到php.ini 的ext目录里面
# cp /root/oci8-1.3.5/modules/oci8.so /usr/lo<em>8本文来源gao.dai.ma.com搞@代*码(网$</em><pre>搞代gaodaima码
cal/php5/lib/ext/
5.在php.ini里面加上extension=oci8.so
如下:
<br />extension_dir = "/usr/local/php5/lib/ext"<br />extension = "oci8.so"<br />session.save_path = "/tmp/php"<br />oci8.privileged_connect = on
重启apache服务:
<br />/usr/local/apache2/bin/apachectl stop<br />/usr/local/apache2/bin/apachectl start<br />
刷新测试页面。发现oci8出现了,则大功告成.