[HOW TO] Install Oracle Instant Client

Ответить
Аватара пользователя
monty
Сообщения: 12
Зарегистрирован: 28 дек 2016, 18:31
Operating system: Linux - Rosa linux, CentOS / Debian
Откуда: Czech Republic - Europe
Контактная информация:

[HOW TO] Install Oracle Instant Client

Сообщение monty » 03 май 2017, 08:34

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) ... :Yahoo!:

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
oracle-sqldeveloper01.jpg
oracle-sqldeveloper02.jpg

Ответить

Вернуться в «Desktop»