Wednesday, July 9, 2014

How to install OCI8 PHP extension in Ubuntu 14.04 to work with Oracle

To work with Oracle DBMS using PHP you need to install oci8 extension.

0. Install Oracle client instant:

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

The Oracle instant client will be installed at /usr/lib/oracle/12.1/client64

Export the ORACLE_HOME and $LD_LIBRARY_PATH environment variable:

$ export ORACLE_HOME=/usr/lib/oracle/12.1/client64
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib



1. Install php-pear (needed by pecl) and php5-dev:

$ sudo apt-get install pear
$ sudo apt-get install php5-dev


2. Install oci8 extension using pecl:

$ sudo pecl install oci8

This will ask for Oracle Home Directory – give the path of the instant client:

'instantclient,/usr/lib/oracle/12.1/client64/lib'


3. Enable oci8 in php.ini:

$ sudo echo "extension=oci8.so" >> /etc/php5/fpm/php.ini 
$ sudo echo "extension=oci8.so" >> /etc/php5/cli/php.ini 


4. Restart php5-fpm (or apache if you're using it instead):

$ sudo service php5-fpm restart


5. Check if the oci8 extension has been enabled by loading the phpinfo.php file in your browser:

phpinfo.php

<?php
phpinfo();
?>


6. Try to connect to your Oracle database using the repl interface (the built-in php repl or boris):

$ php -a
Interactive mode enabled

php > $OracleListener = "my.oracleserver.com:1521/MYDBSID";
php > $OracleUsername = "MyOraUser";
php > $OraclePassword = "MyOraPasswd";
php > $conn = oci_connect($OracleUsername, $OraclePassword, $OracleListener);
php > $conn = oci_connect($username, $passwd, $connstr);                                                                     php > if (!$conn) {
php { $e = oci_error();
php { echo $e;
php { }
php > $sql = "select * from mytable where username='genius'";
php > $stmt = oci_parse($conn, $sql);
php > oci_execute($stmt);
php > $row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS);
php > foreach ($row as $item) {
php { echo $item;
php { }