Configure Oracle from PHP on Centos 5

1) install apache, php …

yum install httpd php php-mysql php-pear php-devel zlib zlib-devel
yum groupinstall « Development Tools »

2) Download and install oracle instant client (basic and devel) from there:

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html

rpm -Uvh oracle-instantclient-basic-.i386.rpm
rpm -Uvh oracle-instantclient-devel-.i386.rpm

3) Add the Oracle instant client to dynamic linker

echo /usr/include/oracle//client/lib/ > /etc/ld.so.conf.d/oracle_client.conf
ldconfig -v

4) Untar the PECL package and prepare it for compiling. You may download it from http://pecl.php.net/package/oci8

tar -xzvf oci-.tgz
cd oci-
phpize

5) Configure the PECL package as a shared object using the instant client and specifying where the Oracle client libraries are. Then build and install it.

./configure –with-oci8=shared,instantclient,/usr/lib/oracle//client/lib
make
make install

6) Add the library shared object for PHP

echo extension=oci8.so > /etc/php.d/oci8.ini

7) Start Apache

‘service httpd start’ _or_ ‘/etc/init.d/httpd restart’

Create a PHP info page and checked to see if the Oracle (oci8) driver is listed:

echo > /var/www/html/phpinfo.php

I hope this helps.

PS: These contents are borrows from url http://bigjim-network.be/2009/06/02/oracle-from-php-on-centos-5/