Oracle12c Instant Client Config

Oracle Instant Client

Download

See the Instant Client Home Page for more information about Instant Client. Find installation instructions here to download following files from Instant Client for Linux x86-64

1. instantclient-basic-linux.x64-12.2.0.1.0.zip
2. instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
3. instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
4. instantclient-tools-linux.x64-12.2.0.1.0.zip
5. instantclient-sdk-linux.x64-12.2.0.1.0.zip

Upload to Droplet

scp ~/Downloads/instantclient-*.zip  dev.chorke.org:/opt/cli/oracle/oracle12c/
ssh dev.chorke.org

Unzip libraries

cd /opt/cli/oracle/oracle12c/
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip
unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
unzip instantclient-tools-linux.x64-12.2.0.1.0.zip
rm -rf instantclient-*.zip

Soft link creation

cd instantclient_12_2/
ln -s libocci.so.12.1 libocci.so
ln -s libclntsh.so.12.1 libclntsh.so

Installation libaio

yum install libaio
sh -c "echo /opt/cli/oracle/oracle12c/instantclient_12_2 > /etc/ld.so.conf.d/oracle-instantclient.conf"
ldconfig

Environment Variable

# export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2:$LD_LIBRARY_PATH"
export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2"
export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2"
export PATH="$ORACLE_HOME:$PATH"

Network Configuration

mkdir -p $ORACLE_HOME/network/admin
cd $ORACLE_HOME/network/admin

sqlnet.ora

# $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)

tnsnames.ora

# $ORACLE_HOME/network/admin/tnsnames.ora
CKI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CKI)
    )
  )

CKO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CKO)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
    )
  )