Instant Client in Oracle 10g - Page 2
June 29, 2004
How to Install Instant Client for SQL*Plus
The installation procedures are the simplest I have ever come across for an Oracle product. Granted, I did have to search for a few different installation procedures for the Instant Client until I actually got all of the steps down. This was a bit frustrating but still did not take all that much time and I was able to find everything through the technet.oracle.com website. Remember this is only for SQL*Plus and if you want to connect by any of the different supported connection types you may need a few more steps. In addition, it is VERY MUCH RECOMMENDED you DO NOT install these files into an $ORACLE_HOME directory. I would try it but honestly did not want to spend a couple of hours backing out what I did and re-installing my full-blown Oracle Client installation.
1. Download the Basic and SQL*Plus Instant Client packages. You also might want to go ahead and download all of the other packages and keep them together as a single version of this product. Even if you do not have a need for one of the additional support libraries, they do not take but a minute and could come in handy if versions become an issue.
Contents of the Basic Package
Contents of the SQL*Plus Package
2. Unzip the packages that you will be using into a newly created directory of your choice. When I did this, I wanted a truly portable installation and ended up putting this on my USB Flash Drive. Therefore, my directory was E:\OracleInstantClient.
Contents of My Instant Client Directory
3. Set environment variables such that the following are maintained.
4. Connection methods for SQL*Plus. It does not matter if you install the Instant Client on the database server or on a true client machine, you will always need to specify some form of an Oracle Net connection name or identity. Here are some examples.
When using the Instant Client you may or may not bump up against the following extra considerations for your particular environment.
The Instant Client is available on a variety of platforms such as Linux, Solaris, HP, IBM AIX, and Windows and supports the following connection types depending on the packages you download.
The installation procedures for each of these packages at least reads as quick and easy as the SQL*Plus installation done here in this articles. The procedures basically follow what I have shown for SQL*Plus. Just be sure to visit and read the release notes for the specific packages, as there are additional, be it minor, variables or installation procedures to follow.
In a Nutshell
The only way I can conclude this article is simply to state the benefits to this new method for connecting your applications to an Oracle instance.