Differences

This shows you the differences between two versions of the page.

Link to this comparison view

blog:configuringinstantclient [2009/11/27 17:53] (current)
Line 1: Line 1:
 +====== Getting Oracle Instant Client to Work ======
  
 +Summary: Installing and configuring oracle instant client
 +
 +Download the [[http://​www.oracle.com/​technology/​tech/​oci/​instantclient/​instantclient.html|oracle instant client software]] ​
 + * unzip the instant client software into a directory say C:/oracle
 + * Setup the PATH environment variable to include this location.
 + * Setup sqlnet.ora and tnsnames.ora file for your servers
 +<​code>​
 +   ​c:/​oracle/​network/​admin/​sqlnet.ora
 +   ​c:/​oracle/​network/​admin/​tnsnames.ora
 +</​code>​
 + * Setup TNS_ADMIN environment variable to c:/​oracle/​network/​admin
 +
 +===== How to setup environment variable ? =====
 + * Right mouse click on "My Computer"​ - it will be either on your desktop or alternatively it can be located in the left hand side of Windows Explorer
 + * Select Properties
 + * Select the Advanced Tab
 + * Pressed the "​Environment Variables"​ button
 + * Press the "​New"​ button for the user variables section
 + * Enter VARIABLE and the VALUE
 +
 +You've now got an instance oracle client.
 +{{tag>​oracle network}}