- Click to view our Accessibility Policy
- Skip to content
Oracle Instant Client Downloads
for Microsoft Windows 32-bit
See the Instant Client Home Page for more information about Instant Client.
The installation instructions are at the foot of the page.
Client-server version interoperability is detailed in Doc ID 207303.1. For example, Oracle Call Interface 18.3 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.
Permanent links to the latest packages are: Basic, Basic Light, SQL*Plus, Tools, SDK, JDBC Supplement, ODBC
Version 21.8.0.0.0
Base — one of these packages is required
Tools — optional packages
Development and Runtime — optional packages
Version 19.17.0.0.0
Base — one of these packages is required
Tools — optional packages
Development and Runtime — optional packages
Version 18.5.0.0.0
Base — one of these packages is required
Tools — optional packages
Development and Runtime — optional packages
Version 12.2.0.1.0
Base — one of these packages is required
Tools — optional packages
Development and Runtime — optional packages
Version 12.1.0.2.0
Version 11.2.0.4.0
Version 11.1.0.7.0
Version 10.2.0.5
Version 10.1.0.5
Instant Client Installation for Microsoft Windows 32-bit
See the Instant Client Home Page for more information about Instant Client packages.
Client-server version interoperability is detailed in Doc ID 207303.1. For example, Oracle Call Interface 18.3 and 12.2 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.
- Download the appropriate Instant Client packages for your platform. All installations require the Basic or Basic Light package.
- Unzip the packages into a single directory such as
C:oracleinstantclient_12_2 - Add this directory to the
PATHenvironment variable. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path - Download and install the correct Visual Studio Redistributable from Microsoft. Instant Client 12.2 requires the Visual Studio 2013 redistributable. Instant Client 12.1 requires the Visual Studio 2010 redistributable.
- If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, then create a subdirectory
C:oracleinstantclient_12_2networkadmin - Start your application.
This is the default Oracle client configuration directory for applications linked with this Instant Client.
Alternatively, Oracle client configuration files can be put in another, accessible directory. Then set the environment variable TNS_ADMIN to that directory name.
ODBC users should follow the ODBC Installation Instructions.
<- Install
Overview
What follows is the most common way to install the Oracle 19 Windows 32-bit client.
Prerequisites
• Download 19c Client32 to your software dir (Ex: C:sw).
• Unzip NT_193000_client.zip.
It will create a NT_193000_client and ...client32 sub directories.
Ensure This is Done
Set windows system to show file extensions:
Windows-Key 🠊 File Explorer 🠊 View 🠊 [x] File name extensions
Procedure
1. As Administrator run C:swNT_193000_clientclient32setup.exe.
Installer loads...
2. Installation Type: (x) Administrator
If OS listed as unsupported, install without prerequisites checks.
[INS-13001] Oracle Database Client is not supported on this operating system.
Are you sure you want to continue [Yes]
3. Oracle Home User Selection: (x) Use Windows Built-in Account
4. Installation Location:
Oracle base: C:appclientoracle
Software location: C:appclientoracleproduct19.0.0client_1
5. Summary: Select [Install]
Process runs...
Press [Close] when completed.
The above adds this entry to the PATH env var: C:appclientoracleproduct19.0.0client_1bin;
Validate Driver Installed
1. Run 32-bit Microsoft ODBC Administrator.
Ex: C:WindowsSysWOW64odbcad32.exe
2. Select Drivers tab.
3. Scroll down, you should now see an entry for: Oracle in OraClient19Home1_32bit
TNS Administration
1. DetermineSet path to tnsnames.ora.
If your system has multiple Oracle clients on it - try using the
tnsnames.ora under the TNS_ADMIN path.
Otherwise set TNS_ADMIN env value to:
C:appclientoracleproduct19.0.0client_1networkadmin
2. Create appropriate entry in the tnsnames.ora file if not already done.
3. Make sure your Windows system does not name the file
with a .txt extension: tnsnames.ora.txt
GO CHECK!
Validate Connection
Ensure you can do the following to your Oracle database server.
1. Ping IP: ping <OracleDBSrv or RACSCAN>
Ex: ping 192.168.1.42
2. Ping Port (via paping.exe etc.)
Ex: paping -p 1521 192.168.1.42
3. TNS Ping: tnsping <MyTnsnames.ora Service Name>
Ex: tnsping ORADB
Create System DSN
1. C:WindowsSysWOW64odbcad32.exe
2. System DSN tab.
3. [Add] -> Select driver: "Oracle in OraClient19Home1_32bit" -> [Finish]
Data Source Name: ORADB
TNS Serice Name: ORADB
User ID: <YourOracleUserAccount>
[Test Connection]
If connection Sucessful Save by pressing: [OK]
If your TNS service name is not in the drop-down list box go back to: Validate Connection.
APPENDIX
tnsnames.ora Example
MYDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb1)
)
)
MYDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.52)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb2)
)
)
Registry Entries Made By Install
ORACLE_BASE: C:appclientoracle ORACLE_HOME: C:appclientoracleproduct19.0.0client_1 HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBCINST.INI HKEY_LOCAL_MACHINESOFTWAREWow6432NodeOracleKEY_OraClient19Home1_32bit
Related Resources
Oracle ODBC Driver Release Notes
Oracle Client – это официальный клиент (программа), благодаря которому вы можете работать в базе данных Oracle. Вы получаете доступ базе данных, которая находится на стороннем компьютере, подсоединившись через удаленный сервер.
Воспользуйтесь этим клиентом и войдите в профиль, а также просканируйте права доступа и составления запросов. В этом клиенте вы можете работать в собственной БД. Этот софт можно установить на компьютер с OS Windows.
Войдя в эту программу, вы сможете просматривать БД, используя «проводниковую структуру файлов», но с практичным интерфейсом и оболочкой.
Версии
Сейчас в сети можно скачать этот клиент с «билдом» 12.0, но версия 11g считается намного лучше. Клиент Oracle Client 11g устанавливают на многих предприятиях и организациях. Софт можно устанавливать на компьютеры, в которых операционная система поддерживает 32 и 64 битную структуру файлов.
Главная особенность 32 разрядной версии программы – это поддержка Toad, SQL Developer и прочих инструментов визуализации. Версия x64 не подходит для подключения сторонних модулей.
Инсталляция
Устанавливая этот софт, вы выбираете тип установки: Instant Client, Administrator, Runtime и Custom. Инсталлировав клиент в первом режиме, вы сможете работать с разделенными библиотеками.
Указав Administrator, вы установите консоль администратора, которая интегрируется в дополнительные библиотеки клиента. В режиме Runtime вы инсталлируете пакет файлов вспомогательных утилит для простой обработки готовой базы данных.
В режиме «Custom» вы сами подбираете составные части, а потом установить их. Выбрав режим инсталляции, нажмите установить и подождите, пока установщик скопирует все файлы.
Полноценная работа софта доступна без инсталляции вспомогательных модулей и драйверов. Oracle Client также поддерживает работу через меню автозагрузки операционной системы. Этот клиент доступен для закачки в бесплатном режиме.
Ключевые особенности
- софт позволяет работать с удалёнными базами данных;
- перед установкой клиента можно воспользоваться одним из четырёх вариантов;
- программа запускается на 32 и 64-битных сборках OS Windows;
- этот клиент распространяется официально и создан разработчиками от Oracle;
- программа доступна для закачки в бесплатном режиме;
- графическая оболочка предназначена для неопытного пользователя компьютера.
On this page:
- Overview
- Download the client directly from Oracle’s website
Overview
At Indiana University, to download the Oracle client for Windows, UITS recommends downloading the client directly from Oracle’s website. This requires a valid OTN (Oracle Technology Network) username and password. If you do not have a valid OTN username and password, visit Oracle Database Software Downloads. At the top, hover over «Sign In», click , and then follow the on-screen instructions.
Download the client directly from Oracle’s website
To download the Oracle client directly from Oracle’s website:
- Go to Oracle Database Software Downloads.
- Under «Oracle Database 19c», below «19.3 — Enterprise Edition», to the far right of «Microsoft Windows x64 (64-bit)», click .
- Scroll down to the appropriate Oracle client for your operating system:
- 32-bit: Under «Oracle Database 19c Client (19.3) for Microsoft Windows (32-bit)», click . This file requires 1 GB of free space on your hard drive.
- 64-bit: Under «Oracle Database 19c Client (19.3) for Microsoft Windows (x64)», click . This file requires 1 GB of free space on your hard drive.
You will be prompted to accept Oracle’s license agreement and enter a valid OTN username and password. Once you have done so, you will see the «File Download» dialog box. If you do not have an OTN username and password, see the instructions for getting one above.
- Save the file.
- In Windows, navigate to the file, right-click it, and then select .
- Select a destination folder for the extracted files, and then perform the extraction.
- To launch the Oracle Client Installer, go to the destination folder, open the
clientdirectory, and then double-click (the Oracle setup file).At this point:
- Windows may prompt you for an administrator username and password. Enter an administrator username and password to proceed.
- Windows may present an «Open File — Security Warning» dialog box. Click to proceed.
It may take a minute for the «Oracle Client Installer» window to appear. To see it, you may need to minimize any other application windows that are open.
This is document agpr in the Knowledge Base.
Last modified on 2021-09-21 17:49:41.
Concerned about risks and want to lock down your Oracle client for end user Windows PCs?
Have a need for the ‘cross connection query’ feature of Toad Data Point? The solution is within your grasp!
Let’s get straight to it. You need an Oracle client to access an Oracle database from Toad Data Point. Let me share my step by step instruction in an easy-peasy-lemon-squeezy fashion!
Note 1: Oracle client is needed to access multiple data sources from Toad Data Point referred to as a ‘cross connection query’.
Note 2: This example will detail an Oracle 12c 64 bit install on Windows 10 for an Oracle 12c instance with a PDB.
Note 3: The Oracle 11g client install is almost exactly the same as the Oracle 12c client install.
here are 5 steps to this process which include:
1) Pick your Oracle client
2) Install the Oracle client
3) Disable sqlplus
4) Review registry entries
5) Configure Toad Data Point Oracle Connection
Recommendation is to review all steps before proceeding. In particular, Step 4 Review registry entries consisting of before and after screen shots. Trust me, you will feel better, empowered, and more confident in the end!
Step 1 – Pick your Oracle client
Your options within the scope of this article are an Oracle 11g or Oracle 12c client for 32 or 64 bit architecture. Consult the Oracle website for other client versions as needed.
Oracle 12c client (32 and 64 bit) can be found here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html
Oracle 11g 32 bit client can be found here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
Oracle 11g 64 bit client can be found here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
Pay Attention Note 1: Be careful which Oracle client you choose. If the intent is to use the Oracle client for other uses besides Toad Data Point, BE FOREWARNED some legacy systems will only work with a 32 bit Oracle client. Please understand your environment before choosing an Oracle client.
Toad Data Point will work seamlessly with either the 32 or 64 bit Oracle 11g or Oracle 12 client.
Step 2 – Install the Oracle client
Locate the downloaded Oracle 12c 64 bit client zip file.
Right click on file and extract into a directory.
Enter a directory to extract files.
Click Extract. Note: This could take a few minutes.
Working…
Oracle 12c 64 bit client has now been extracted
Double click ‘setup.exe’.
This may test your patience, let it work! (Sometimes a minute or less can seem like an eternity).
Don’t touch anything!
Pay Attention Note 2: Critical decision time now! The default is the ‘Instant Client’ which will allow for Oracle connections to one Oracle database at a time. If your users need the Toad Data Point ‘cross connection query’ feature (most will) DO NOT install the ‘Instant client’.
Pay Attention Note 3: Choosing the ‘Runtime’ option will eliminate any Oracle client Administrator tools enabling LOCKDOWN and saving 0.4 GB of local end user Windows PC disk space. Toad Data Point ‘cross connection query’ feature will still work. Stay with me and continue to follow the instructions.
Choose the ‘Runtime’ option.
Click Next.
Choose language.
Click Next.
Accept the defaults – my preference.
Or change to reflect your own environment.
Click Next.
Working…
Relax, the Prerequisite Check should complete successfully momentarily. If not, check the log files and correct as directed.
Accept the default Windows Built-in Account – my preference.
Click Next.
Verify Global Settings. No changes should be required at this point.
My preference is to not save the response file.
Option: Click ‘Save Response File’. A screen will appear to enter a filename to record the install responses. Use this option if you are having issues installing the Oracle Client. Response file log entries will help in debugging any issues that may occur. Rarely have I seen any issues during this part of the Oracle 11g/12c client install.
Click Install.
Be patient, the process is working.
Pay Attention Note 4: The default is ‘Public networks, such as those in airports and coffee shops …’. Depending on your local JAVA implementation, you may or may not get this message. If you do, it is HIGHLY RECOMMENDED to CHANGE the default to ‘Private networks, such as my home or work network’.
Click Allow Access.
Success!! Party time!
You have now just installed the Oracle 12c 64 bit client!
Click Close!
Step 3 – Disable sqlplus
The sqlplus.exe installed with the Oracle client opens the door for access to Oracle databases.
To reduce risk exposure delete or rename the sqlplus.exe file in the directory where the Oracle 12c client was installed.
This is the final LOCKDOWN step in this article.
Let’s review.
- The Oracle 12c client has been installed with the ‘Runtime’ option thus eliminating any Administrator tools.
- The sqlplus.exe file has been deleted or renamed from the client computer.
- The Oracle 12 client has now been installed lightweight and securely but still providing all the functionality required for connecting to Oracle databases.
- Toad Data Point users can now use the ‘cross connection query’ feature when connected to an Oracle database.
You have past the half way point, only 2 steps go!!!
Step 4 – Review registry entries
Start the Windows registry editor.
Purpose of reviewing registry entries is to understand the heart of where the Oracle client is setup for Windows. It is highly recommended not to change any registry entry values for the Oracle client.
BEFORE Oracle Client Install
HKEY_LOCAL_MACHINE --> SOFTWARE --> ODBC
BEFORE Oracle Client Install
HKEY_LOCAL_MACHINE --> SOFTWARE --> Oracle
This PC has an Oracle database instance running. This would be highly unusual for an end user. The KEY_OraDB12Home1 is the Oracle database home.
AFTER Oracle Client Install
HKEY_LOCAL_MACHINE -->SOFTWARE --> ODBC
AFTER Oracle Client Install
HKEY_LOCAL_MACHINE --> SOFTWARE --> Oracle
Step 5 – Configure Toad Data Point Oracle Connection
After installing the Oracle client, setting up a TNS entry is recommended. It’s easy – let me show you!
Ooooh, the magic TNS_ADMIN environment variable. Many people forget this step which can cause chaos and mayhem.
First, create the tnsnames.ora file which can be placed anywhere on a client Windows PC.
My preference is to place the file in the Oracle 12c client directory structure as shown below.
Create a file called tnsnames.ora with your specific database connection information similar to the examples below. There are many different and correct ways to specify a tnsnames.ora entry. Consult with your Oracle DBA for TNS entry information specific to your Oracle environment.
Oracle 12c with CDB/PDB configuration
PDB2 =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA=
(SERVER = dedicated)
(SERVICE_NAME = pdborcl)
)
)
Note: The CDB/PDB tnsnames entry will require an entry into the listener.ora file similar to this:
(SID_DESC =
(GLOBAL_DBNAME = pdborcl)
(SID_NAME = pdborcl)
)
Oracle 11g or Oracle 12c (No CDB/PDB) standalone database
DEV.ABC.NETWORK=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=server01.abc.network)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=dev)
)
)
Example of a tnsnames.ora file and location
C:Usersgrego>cd C:appclientgregoproduct.1.0client_1networkadminC:appclientgregoproduct.1.0client_1networkadmin>
C:appclientgregoproduct.1.0client_1networkadmin>type tnsnames.ora
PDB2 =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA=
(SERVER = dedicated)
(SERVICE_NAME = pdborcl)
)
)
C:appclientgregoproduct.1.0client_1networkadmin>
Now let’s go create the TNS_ADMIN environment variable!!
Click ‘Advanced system settings’.
Click ‘Environment Variables’.
In this case, the TNS_ADMIN environment variable does not exist in the list above. We need to create a TNS_ADMIN variable and point it to the tnsnames.ora file created earlier.
If the TNS_ADMIN environment variable already exists the PC has already been configured. Consult with a DBA before modifying to ensure other applications will not be affected.
My preference is to put this variable at the system level in the event another user account on this Windows PC requires access to Toad Data Point via the Oracle client.
Click ‘New’ in the ‘System variables’ box as shown above by red arrow.
Enter the Variable Name as TNS_ADMIN.
Enter the path to the tnsnames.ora file as
C:appclientgregoproduct.1.0client_1networkadmintnsnames.ora.
Click OK.
Awesome! TNS_ADMIN variable has been created!
Click OK and exit all the way out of ‘Advanced system settings’
Now all the effort will pay off!
Launch Toad Data Point and we will now create a Toad Data Point Oracle connection!!!
There are several ways to set up an Oracle connection. This is one of the most straight forward methods.
1-Click on the ‘Connection’ menu icon. A screen with many connection types will appear.
2-Choose ‘Oracle’ as indicated above.
From the dropdown list choose the entry of the database you want to connect to.
Choosing PDB2 in this example.
Enter User, for example hr.
Enter Password.
Click ‘Save Password’ box – my preference for simplicity but could be a security risk.
Click the Advanced tab – my preference but optional.
There is no requirement to specify a ‘Category’ of the connection. It is perfectly fine to ‘Click Connect’ from either the ‘Advanced’ or ‘Login’ tab.
Click on the ‘Category’ dropdown and choose appropriate environment. ‘Development’ – my preference.
Optionally – Click ‘Connect on Startup’, my preference is NOT to check this box. Unnecessary open connections consume valuable resources.
Click ‘Connect’.
You did it!!!
Congratulations on completing an Oracle 12c client install and setting up a Toad Data Point Oracle connection!
All done. Q.E.D.
Celebration time now!!!
TOAD World Maven
Gregory P. Martin
Summit Racing Equipment
Email Work: gmartin@summitracing.com
Email Home: gregory.x.martin@gmail.com
Most Fortune 500 companies choose Toad
Tool for Oracle Application Developers, more widely known as Toad®, was designed by Oracle developer, Jim McDaniel, to make his job easier. It was so helpful that Jim decided to share it. Fast forward to more than 20 years later, Toad is a trusted tool used in most Fortune 500 companies and across the globe.
There are many reasons why people buy Toad rather than staying with the “free” SQL Developer tool Oracle offers. One main reason developers and DBAs choose Toad for Oracle is to reduce time and effort to develop and manage Oracle databases. But did you know that with Toad for Oracle you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation? Did you know Toad can now find and control sensitive data across all your Oracle databases? What else can Toad do that you didn’t know about? Which edition will benefit you the most?
We’re so confident that you will love Toad, we’re offering our top 2 editions to you to try for free for 30 days.
In the following article, I am going to show you how to install the latest Oracle instant client 19.5 on Windows 10. As you know, Oracle Instant Client is a set of tools you need to connect and manage the Oracle database server. With this tool, we can connect to both local or remote Oracle database. Not like many other software, it needs extra steps in order to install the instant client. But don’t worry, we will cover it shortly.
Steps to Install Oracle Instant Client on Windows 10
Step 1. Install Microsoft Visual Studio 2017 Redistributable
The Oracle Instant Client 19.5 requires the installation of the Microsoft Visual Studio 2017 Redistributable. Make sure you have this software installed on Windows 10.
Step 2. Create a new directory for the instant client
Create a new folder under C:/ or any other folder. This new folder will be used to store the oracle instant client files. In this example, I will create a new folder called C:oracle
Step 3. Download the Oracle Instant Client
Now download the latest version of Oracle Instant Client. Choose the correct architecture that match your system. Or, if you are using Windows 10 64 bit, you can use the link below to directly download it. Choose one of these below
Basic Package
https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-basic-windows.x64-19.5.0.0.0dbru.zip
Basic Light Package
https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-basiclite-windows.x64-19.5.0.0.0dbru.zip
You will also need to download the Instant Client SDK Package below
https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-sdk-windows.x64-19.5.0.0.0dbru.zip
Save these two files inside the folder we created earlier.
Step 4. Extract the package
I assume you have two files below:
- instantclient-basic-windows.x64-19.5.0.0.0dbru.zip
- instantclient-sdk-windows.x64-19.5.0.0.0dbru.zip
First, extract the file instantclient-basic-windows.x64-19.5.0.0.0dbru.zip. It will produce a new subfolder called instantclient_19_5. Next, extract the file instantclient-sdk-windows.x64-19.5.0.0.0dbru.zip. The second file should be extracted into the instantclient_19_5 directory. Here are the folder content result
Step 5. Modify the Environment Variable
In this section, we are going to edit the Environment Variable. We will include the Oracle Instant Client path into the environment variable. To do this, follow these steps:
- Open Control Panel >> Settings
- Click Advanced System Settings
- On the Advanced tab, click Environment variables
- Under System Variables, create OCI_LIB64 if it does not exist. Set the value OCI_LIB64 to C:oracleinstantclient_19_5
- Under System Variables, edit PATH and include C:oracleinstantclient_19_5
2011-03-15 19:55:52
Oracle
Windows
Применимо для Windows XP x32 (Oracle Client Basic 10.2.0.4 + ODBC) и для Windows 7 x64 (Oracle Client Basic 11.1.0.6.0 x32).
В связи с участившимися вопросами «как ставить oracle client» опубликую что-то вроде инструкции из собственного опыта.
Первым делом нужно обзавестись самим клиентом, его можно скачать с сайта Oracle или еще где-то. Понадобится
- instantclient-basic-win32-XXXX.zip
- instantclient-odbc-win32-XXXX.zip (если требуется чтобы драйвер Oracle появился в Панель управления → Источники данных (ODBC))
Для работы PHP OCI8 и TOAD вполне будет достаточно только архива instantclient-basic. Приступим.
Распаковываем instantclient-basic-win32-10.2.0.4.zip в нужное место, в моем случае это C:Program FilesOracleinstantclient_10_2 (этот путь будет везде использоваться дальше по тексту, так что заменяйте на свой).
Под Windows 7 x64 клиент x32 работает вполне нормально и решает поставленные задачи, но никто не запрещает воспользоваться версией клиента x64.
Идем в Панель управления → Система → Дополнительно → Переменные среды. Там в разделе «Системные переменные» создаем следующие (имя переменной = значение)
LD_LIBRARY_PATH = C:Program FilesOracleinstantclient_10_2
NLS_LANG = RUSSIAN_CIS.CL8MSWIN1251
ORACLE_HOME = C:Program FilesOracleinstantclient_10_2
SQL_PATH = C:Program FilesOracleinstantclient_10_2
TNS_ADMIN = C:Program FilesOracleinstantclient_10_2networkADMIN
NLS_LANG может быть другой в зависимости от потребностей.
А к переменной PATH дописываем (не забываем про 
PATH += C:Program FilesOracleinstantclient_10_2
Теперь создаем папку C:Program FilesOracleinstantclient_10_2networkADMIN и в ней файл tnsnames.ora , в котором прописываем все SID к которым будем коннектиться.
Для работы клиента требуются DLL
Путем долгих мучений мной было выяснено, что для того чтобы клиент заработал в системе должны присутствовать следующие DLL библиотеки (которых обычно нет):
- bcrypt.dll
- ieshims.dll (в принципе работает и без нее на Win7)
- mfc71.dll
- msvcr71.dll
- ncrypt.dll
- wer.dll
Где их взять ответит гугль, скачиваем, распаковываем в C:WindowsSystem32 (можно ребутнуться для профилактики).
Если требуется работа приложений через ODBC драйвер
Распаковываем instantclient-odbc-win32-10.2.0.4.zip в нужное место, в моем случае это C:Program FilesOracleinstantclient_10_2 и запускаем оттуда odbc_install.exe
После всех этих операций у большинства все начинает работать, надеюсь и вам это поможет 
Если требуется работа x32 приложений через ODBC в Windows x64
Вот тут начинается самая хитрость, тк в панели управления в источниках данных ODBC нет драйвера Oracle! Поэтому нужно запустить управление ODBC x32, который, на удивление, расположен в C:WindowsSysWoW64 (см. KB 942976 от M$). Для этого нужно выполнить команду:
%systemdrive%WindowsSysWoW64Odbcad32.exe
И в открывшемся окне будет доступна возможность создать DSN с драйвером Oracle.
Back to Oracle
Oracle Client 12c Win 32-bit
Oracle Client 12c free download for 32 bit Windows systems.
Oracle
Gratuit
Windows
04-10-2017
Rate this program
- 1
- 2
- 3
- 4
- 5
4.4 out of 5 stars (198 Ratings)
Oracle Client 12c Win 32 bit
32-bit
12.2.0.1
English (US)
1,07 GB
2c396644d7b029967f74b95da5094493
Downloads
374430
Download
Available download for 64-bit
Oracle Client 12c Win 64 bit
Download
Secure and Fast Download — Software Verified