Oracle 19c Windows 64-bit Client Installation
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 • Unset the ORACLE_HOME if install prompts with a conflict then restart install.
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\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 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\client\oracle ORACLE_HOME: C:\app\client\oracle\product\19.0.0\client_1
If Your Environment Requires
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:\app\client\oracle\product\19.0.0\client_1\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).