Install OCI8 PHP-5.6

install_oci8_php5.6.md

Install OCI8 pada Ubuntu 20.04 dengan PHP 5.6

Download Oracle Instant Client dan SDK :

https://www.oracle.com/id/database/technologies/instant-client/linux-x86-64-downloads.html

Download kedua package ini :

• Basic Package (ZIP): instantclient-basic-linux.x64-12.2.0.1.0.zip

• SDK Package (ZIP): instantclient-sdk-linux.x64-12.2.0.1.0.zip

Buat folder untuk instantclient

mkdir /usr/lib/oracle
mkdir /usr/lib/oracle/12.2

Copy file instantclient ke folder yang dibuat sebelumnya. lalu, extract file

cp instantclient-basic-linux.x64-12.2.0.1.0.zip /usr/lib/oracle/12.2/
cp instantclient-sdk-linux.x64-12.2.0.1.0.zip /usr/lib/oracle/12.2/

cd /usr/lib/oracle/12.2/

unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip

mv instantclient_12_2 lib

Buat symbolic link :

cd /usr/lib/oracle/12.2/lib/
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so

Konfigurasi lib path :

Edit /etc/environment lalu tambahkan dibaris akhirnya

LD_LIBRARY_PATH="/usr/lib/instantclient_12_2"

Edit ~/.bashrc lalu tambahkan dibaris akhirnya

export LD_LIBRARY_PATH=/usr/lib/instantclient_12_2

Buat file konfig oracle untuk LDCONFIG

echo /usr/lib/oracle/12.2/lib > /etc/ld.so.conf.d/oracle.conf

Jalankan ldconfig

ldconfig

Install php5.6-dev dan libaio1

apt install php5.6-dev libaio1

Download pecl lalu untar

wget https://pecl.php.net/get/oci8-2.0.12.tgz

tar -xvzf oci8-2.0.12.tgz

Compile dan config

cd oci8-2.0.12

phpize

./configure -with-oci8=shared,instantclient,/usr/lib/oracle/12.2/lib/

make install

Tambahkan extensi extension=oci8.so pada php.ini

echo "extension=oci8.so" >> /etc/php/5.6/cli/php.ini

Restart apache

systemctl restart apache2

Cek OCI

php -i | grep oci

Jika berhasil maka outputnya seperti dibawah ini :

oci8
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20