Installing php-oci8 with Oracle-XE in Ubuntu 10.04 x86-64

If you are using Oracle-XE for database with Apache and PHP you need to install php-oci8 module. It is difficult to find any .deb for php-oci8 which would run with PHP 5.3 and Oracle-XE. Somehow they dont like each other. Also, if you try to compile using pecl, it throws up errors. To work around this problem, you need to download and install Oracle Instant Client Basic 11g and then compile php-oci8 using pecl. Once you install Oracle Instant Client Basic 11g, the installation of php-oci8 becomes fairly simple.

Download the Oracle Instant Client Basic 11g from the Oracle website. Generally all firefox downloads are in the Downloads folder. Now, we need to extract the file into /opt

sudo  unzip ~/Downloads/oracle-instant-client-basic-11-2.zip -d /opt

Now, install pecl using the following command

sudo apt-get install php-pear

After installation, use the following command to install php-oci8. Note: you must have php-dev and php-cli installed.

sudo pecl install php-oci8

After customary config checks, it will ask you for the oracle installation path. set the path manually to /opt/oracle/instantclient_11_2 in the following way

instantclient,/opt/oracle/instantclient_11_2

Thats it. php-oci8 will be installed. Now you can use Oracle-XE with php-oci8 in Ubuntu 10.04.

Update:

After installing, create a new file oci8.ini in /etc/php5/conf.d/ and in that add the following

[oci8]

extension=oci8.so

This same procedure will work in Fedora 12 and above , except ,you will have to create the oci8.ini file in /etc/php.d/ instead.

Share

Leave a Reply

tuxtrixmod
Scroll to Top