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)
TNS_ADMIN=C:\oracle\network\admin
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.
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
- Open Terminal
touch environment.plist
Double-Click environment.plist and the Property List Editor will open. - Go back to Terminal
mkdir .MacOSX
cp environment.plist .MacOSX
you can delete environment.plist - Restart you machine.
Insert these 3 environment variables:
ORACLE_HOME isn't necessary
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
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
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
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/ld.so.conf.d
$sudo vi ora.conf
/home/tehbc/ORA10_2/lib
$sudo ldconfig
4. Test for connection, eg: go to /home/tehbc/ORA10_2/bin
$./sqlplus hr/thru@//192.168.1.2/xe
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 libclntsh.so.11.1 libclntsh.so
