Connect Zabbix frontend server to Oracle 11.2 database, Ubuntu 18

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

apt install php7.2-dev
mkdir -p /opt/oracle
cd /opt/oracle
mv ~/instantclient-basic-linux.x64-11.2.0.4.0.zip .
mv ~/instantclient-sdk-linux.x64-11.2.0.4.0.zip .

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

sudo sh -c "echo /opt/oracle/instantclient_11_2 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

pecl install oci8
# type 'instantclient,/opt/oracle/instantclient_11_2' without quotes when requested
# Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : instantclient,/opt/oracle/instantclient_11_2

# a successfull output
# configuration option "php_ini" is not set to php.ini location
# You should add "extension=oci8.so" to php.ini

echo "extension=oci8.so"> /etc/php/7.2/mods-available/oci8.ini
ln -s /etc/php/7.2/mods-available/oci8.ini /etc/php/7.2/fpm/conf.d/20-oci8.ini

No comments: