Good tip from Eli Journals

I subscribe to tons of emails with tips and articles and the like. Found this in my inbox this morning from Eli Journals:


Simplify client installs with Instant Client (10g)
If you need to put an Oracle client on several workstations--or if you simply want the Oracle client on a flash drive--Oracle now has a solution to fit your needs. With 10g, Oracle has introduced Instant Client. It’s the barebones software for making a connection to Oracle.

In addition to the platform downloads, there are several Instant Client packages you can download from Oracle, such as Basic, Basic Light, JDBC, and SQL*Plus, among others (installing Instant Client requires at least the Basic or Basic Light package). Each package is a small ZIP file and doesn’t require installation itself. Instant Client and the packages are available at www.oracle.com/technology/tech/oci/instantclient/instantclient.html.

You can use Instant Client for a variety of purposes, such as on Linux to allow Tora to connect to a database, or on Microsoft Windows as a quick way to use SQL*Plus from a flash drive.

To use Instant Client:
1. Unzip the files
2. Add the location of Instant Client to your path, along with TNS_ADMIN, LD_LIBRARY_PATH, SQL_PATH and NLS_LANG.

To utilize Instant Client on a flash drive, set up a quick batch file for Windows in order to set the variables:

SET PATH=%CD%;%PATH
SET TNS_ADMIN=%CD%
SET LD_LIBRARY_PATH=%CD%
SET SQLPATH=%CD:~0,3%scripts\sql
SET NLS_LANG=AMERICAN_AMERICA.UTF8

This is necessary because you typically don’t know which drive letter it will map to from system to system.

You should also modify the SQLPATH and NLS_LANG variables to fit your environment. Then, simply open up a command prompt (cmd), cd to the client directory, and run your batch file.

This tip was contributed by Scott Dial.

Comments

Jim Berry said…
Rich,

We also receive email from Eli Journals - hundreds of thousands of spam email that has crippled our mail server and cost our company time and money. Eli Journals is a blatant Spammer -
Read Our Story