How to install Oracle instant client and Oracle SQL Developer

From Salix OS
Revision as of 10:48, 23 June 2014 by Baran (Talk | contribs)

Jump to: navigation, search

Under construction, thnx !


Oracle Instant Client installation

1. Download Oracle Instant Client (you need to register - free)

(http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

oracle-instantclient12.1-basic-12.1.0.1.0-1.i386.rpm

oracle-instantclient12.1-devel-12.1.0.1.0-1.i386.rpm

oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.i386.rpm

oracle-instantclient12.1-jdbc-12.1.0.1.0-1.i386.rpm


2. Install rpm and rpm2tgz

sudo slapt-get --update

sudo slapt-get -i rpm

sudo slapt-get -i rpm2tgz


3. Convert RPM to TGZ (alien util is not good for this step in this case)

sudo rpm2tgz oracle-instantclient12.1-basic-12.1.0.1.0-1.i386.rpm

sudo rpm2tgz oracle-instantclient12.1-devel-12.1.0.1.0-1.i386.rpm

sudo rpm2tgz oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.i386.rpm

sudo rpm2tgz oracle-instantclient12.1-jdbc-12.1.0.1.0-1.i386.rpm


4. Install generated TGZ files.

installpkg oracle-instantclient12.1-basic-12.1.0.1.0-1.i386.tgz

installpkg oracle-instantclient12.1-devel-12.1.0.1.0-1.i386.tgz

installpkg oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.i386.tgz

installpkg oracle-instantclient12.1-jdbc-12.1.0.1.0-1.i386.tgz


All will be installed in /usr/lib/oracle/12.1/client


5. Create directory /etc/oracle and make (or copy) files tnsnames.ora and sqlnet.ora to this directory:

sqlnet.ora

AUTOMATIC_IPC = OFF

USE_DEDICATED_SERVER = OFF

NAMES.DEFAULT_DOMAIN = <YOUR DOMAIN>

NAMES.DIRECTORY_PATH= (TNSNAMES)

  1. SQLNET.EXPIRE_TIME = 600

SQLNET.EXPIRE_TIME = 0

NAMESCTL.NOCONFIRM=TRUE


tnsnames.ora (example)

TEST.DEMO.COM=(DESCRIPTION = 

 (ADDRESS=(PROTOCOL=TCP)(Host = xxx.demo.com)(Port = 1526))
 (CONNECT_DATA=(SID=DEMOTEST))

)


6. Configure Oracle Instant Client.

echo /usr/lib/oracle/12.1/client >> /etc/ld.so.conf

echo export ORACLE_HOME=/usr/lib/oracle/12.1/client >> /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

Retrieved from "https://docs.salixos.org/wiki/index.php?title=How_to_install_Oracle_instant_client_and_Oracle_SQL_Developer&oldid=4714"