oracledba.help

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

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:\sw\WINDOWS.X64_193000_client\client\setup.exe.
     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\client\oracle
     Software location: C:\app\client\oracle\product\19.0.0\client_1

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

     Press [Close] when completed.	 
  • PATH environment addition:
    • C:\app\client\oracle\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\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!

Environment Variables

Recommended

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

As Required

 ORACLE_SID: <YourOraSid>
 TNS_ADMIN: C:\app\client\oracle\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 correpsonding 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.