Getting Oracle Instant Client to Work

Summary: Installing and configuring oracle instant client

Download the 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

   c:/oracle/network/admin/sqlnet.ora
   c:/oracle/network/admin/tnsnames.ora

• Setup TNS_ADMIN environment variable to c:/oracle/network/admin

• 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.