How to install OCI8 on Ubuntu 17.10 and PHP 7.1

how_to_install_oci8_on_ubuntu_17.10_and_PHP_7.1.md

How to install OCI8 on Ubuntu 17.10 and PHP 7.1

This guide refers to Instantclient Version 12.2.0.1.0

Install Oracle Instant Client and SDK

Step 1

Download the latest Oracle Instant Client and SDK from the Oracle website (Yeah, fuck you Oracle, you need to create an account to download the files).

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

Look for instantclient-basic-linux.x64-12.2.0.1.0.zip and instantclient-sdk-linux.x64-12.2.0.1.0.zip.

Step 2

Create a new folder to store the Oracle Instant Client files on your machine.

mkdir /opt/oracle

And move your files to /opt/oracle.

Step 3

Extract the files

cd /opt/oracle
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip

Step 4

Next, we need to symlink the .so files.

ln -s /opt/oracle/instantclient_12_2/libclntsh.so.12.2 /opt/oracle/instantclient_12_2/libclntsh.so
ln -s /opt/oracle/instantclient_12_2/libocci.so.12.2 /opt/oracle/instantclient_12_2/libocci.so

Step 5

Now lets add the folder to the ldconfig's config folder.

echo /opt/oracle/instantclient_12_2 > /etc/ld.so.conf.d/oracle-instantclient.conf

And update the dynamic linker runtime bindings.

ldconfig

Great! We're almost there!

Add the extension to PHP

To install the OCI8 extension, we need to get some additional packages.

Step 1

Run these commands to install the necessary packages:

apt install php-dev php-pear build-essential libaio1

Step 2

Install the oci8 extension via PECL.

echo "instantclient,/opt/oracle/instantclient_12_2" | pecl install oci8

Step 3

We now can tell PHP to load the OCI8 extension.

echo "extension=oci8.so" >> /etc/php/7.1/mods-available/oci8.ini

ln -s /etc/php/7.1/mods-available/oci8.ini /etc/php/7.1/cli/conf.d/20-oci8.ini

ln -s /etc/php/7.1/mods-available/oci8.ini /etc/php/7.1/fpm/conf.d/20-oci8.ini

Step 4

Check if the extension is enabled.

php -m | grep oci8
php-fpm7.1 -m | grep oci8

If you see oci8, you're almost done!

Step 5

Restart PHP-FPM.

service php7.1-fpm restart

Finished! Well done! Thanks for pulling through with this tedious procedure!

@mazedlx - Thanks for the suggestion. Not sure what you mean that my OCI8 wasn't compiled for PHP 7.3. After some googling and thinking I decided to perform a

pecl uninstall oci8

I followed any prompts that came up. After the uninstall I started back over with the above tutorial at Step 2. Followed everything in the tutorial for my 18_3 install version and it worked. Thanks for your help.

@mazedlx - Thanks for the suggestion. Not sure what you mean that my OCI8 wasn't compiled for PHP 7.3. After some googling and thinking I decided to perform a

pecl uninstall oci8

I followed any prompts that came up. After the uninstall I started back over with the above tutorial at Step 2. Followed everything in the tutorial for my 18_3 install version and it worked. Thanks for your help.

I meant exactly that. 😊👍

Still works for 20.04, tested with PHP 7.4 and 8.0 with Oracle 21.1.0.0.0

Only URLs have slightly changed and current version of oci8 is PHP 8.0 only.

rm -rf /opt/oracle
mkdir -p /opt/oracle && cd /opt/oracle
# Check for updates on https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
wget https://download.oracle.com/otn_software/linux/instantclient/211000/instantclient-basic-linux.x64-21.1.0.0.0.zip
wget https://download.oracle.com/otn_software/linux/instantclient/211000/instantclient-sdk-linux.x64-21.1.0.0.0.zip
unzip instantclient-basic-linux.x64-21.1.0.0.0.zip 
unzip instantclient-sdk-linux.x64-21.1.0.0.0.zip
rm instantclient-basic-linux.x64-21.1.0.0.0.zip instantclient-sdk-linux.x64-21.1.0.0.0.zip
echo "/opt/oracle/instantclient_21_1" > /etc/ld.so.conf.d/oracle-instantclient.conf
ldconfig
pecl channel-update pecl.php.net
# Because install throws an error code if package is already installed
pecl uninstall oci8 
# https://pecl.php.net/package/oci8
# PHP 8.x
echo "instantclient,/opt/oracle/instantclient_21_1" | pecl install oci8
# PHP 7.x
#echo "instantclient,/opt/oracle/instantclient_21_1" | pecl install oci8-2.2.0
echo "extension=oci8.so" > /etc/php/8.0/mods-available/99-oracle-oci8.ini
phpenmod 99-oracle-oci8