To administer your Oracle Database remotely, you will need to connect to the database instance, especially from an SQL*Plus terminal. To be able to do that, you may install the Oracle Database Client and configure it correctly.
The Oracle Client is a software suite allowing you to administer your database remotely, perform basic network configurations, write PL/SQL applications, connect your database to Java, Python type applications, etc.
This guide provides instructions about installing and configuring Oracle Database Client on Windows. The installation process is identical on Linux.
Oracle Database Client requirements
You can easily install the Oracle Client on a 64-bit Windows PC with a modern processor (AMD or Intel), 2GB of RAM and 2GB of free disk space. Oracle Database Client for Windows x64 is supported on the major x64 distributions (Windows 7, Windows 8, Windows 10, Windows Server 2012 and Windows Server 2016). We recommend you update Windows before starting the client installation.
You also need to connect the client machine to a network and ensure it is able to communicate with the database server. In some cases, you may add exceptions to your firewall on the server side to allow network traffic between the server and the client.
Moreover, we will make sure that the database server is running correctly and is able to serve remote connections. Apart from network connectivity, a listener must be configured on the database server.
Oracle also recommends creating a standard non-administrative user account on the client machine to run the Windows services for the Oracle home. In this tutorial, we’ll call this user Client.
Oracle Database Client Download
You can download the Oracle Database Client for Windows for free from Oracle’s Technology Network website. We will focus here on version 19c. Oracle recommends using an Oracle Client version that matches the highest Oracle database version that you need to connect to. Using older clients to connect to newer database versions can cause issues.
The Oracle Client is available in 32-bit and 64-bit versions. The choice of which version to install depends on the architecture of your OS.
Downloading the Oracle Client requires an Oracle account. This account will allow you to download other Oracle products and access Oracle Cloud services.
Once you have created your account, select the right version for your needs and accept the Oracle License Agreement to start the download.
Install Oracle Database Client on Windows step by step
After checking the hardware and software prerequisites and downloading the Oracle Database Client software, you can install it by following the simple steps below. Note that the installation process is almost similar for versions 12c, 18c and 19c of Oracle Database Client. So, let’s get started.
1. Navigate to the installation folder and launch the setup file
After downloading the Oracle Client, you can unzip it to a directory of your choice, then run the setup.exe file.
In this step, enter the Oracle Home user credentials (user name and password) you create earlier. You can also create a new account or use a built-in Windows account (for example, the one you use to launch setup.exe).
In this step, you can provide the Oracle base directory which contains the Oracle Client software and related configuration files, then click “Next” to perform prerequisite checks.
After the prerequisite checks, you should have a summary of your installation configuration. If there is no error, then click on “Install” to install the product. Otherwise, go back to section 1 to audit your environment.
In the next section, we will configure the Oracle Client to connect with the Oracle Database server.
Configuring and testing Oracle Database Client
After installing the Oracle Client, you can use it to access and administer your Oracle database remotely but you will need to configure it first. This configuration can be done with tools available immediately after the client installation. We’ll use Oracle Network Manager to create a database service linked to the remote Oracle Database instance.
1. Launch Oracle Net Manager from Windows Start menu
2. Add a new database service
Select “Service Naming” and click on the “+” button.
In this step, provide the Oracle Database hostname or IP address and a port number to access the database instance. The port number must be the same as the one configured in the listener at the server side.5. Specify database instance name
Enter the global database name of the remote database (eg. db.ept.sn) and optionally the connection mode. The database name might be ORCL if the database server is installed with default configurations.
Before finishing the service name configuration, you can run a test to check if you can access the remote database with the parameters you provided. The wizard will try to connect to the server with a default user account, namely Scott.
7. Save the network configuration
Connecting to the remote database using SQL*Plus
You can now access your Oracle Database server from the Client using tools like SQL*Plus or Oracle SQL Developer. For example, you can open a command prompt and connect to the Oracle Database instance with the following command:
Still having questions on how to install the Oracle Client? Leave a comment below!
You might also like: Oracle Database Network configuration