Skip to content

How to Install Oracle Client on Windows

Oracle client 19c is an application which has full ability to connect to Oracle database server, but it requires to be installed and registered with Windows platform. That's the biggest difference from Oracle instant client.

Here are steps to install Oracle client.

1. Unzip Oracle Client 19c

Here we use WINDOWS.X64_193000_client.zip from Oracle Database 19c Download for Microsoft Windows x64 (64-bit).

Please note that, the web page contains not only client packages, but also a lot of database server ones. You need to find the right one by pressing Ctrl + f and searching "client" keyword on the page.

Once you have downloaded the right one, you should unzip the package like this:

Oracle Client 19c Unzipped

Oracle Client 19c Unzipped

2. Initiate Installation

Double Click on setup.exec to initiate Oracle Client 19c Installation

Double Click on setup.exec to initiate Oracle Client 19c Installation

3. Select Administrator Type

To get the full power of Oracle client, we choose Administrator Type.

Oracle Client 19c Installation - Step 1 - Select Installation Type

Oracle Client 19c Installation - Step 1 - Select Installation Type

4. Create Oracle Home Owner

We choose to create a new Windows user oracle to be the owner of Oracle software.

Oracle Client 19c Installation - Step 2 - Oracle Home User Selection

Oracle Client 19c Installation - Step 2 - Oracle Home User Selection

5. Select Oracle Home

We should find a proper directory to store Oracle software. In this case, we use the default.

Oracle Client 19c Installation - Step 3 - Specify Installation Location

Oracle Client 19c Installation - Step 3 - Specify Installation Location

6. Pass Prerequisite Check and Summary

As you can see, we passed the prerequisite checks and it summarize some information for us.

Oracle Client 19c Installation - Step 5 - Summary

Oracle Client 19c Installation - Step 5 - Summary

7. Save Response File

It's a good habit to save response file.

Oracle Client 19c Installation - Step 5 - Save Response File

Oracle Client 19c Installation - Step 5 - Save Response File

8. Install the Product

If there's nothing wrong, we can safely install the product.

Oracle Client 19c Installation - Step 6 - Install Product

Oracle Client 19c Installation - Step 6 - Install Product

9. Installation Finished

The installation is successful.

Oracle Client 19c Installation - Step 7 - Finish

Oracle Client 19c Installation - Step 7 - Finish

10. Allow the App to Access Network

To access the network, we should put Oracle client in the white list of Windows firewall.

Windows Security Alert on Oracle Client 19c APP

Windows Security Alert on Oracle Client 19c APP

To have a faster way to install Oracle client, please check: How to Install Oracle Client Home on Windows.

8 thoughts on “How to Install Oracle Client on Windows”

  1. What is the significance of creating the new Windows user “oracle” in step 2 of 7 above? E.g. does this create a new local Windows account called oracle which is assigned ownership of all the installed files? Would one then login to this account to manage this client ORACLE_HOME and if so how does that occur since the password is not specified anywhere?

    What is the best approach to install an Oracle client on Windows which can then be managed by anyone in a team of administrators? Currently we are in a situation where, an Oracle client installed by someone cannot then be modified by another administrator of that same Windows computer; other users cannot even run the oui from that ORACLE_HOME.

    1. Sorry, I see the password is specified at that step.

      So are subsequent modifications to this ORACLE_HOME managed by logging in to this (local) account and running the installer from that session? Is this the recommended approach to managing an ORACLE_HOME on Windows by a team of administrators?

    2. Thanks. In that case, what would you recommend to do when an Oracle Client installation in Windows has to be managed by a team of Oracle administrators, who all have their individual logins?

      1. Of course, here I quote a paragraph from the documentation.

        Oracle recommends that you use Virtual Account or a standard Windows User Account (instead of Windows Built-in Account) as the Oracle Home User for enhanced security.

        Which means, use a separate account instead of a built-in is recommended.

    3. Thank-you. We had the Windows admin create a local account (with admin privileges) to be shared by the team. We login to Windows with this account to install Oracle Runtime Client (with option “Use Built-in Windows Account” ticked).

Leave a Reply

Your email address will not be published.