oracledba.help

Oracle 19c Windows 32-bit Client Installation

<- 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.
 • Set windows system to show file extensions: 
   Explorer -> View -> [x] File name extensions

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_1

  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_1\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_1\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_1 

 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI
 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Oracle\KEY_OraClient19Home1_32bit

Related Resources

Oracle ODBC Driver Release Notes