How to install Oracle instant client and Oracle SQL Developer

From Salix OS
Jump to: navigation, search

Oracle Instant Client installation (32bit)

Version: 12.1.0.1


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. 

 sudo installpkg oracle-instantclient12.1-basic-12.1.0.1.0-1.i386.tgz
 sudo installpkg oracle-instantclient12.1-devel-12.1.0.1.0-1.i386.tgz
 sudo installpkg oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.i386.tgz
 sudo 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


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



Oracle SQL Developer installation (32bit)

Version: 4.0.2 (4.0.2.15.21) / May 5, 2014


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) 

 jre-7u60-linux-i586.rpm
 sqldeveloper-4.0.2.15.21-1.noarch.rpm

You can use OpenJDK too ;-)

2. Convert RPM to TGZ 

 sudo rpm2tgz jre-7u60-linux-i586.rpm
 sudo rpm2tgz sqldeveloper-4.0.2.15.21-1.noarch.rpm

3. Install Java JDK and SQL Developer. 

 sudo installpkg jre-7u60-linux-i586.tgz
 sudo installpkg sqldeveloper-4.0.2.15.21-1.noarch.tgz


Maybe you will need install java ODBC driver!


Attention! Oracle SQL Developer is looking for tnsnames.ora in $ORACLE_HOME/network/admin folder. It doesn't know variable TNS_ADMIN. So make these 2 folders and make 2 symlinks: 


 sudo mkdir /usr/lib/oracle/12.1/client/network
 sudo mkdir /usr/lib/oracle/12.1/client/network/admin

 sudo ln -s /etc/oracle/sqlnet.ora /usr/lib/oracle/12.1/client/network/admin/sqlnet.ora
 sudo ln -s /etc/oracle/tnsnames.ora /usr/lib/oracle/12.1/client/network/admin/tnsnames.ora


Oracle SQL Developer in screenshots.

Runing Oracle SQL Developer
Main window
Login to the Oracle DB
Possibilities of the dabatase
Retrieved from "https://docs.salixos.org/wiki/index.php?title=How_to_install_Oracle_instant_client_and_Oracle_SQL_Developer&oldid=4763"