codymoorhouse/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.md

      
    Raw
  

              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
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.
pecl install oci8
When you are prompted for the Instant Client location, enter the following:
instantclient,/opt/oracle/instantclient_12_2
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!