oracledba.help
Install

Oracle 19c Windows 64-bit Client Installation

<- Install

Overview

What follows is the most common way to install the Oracle 19 Windows 64-bit client.

Prerequisites

Download Microsoft Windows x64 (64-bit) to your software dir (Ex: C:\sw).  
Click the See All link then scroll down to find: Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit) Download this 🠊 WINDOWS.X64_193000_client.zip
Not this 🠊 WINDOWS.X64_193000_client_home.zip • Unzip C:\sw\WINDOWS.X64_193000_client.zip. It will create dir: C:\sw\WINDOWS.X64_193000_client\client • Set windows system to show file extensions: Windows-Key 🠊 File Explorer 🠊 View 🠊 [x] File name extensions

If when unzippinig you get filename too long errors you can rename zip file ic.zip then try again.

Ensure This is Done

Set windows system to show file extensions:
Windows-Key 🠊 File Explorer 🠊 View 🠊 [x] File name extensions

Procedure

  1. Run C:\sw\WINDOWS.X64_193000_client\client\setup.exe As Administrator.
     Installer loads...

  2. Installation Type: (x) Administrator

  3. Oracle Home User Selection: (x) Use Windows Built-in Account

  4. Installation Location:
     Oracle base:       C:\app\oracle\client
     Software location: C:\app\oracle\client\product\19.0.0\client_1

  5. Summary: Select [Install]
     Process runs... 

     Press [Close] when completed.	 
  • The installer adds this entry to the PATH environment var:
    • C:\app\oracle\client\product\19.0.0\client_1\bin;
  • Main registry additions:
    • HKEY_CURRENT_USER\Software\Oracle
    • HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\<OracleDrivers>
    • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

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\oracle\client\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!

Environment Variables

Recommended

 ORACLE_BASE: C:\app\oracle
 ORACLE_HOME: C:\app\oracle\client\product\19.0.0\client_1

If Your Environment Requires

 ORACLE_SID: <YourOraSid>
 TNS_ADMIN: C:\app\oracle\client\product\19.0.0\client_1\network\admin

Press Windows-Key then type env for option to edit environment vars.

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 MYDB1

SQLPlus

Create Windows Shortcut

%ORACLE_HOME%\BIN\sqlplus.exe <Username>/<Password>@<tnsnames.ora Svc>

 %ORACLE_HOME%\BIN\sqlplus.exe scott/tiger@MYDB1

Set Global Profile

Add below values to: %ORACLE_HOME%\sqlplus\admin\glogin.sql

 SET LINESIZE 240
 SET PAGESIZE 9999
 SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER> "

These are the minimal recommended changes.


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)
    )
  )

Uninstall Oracle Client Software

Prerequisites

  • Ensure no 64-bit Oracle software is running on this machine and have no other apps needing 64-bit Oracle access.

Procedure

1. Find the universal installer and UNINSTALL the client
   a. Win-Key "universal Installer" run: Universal Installer.
   b. Press [Deinstatll Products].
   c. Select: [x] OraClient19Home1
   d.  Press [Remove].

   Command will be provided to uninstall for this system.
   Example: cd C:\sw\WINDOWS.X64_193000_client_home\deinstall
            Run: deinstall.bat
		 Do you want to continue: y

   In 19c the relevant registry entries will be removed by this process.

2. Clean Environment Vars
   - rundll32.exe sysdm.cpl,EditEnvironmentVariables
   - If exist, remove: ORACLE_HOME, ORACLE_SID, TNS_ADMIN
   - From PATH remove any Oracle entries.

   Run "set" from console to confirm env clean.

3. Remove directory
   Delete dir: C:\app\client (or corresponding client parent dir)

Completely Uninstalling Manually

Exercise extreme care when removing registry entries. Removing incorrect entries can severely impact your computer.

Prerequisites

  • Ensure you are logged in as a user with Administrator privileges.
  • Make sure you have complete backups of your system before you make any changes.
 1. Windows registry.
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    - Delete the home (ex: KEY_OraClient19Home1).
    - Delete the key inst_loc.
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
    Expand all subkeys and remove all keys related with the "Oracle ODBC Driver".
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
    Remove all keys under here that begin with ORACLE or ORAWEB. 
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\...\Application
    Remove all keys under here that begin with ORACLE.
    HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\...\Uninstall
    Remove any entries related to Oracle.
    HKEY_CLASSES_ROOT
    Remove all keys that begin with Ora or ORCL
    (e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).
    HKEY_LOCAL_MACHINE\SOFTWARE\Classes
    Remove all keys that begin with Ora or ORCL
    (e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).    
    HKEY_CURRENT_USER\Software\Oracle
    Delete this ORACLE key.
    HKEY_USERS\…\Software\Oracle
    Delete this ORACLE key.

 2. Environment
    a. PATH = Remove any path to Oracle client.
    b. Remove ORACLE_SID, ORACLE_BASE, ORACLE_HOME and TNS_ADMIN.

 3. Directories and Files
    • Remove "Oracle" Items.
    • Though some might be hidden, in placing the path in File Explorer they should open.
    C:\Program Files\Oracle
    C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle - OraClient19Home1
    C:\Users\<UserName>\AppData\Roaming\Microsoft\Windows\Start Menu
    C:\Users\<UserName>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs
    %SystemDrive%\Temp
    %SystemDrive%\Documents and Settings\<username>\Local Settings\Temp
 4. Misc
    Go to the drive where the Oracle software is installed on your machine
    and delete all ORACLE_BASE directories on your hard drive.

These steps have been derived from Doc ID 124353.1.

Installing 32-bit Client with 64-bit

 1. Install this 64-bit client first.
 2. Oracle 32-bit Client Install changes:
    a. If set, unset all Oracle environment vars: ORACLE_BASE, ORACLE_HOME.
    b. Run setup.exe passing: ORACLE_HOME_NAME=client_32
       C:\sw\NT_193000_client\client32\setup.exe ORACLE_HOME_NAME=client_32
       Takes a few minutes to load.  We wait...
    c. Software location changes:
       Oracle base:       C:\app\client\oracle32
       Software location: C:\app\client\oracle32\product\19.0.0\client_32
 3. Create a TNS_ADMIN System environment var. Set it to the 64-bit home network path:
    C:\app\oracle\client\product\19.0.0\client_1\network\admin
 4. Create a TNS_ADMIN\tnsnames.ora entry(s) as needed.
 5. Create and test sqlplus shortcuts for both.
    64: C:\app\client\oracle\product\19.0.0\client_1\bin\sqlplus.exe scott\tiger@MYSVC
    32: C:\app\client\oracle32\product\19.0.0\client_32\bin\sqlplus.exe scott\tiger@MYSVC
 6. Create and test ODBC connections for both. 
    64 ODBC Mgr: C:\Windows\System32\odbcad32.exe
    32 ODBC Mgr: C:\Windows\SysWOW64\odbcad32.exe

Notes:

  • Yes crazily the 64-bit ODBC Mgr is in a directory showing 32 and vice-verse.
  • Both ODBC managers see the name of the all 32 and 64 bit DSN names. So you may want to give 32-bit entries a _32 extension.
  • The 32 bit would not recognize the TNS_ADMIN env var so I simply copied the tnsnames.ora to both net paths. I bet there is a registry entry that will resolve this though.

References:

  • Considerations Using The Oracle Client With Microsoft Products on 64 bit Windows Operating System (Doc ID 781432.1).
  • Cannot Install Oracle Client 11.2 64 Bit And Oracle Client 32 Bit On Same Windows 64 Bit Server (Doc ID 1530206.1).
  • WINDOWS: Install Oracle Client 11.2 32-bit and 64-bit on Same System Overwrites Programs Menu Entry (Doc ID 1243374.1).