Oracle Database 12c Client/Driver installation on Windows 7 or Windows 10

Installation of Oracle 12c Client Software

  1. Download the Oracle Client from oracle.com
  2. Launch the installation by running the .\winx64_12102_client\client after extracting the zip file
  3. Choose Administrator and click Next.
  4. Choose English and click Next.
  5. Choose Use Windows Built-in Account and click Next.
  6. Set the Oracle Base to “C:\Oracle” and the Software Location to “C:\Oracle\product\12.1.0\client_64” and click Next.
  7. Select 64-bit Native Mode and click Next.
  8. Complete any prerequisite issues, if presented.
  9. Click Install to start the installation.
  10. Click Finish.

After Installation, Set the system environment variable and copy the Oracle connection files to the appropriate location

Create TNS_ADMIN environment variable

  1. Launch System Properties from the Control Panel (Control Panel → System and Security → System)
  2. Click Advanced system settings.
  3. Click Environment Variables.
  4. Click the bottom “New” button under the System Variables section.
  5. Type “TNS_ADMIN” as the Variable name and “C:\Oracle\product\12.1.0\client_64\network\admin” as the Variable value (without quotes) and click OK.
  6. Click OK to close Environment Variables.

Copy and existing TNSNAMES.ora and SQLNET.ora files to the new installation directory, or create your own, depending on your organization

  1. Browse to your copy of the tnsnames.ora and sqlnet.ora and right-click on them and choose copy.
  2. In another window, browse to C:\Oracle\product\12.1.0\client_64\network\admin and past these two files in this directory.
  3. Verify that the files were copied directly by using tnsping to ping a connection to a database instance.
  4. Open a command prompt window.
  5. Type “tnsping <DBSERVER>” and press enter.
  6. The last line of the output should say OK (## msec) which shows a successful ping.
Please follow and like us:

Add a Comment

Your email address will not be published. Required fields are marked *