#!/bin/bash

# This script installs Oracle client utilities for Linux

# install Oracle Instant Client files
sudo yum -y localinstall oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
sudo yum -y localinstall oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
sudo yum -y localinstall oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
sudo yum -y localinstall oracle-instantclient12.2-tools-12.2.0.1.0-1.x86_64.rpm

sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib > \
  /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

# install and configure Perl DBD::Oracle module
export ORA_SHARE=/usr/share/oracle/12.2/client64
sudo cp $ORA_SHARE/demo/* $ORA_SHARE

sudo \
ORACLE_HOME=/usr/lib/oracle/12.2/client64 \
LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib \
/usr/local/bin/cpanm -n DBD-Oracle-1.74.tar.gz

for i in $(ls $ORA_SHARE/demo); do sudo rm -f $ORA_SHARE/$i; done

# Add Oracle ENV variables to  .bash_profile
cat << 'EOF' >> .bash_profile

ORACLE_HOME=/usr/lib/oracle/12.2/client64
PATH=$PATH:$ORACLE_HOME/bin
alias sqlplus="rlwrap sqlplus"
EOF

