Be a Rebel

I am personally working on a Project, that has web UI having Apache server, PHP on server side and Oracle as database. For this I need to configure PHP so that it can talk to my Oracle database. The first error I got while querying the database using PHP was.

Call to undefined function oci_connect()

For this, we need to first install php5-pear and then using pecl, we need to install OCI8. As I am using openSUSE 13.2

sudo zypper in php5-pear

Then install OCI8 extension for PHP

sudo pecl install oci8

This will install and compile oci8 module. This command will ask for ORACLE HOME location. If everything goes fine, this will end like

Build process completed successfully
Installing '/usr/lib64/php5/extensions/oci8.so'
install ok: channel://pecl.php.net/oci8-2.0.8
configuration option "php_ini" is not set to php.ini location
You should add "extension=oci8.so" to php.ini

Add the line

extension=oci8.ini

to your /etc/php/apache2/php.ini and /etc/php/cli/php.ini Then restart Apache server

sudo systemctl restart apache2.service

After this when I tried to access Oracle, I got the error “Call to undefined function oci_connect()” again! When I checked in /var/log/apache2/err_log, I found this:

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php5/extensions/oci8.so' - libnnz11.so: cannot open shared object file: No such file or directory in Unknown on line 0

So even though the file libnnz11.so is present at $ORACLE_HOME/lib, I still get this error. To get over this error, we need two more steps. Create a file /etc/ld.so.conf.d/oracle.conf and add this line it:

/u01/app/oracle/product/11.2.0/xe/lib

and run “ldconfig”. Restart your Apache server again, and this time things should work!