Installing the OCI8 and PDO_OCI Extensions for PHP5

Currently I work for a company that loves to use Oracle projects in PHP projects, sometimes with version 11g.



Most of the developers of this company running under Windows. Over the past month, several of them have decided to join Linux and have set themselves Ubuntu. After a few days after installing the OS itself, the guys were faced with the task of installing PHP drivers for working with Oracle DBMS - OCI8 and PDO_OCI based on Oracle instant client 11.2, which they could not solve on their own.



I did not find a detailed, fully working manual in Russian, by which a newbie in Linux could perform all the manipulations himself. As a result, I had to do a series of the same actions on their machines several times and write a manual, which I present to you.

')

The manual is written for users of Ubuntu Linux, but with some changes suitable for users of most Linux'ov.

Preparing to install

1. You should be able to execute commands under the administrator;
2. You must have php5 installed with the following packages (installation command with list):
   
   sudo apt-get install php5 php5-dev php-pear php5-cli

sudo pecl install pdo
3. You must have the libaio1 library installed:
   
   sudo apt-get install libaio1

Installing Oracle instant client

Download Oracle's Oracle client from the official site http://oracle.com for its processor architecture and OS.

For Linux instant client comes in two versions:

• RPM package - Linux, CentOS, Fedora, Red Hat Enterprise Linux, Mandriva Linux, SUSE Linux, etc. who has RPM support;
• ZIP archive for everyone else.

You need to download 2 files:

• instantclient-basic - Oracle instant client itself
• instantclient-sdk - a set of libraries for developing applications for Oracle instant client

You can also download:

• instantclient-sqlplus - SQL * Plus

Create a directory in which the Oracle instant client files will be located (the / opt directory reserved for additional software packages is good for this):

sudo mkdir -p /opt/oracle/



Move the downloaded files to / opt / oracle and go to the destination folder (let's say that you downloaded the “zip archives” to the “downloads” folder of your user):

sudo mv ~/downloads/instantclient-*.zip /opt/oracle/

cd /opt/oracle/



Unzip all downloaded archives:

sudo unzip instantclient-basic-*-*.zip

sudo unzip instantclient-sdk-*-*.zip

If you downloaded SQL * Plus :

sudo unzip instantclient-sqlplus-*-*.zip



As a result, in the / opt / oracle directory was created, for the Oracle instant client 11.2.0.2.0, the instantclient_11_2 directory. Rename this directory to instantclient (if you have another version / directory, change the command) and go to it:

sudo mv instantclient_11_2 instantclient

cd instantclient



Next, you need to create several additional directories and symbolic links for the normal operation of the client (pay attention to the version and if you have another change commands):

sudo ln -s /opt/oracle/instantclient/libclntsh.so.* /opt/oracle/instantclient/libclntsh.so

sudo ln -s /opt/oracle/instantclient/libocci.so.* /opt/oracle/instantclient/libocci.so

sudo ln -s /opt/oracle/instantclient/ /opt/oracle/instantclient/lib



sudo mkdir -p include/oracle/11.2/

cd include/oracle/11.2/

sudo ln -s ../../../sdk/include client

cd -



sudo mkdir -p lib/oracle/11.2/client

cd lib/oracle/11.2/client

sudo ln -s ../../../ lib

cd -



Create a configuration file in which the directory will be specified to search for the Oracle instant client libraries, and include it:

echo /opt/oracle/instantclient/ | sudo tee -a /etc/ld.so.conf.d/oracle.conf

sudo ldconfig



Since there is no / usr / include / php directory in Ubuntu, and the client is still looking for it, we will create a symbolic link to its php5 equivalent:

sudo ln -s /usr/include/php5 /usr/include/php

Install OCI8

After all our manipulations, the oci8 extension is remarkably installed using the pecl command :

sudo pecl install oci8

we are asked to enter the path to the Oracle instant client, to which we must respond:

instantclient,/opt/oracle/instantclient



Create an extension connection file:

echo "; configuration for php oci8 module" | sudo tee /etc/php5/conf.d/oci8.ini

echo extension=oci8.so | sudo tee -a /etc/php5/conf.d/oci8.ini

Set PDO_OCI

To install PDO_OCI, we first need to download it from the pear repository .

Update the pear package list:

sudo pecl channel-update pear.php.net



Download and place the archive in the temporary directory:

sudo mkdir -p /tmp/pear/download/

cd /tmp/pear/download/

sudo pecl download pdo_oci



Extract the contents of the archive and go to it:

sudo tar xvf PDO_OCI*.tgz

cd PDO_OCI*



Here we need to adjust the file config.m4, since it does not contain data about our version of Oracle instant client, the latest changes are dated 2005. Run your favorite editor and make changes marked with "+" (note the version and if you have another one, change the lines):

sudo vim config.m4



The following is a diff of two files:

***************

*** 7,12 ****

--- 7,14 ----

if test -s "$PDO_OCI_DIR/orainst/unix.rgs"; then

PDO_OCI_VERSION=`grep '"ocommon"' $PDO_OCI_DIR/orainst/unix.rgs | sed 's/[ ][ ]*/:/g' | cut -d: -f 6 | cut -c 2-4`

test -z "$PDO_OCI_VERSION" && PDO_OCI_VERSION=7.3

+ elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.11.2; then

+ PDO_OCI_VERSION=11.2

elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.10.1; then

PDO_OCI_VERSION=10.1

elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.9.0; then

***************

*** 119,124 ****

--- 121,129 ----

10.2)

PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)

;;

+ 11.2)

+ PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)

+ ;;

*)

AC_MSG_ERROR(Unsupported Oracle version! $PDO_OCI_VERSION)

;;

***************



Preparing the environment for php extension using the phpize command (pay attention to the version, if you change it for another):

sudo phpize



Configure the package installer and install the package (note the version, if you have another change):

sudo ./configure --with-pdo-oci=instantclient,/opt/oracle/instantclient/,11.2

sudo make

sudo make install





Create a connection file for it:

echo "; configuration for php PDO_OCI module" | sudo tee /etc/php5/conf.d/pdo_oci.ini

echo extension=pdo_oci.so | sudo tee -a /etc/php5/conf.d/pdo_oci.ini

Summing up

Restart apache and check for installed extensions:

sudo /etc/init.d/apache2 restart

php -m

Conclusion

The manual is based on this post , which has been slightly reworked - bugs fixed and additions made.



I hope the article will be useful not only to my colleagues.