First of all download Oracle Instant Client package Version 12.2.0.1.0 from oracle.com. There are some packages of this version to connect the oracle server instance. This is the installing procedure of Microsoft Windows 7/8/10.
- Basic Package
- Basic Light Package
- SQL*Plus Package
- Tools Package
- SDK Package
- JDBC Supplement Package
- ODBC Package
- Precompiler Package
Basic Package Installation:
Download basic package from the link https://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-windows.x64-12.2.0.1.0.zip
Download file “vcredist_x64.exe” for windows 7/8 to Fix MSVCR120.dll is missing in Windows https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package
Copy file into a drive
Create tnsnames.ora in this folder
This PC/My Computer => Advanced system settings => Advance Tab => Environment variables => System variables => New
New System Variable
Variable name: TNS_ADMIN
Variable value: C:\instantclient_12_2
This PC/My Computer => Advanced system settings => Advance Tab => Environment variables => System variables => Edit => Path => C:\instantclient_12_2
