Oracle12c Instant Client Config: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
(Created page with "== Oracle Instant Client == === Download === See the [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Instant Client Home Page] for more i...")
 
Line 33: Line 33:
  ldconfig
  ldconfig


=== Env Variable ===
=== 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:$LD_LIBRARY_PATH"
  export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2"
  export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2"
  export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2"
  export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2"
  export PATH="$ORACLE_HOME:$PATH"
  export PATH="$ORACLE_HOME:$PATH"

Revision as of 10:47, 13 December 2017

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-sdk-linux.x64-12.2.0.1.0.zip
  4. instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
  5. instantclient-tools-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
mkdir -p /opt/cli/oracle/oracle12c/instantclient_12_2/network/admin

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"