Difference between revisions of "How to install Oracle instant client and Oracle SQL Developer"

Revision as of 12:08, 23 June 2014

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 (/etc/oracle/sqlnet.ora)

 AUTOMATIC_IPC = OFF
 USE_DEDICATED_SERVER = OFF
 NAMES.DEFAULT_DOMAIN = <YOUR DOMAIN>
 NAMES.DIRECTORY_PATH= (TNSNAMES)
 #SQLNET.EXPIRE_TIME = 600
 SQLNET.EXPIRE_TIME = 0
 NAMESCTL.NOCONFIRM=TRUE

tnsnames.ora (/etc/oracle/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.

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

7. Oracle Instant Client is installed and configured! Reboot PC ;-)

Oracle SQL Developer installation

1. Download Oracle Java JDK and Oracle SQL Developer (you need to register - free)

(http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html)