Wednesday, August 26, 2009

Oracle instant client install procedure

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.

2. Unzip the packages into a single directory such as "instantclient".


3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

4. Copy a tnsnames.ora file and set the location of TNS_ADMIN.

5. Add the folder under which sqlplus executable is present to PATH variable.

6. Execute sqlplus from command prompt

No comments: