[HOW TO] Install Oracle Instant Client

[monty]

How to install Oracle Instant Client 12.1 64bit?

1) Download Oracle Instant Client (RPM files):

oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm
oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

http://www.oracle.com/technetwork/topic ... 92277.html

2) Install downloaded RPM files (under root)

urpmi oracle*.rpm

3) Set paths and variables

echo /usr/lib/oracle/12.1/client64 >> /etc/ld.so.conf
echo export ORACLE_HOME=/usr/lib/oracle/12.1/client64 >> /etc/profile
echo export TNS_ADMIN=/etc/oracle >> /etc/profile
echo export SQLPATH=$ORACLE_HOME >> /etc/profile
echo export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH >> /etc/profile
echo export PATH=$PATH:$SQLPATH >> /etc/profile

4) Make TNS NAMES, copy it to the spec. directory and make links ... (some apps. need it to have in directory /usr/lib/oracle/12.1/client64/network/*)

mkdir /etc/oracle
cp sqlnet.ora /etc/oracle/sqlnet.ora
cp tnsnames.ora /etc/oracle/tnsnames.ora
mkdir /usr/lib/oracle/12.1/client64/network
mkdir /usr/lib/oracle/12.1/client64/network/admin
ln -s /etc/oracle/sqlnet.ora /usr/lib/oracle/12.1/client64/network/admin/sqlnet.ora
ln -s /etc/oracle/tnsnames.ora /usr/lib/oracle/12.1/client64/network/admin/tnsnames.ora

5) Restart PC / NTB
6) You can install apps ... Oracle SQL developer (http://www.oracle.com/technetwork/devel ... 97090.html) ...

Attention: You need install Oracle JDK for Oracle SQL developer (http://www.oracle.com/technetwork/java/ ... 38363.html).


Examples of ORA FILES

sqlnet.ora

AUTOMATIC_IPC = OFF
USE_DEDICATED_SERVER = OFF
NAMES.DEFAULT_DOMAIN = test.cz
NAMES.DIRECTORY_PATH= (TNSNAMES)
#SQLNET.EXPIRE_TIME = 600
SQLNET.EXPIRE_TIME = 0
NAMESCTL.NOCONFIRM=TRUE

tnsnames.ora

MYAPP.TEST.CZ=(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST = oracle.test.cz)(Port = 1526))
(CONNECT_DATA=(SID = MYAPP))
)

Good luck

Rene