- 论坛徽章:
- 0
|
安装环境:linux +apache 1.3.x +PHP5+ORACLE 10G
1、安装Apache.1.3.xx,启用lpthread ,正常安装完成之后。
# make clean
# LIBS=-lpthread ./config.status
# make
# make install
通ldd查看是否启用了lpthread ,#ldd /usr/local/apache/bin/httpd
提示: libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00dd4000)
2、安装oracle 的basic 和sdk实例客户端,URL:
http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
#rpm -vih oracle-instantclient-devel-x.x.rpm
#rpm -vih oracle-instantclient-basic-x.x.rpm
3、如果PHP的版本在4.3.9到4.3.10之间,需要给PHP打oracle补丁:
下载:
http://www.oracle.com/technology/pub/files/php_oci8ic_buildpatch.txt
#cd php_4.3.9/ext/oci8
#patch -u config.m4 php_oci8ic_buildpatch
此参数替换自带的编译参数--with-oci8 ,由--with-oci8-instant-client=[DIR]代替
4、配置PHP:
#./configure --prefix=/usr/local/php5 --with-apxs=/usr/local/apache/bin/apxs --with-openssl --with-zlib --with-gd --with-jpeg --with-png --with-freetype --with-gettext --enable-scokets --enable-sysvshm --enable-shmop --enable-sysvmsg --enable-sysvsem --with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib/ --enable-sigchild --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config
其中/usr/lib/oracle/10.2.0.3/client/lib/ 为 oracle-instantclient-basic-x.x.rpm 安装位置。
5、通过phpinfo函数可以看到如下:
OCI8 Support enabled
Revision $Revision: 1.269.2.16 $
Active Persistent Connections 0
Active Connections 0
Oracle Instant Client Version 10.2
Temporary Lob support enabled
Collections support enabled
6、PHP测试程序
$conn = OCILogon("system", "system", 'ns10.test.com');
$query = 'select * from dba_users';
$stid = OCIParse($conn, $query);
OCIExecute($stid, OCI_DEFAULT);
while ($succ = OCIFetchInto($stid, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "
\n";
}
OCILogoff($conn);
?>
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/8988/showart_369762.html |
|