Install and Setup

Configure and setup for instant client

How to install on Window

If the machine has already been installed with Oracle Client software, just download the Insight Developer and install it.
To use Oracle Instant Client, download it from Oracle Website.
After download unzip folder in say C:\ and create a folder named oracle. Inside C:\oracle create a folder bin.
Move all unzipped files inside bin folder.
Create a folder name network in C:\oracle. Inside C:\oracle\network create a folder named admin.
Create a new file called tnsnames.ora inside C:\oracle\network\admin.
Now there are 2 environment variables which need to be set:

Path=C:\oracle\bin (Add anywhere in Path)

Fire up Insight Developer and you should be able to connect to all database mentioned in tnsnames.ora
TNS_ADMIN can be ignored. If you use direct connection.
If your network is slow, download the smallest package: Instant Client Package - Basic Lite.
Recommended to download "Instant Client Package - SQL*Plus" and put it at c:\oracle\bin directory

For Version 2.21 onward, you can ignore to setup the PATH and TNS_ADMIN.
That have an options at Menu, View->Options

How to install on Mac
Insight Developer on Mac is distibuted as DMG disk image.
Download the app's .dmg file.
Double-click the .dmg file to open it up.
Drag and drop it into your “Applications” directory.
Instant Client Oracle
The dmg distributed is bundle with Instant Client Package - Basic Lite.
You can change to other Instant Client Package by go to InsightDev Application.
Right Click the "InsightDev" Application, then choose Show Packages Contents.
Remove the contains in "Libraries" direcotry and copy the new Instant Client Package into it.

Note: Make sure the libclntsh.dylib symlink is created.

Installing Oracle Instant Client on Mac OS X
For dmg that is not bundle with Instant Client Package. You need to install/setup oracle client manually.
For Mac OS X 10.8 Mountion Lion, please refer this Setting the PATH on OS X Mountain Lion

  • Download the 32 bit Instant-Client
  • Unzip in folder, let say /Libaray/Oracle.
    The usual hints say:
    Make 2 symbolic links:
    ln -s libclntsh.dylib.10.1 libclntsh.dylib
    ln -s libocci.dylib.10.1 libocci.dylib
    but that didn't work for me.
    So I made a copy of these fiels and renamed them.
  • Place the tnsnames.ora in this Folder
  • Now the Folder looks like this
    Instant Client
  • Open Terminal
    touch environment.plist
  • Double-Click environment.plist and the Property List Editor will open.
    Insert these 3 environment variables:
    oracle instant client
    ORACLE_HOME isn't necessary
  • Go back to Terminal
    mkdir .MacOSX
    cp environment.plist .MacOSX
    you can delete environment.plist
  • Restart you machine.

How to install Insight Developer on Linux

Currently Insight Developer only support three distribution methods under 32-bit Linux:

  • Debian package (.deb)
  • RPM Packages (.rpm)
  • Generic Linux 32-bit binary
Debian package will install desktop entries, adding a menu entry to the KDE or GNOME menu in the Development or Programming group. For Generic Linux 32-bit binary, you need to setup it manually.

For Generic Linux 32-bit binary, Uncompress tarbar using below command:
$tar zxf insightdev.tar.gz

The Environmnet variable LD_LIBRARY_PATH must setup to the Oracle Library.
TNS_ADMIN and ORACLE_HOME variable also need to setup either one or both.

example for bash shell:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

Use Oracle Instant Client on Linux

1. Download Oracle Instant Client from Oracle website Or Using this ora10_2.tar.gz. This zip file contains basic Instant Client 10.2 and sqlplus, after proper organize.
2. Unzip it --> example user home directory /home/tehbc/ORA10_2
3. Add shared libraries to Linux's system library path
$cd /etc/
$sudo vi ora.conf
$sudo ldconfig
4. Test for connection, eg: go to /home/tehbc/ORA10_2/bin
$./sqlplus hr/thru@//
That is an artical from "Andrew Beacock's Blog" How to add shared libraries to Linux's system library path
5. Enjoy to use Insight Developer
Note: Rememeber to $ln -s