PHP 連接 Oracle - OCI8

for PHP 5.3

預設的 PHP RPM 安裝並不支援 oci8 及 pdo_oci extension，所以必須重編 PHP，然後再重裝一次。

// 從網路或 CD 找出現有 PHP 版本的 SRPM，並安裝它。

rpm -ivh php53-5.3.5-1.el5.src.rpm

// 修改 php53.spec
/usr/src/redhat/SPECS/php53.spec，找到這幾行

# Build /usr/bin/php-cgi with the CGI SAPI, and all the shared extensions
pushd build-cgi
build --enable-pcntl \
      --with-imap=shared --with-imap-ssl \
      --enable-mbstring=shared \
      --enable-mbregex \
      --with-gd=shared \
      --enable-bcmath=shared \
      --enable-dba=shared --with-db4=%{_prefix} \
      --with-xmlrpc=shared \
      --with-ldap=shared --with-ldap-sasl \
      --with-mysql=shared,%{_prefix} \
      --with-mysqli=shared,%{_bindir}/mysql_config \
      --enable-dom=shared \
      --with-pgsql=shared \
      --with-snmp=shared,%{_prefix} \
      --enable-soap=shared \
      --with-xsl=shared,%{_prefix} \
      --enable-xmlreader=shared --enable-xmlwriter=shared \
      --enable-pdo=shared \
      --with-pdo-odbc=shared,unixODBC,%{_prefix} \
      --with-pdo-mysql=shared,%{_prefix} \
      --with-pdo-pgsql=shared,%{_prefix} \
      --with-pdo-sqlite=shared,%{_prefix}

// 在下方加上一行參數

--with-pdo-sqlite=shared,%{_prefix} \
--with-oci8=instantclient,/usr/lib/oracle/11.2/client/lib

// 重新編譯

cd /usr/src/redhat/SPECS/
rpmbuild -bb php53.spec

for PHP 5.1.6(built-in)

下載 SRPM

cd /usr/src/redhat/SRPMS
wget http://ftp.isu.edu.tw/pub/Linux/CentOS/5.5/os/SRPMS/php-5.1.6-27.el5.src.rpm 
rpm -ivh php-5.1.6-27.el5.src.rpm
vi ../SPECS/php.spec

php.spec: 找到這幾行

# Build /usr/bin/php-cgi with the CGI SAPI, and all the shared extensions
pushd build-cgi
build --enable-force-cgi-redirect \
      --enable-pcntl \
      --with-imap=shared --with-imap-ssl \
      --enable-mbstring=shared --enable-mbstr-enc-trans \
      --enable-mbregex \
      --with-ncurses=shared \
      --with-gd=shared \
      --enable-bcmath=shared \
      --enable-dba=shared --with-db4=%{_prefix} \
      --with-xmlrpc=shared \
      --with-ldap=shared --with-ldap-sasl \
      --with-mysql=shared,%{_prefix} \
      --with-mysqli=shared,%{_libdir}/mysql/mysql_config \
      --enable-dom=shared \
      --with-dom-xslt=%{_prefix} --with-dom-exslt=%{_prefix} \
      --with-pgsql=shared \
      --with-snmp=shared,%{_prefix} \
      --enable-soap=shared \
      --with-xsl=shared,%{_prefix} \
      --enable-xmlreader=shared --enable-xmlwriter=shared \
      --enable-fastcgi \
      --enable-pdo=shared \
      --with-pdo-odbc=shared,unixODBC,%{_prefix} \
      --with-pdo-mysql=shared,%{_libdir}/mysql/mysql_config \
      --with-pdo-pgsql=shared,%{_prefix} \
      --with-pdo-sqlite=shared,%{_prefix} \
      --enable-dbase=shared

加上一行

--with-oci8=instantclient,/usr/lib/oracle/10.2.0.4/client/lib \
--enable-dbase=shared

開始編譯

rpmbuild -bb ../SPECS/php.spec

安裝 oci8.so

cd ../BUILD/php-5.1.6/ext/oci8/
phpize
./configure --with-oci8=shared,instantclient,/usr/lib/oracle/10.2.0.4/client/lib
make
make install
vi /etc/php.d/oci8.ini

oci8.ini:

; Enable oci8 extension module
extension=oci8.so

// 重啟 Apache

service httpd restart

檢查 phpinfo