Oracle 19c Windows 32-bit Client Installation
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 These are Done
1. Set windows system to show file extensions:
Windows-Key 🠊 File Explorer 🠊 View 🠊 [x] File name extensions
2. Unset environment vars.
Run: env ORACLE_HOME TNS_ADMIN Older Windows Right-Click Start -> System -> Advanced system settings
Procedure
1. As Administrator run C:\sw\NT_193000_client\client32\setup.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:\app\client\oracle
Software location: C:\app\client\oracle\product\19.0.0\client_32
5. Summary: Select [Install]
Process runs...
Press [Close] when completed.
The above adds this entry to the PATH env var: C:\app\client\oracle\product\19.0.0\client_32\bin;
Validate Driver Installed
1. Run 32-bit Microsoft ODBC Administrator.
Ex: C:\Windows\SysWOW64\odbcad32.exe
2. Select Drivers tab.
3. Scroll down, you should now see an entry for: Oracle in OraClient19Home1_32bit
TNS Administration
1. Determine\Set 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:\app\client\oracle\product\19.0.0\client_32\network\admin
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:\Windows\SysWOW64\odbcad32.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:\app\client\oracle ORACLE_HOME: C:\app\client\oracle\product\19.0.0\client_32 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\KEY_OraClient19Home1_32bit