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