Oracle 19c Client Quick install Guide for Linux

Products

• Data Loss Prevention
• Data Loss Prevention API Detection for Developer Apps Virtual Appliance
• Data Loss Prevention API Detection Virtual Appliance
• Data Loss Prevention Cloud Detection Service
• Data Loss Prevention Cloud Detection Service for ICAP
• Data Loss Prevention Cloud Detection Service for REST
• Data Loss Prevention Cloud Package
• Data Loss Prevention Cloud Prevent for Microsoft Office 365
• Data Loss Prevention Cloud Service for Discovery/Connector
• Data Loss Prevention Cloud Service for Email
• Data Loss Prevention Cloud Storage
• Data Loss Prevention Core Package
• Data Loss Prevention Data Access Governance
• Data Loss Prevention Discover Suite
• Data Loss Prevention Endpoint Discover
• Data Loss Prevention Endpoint Prevent
• Data Loss Prevention Endpoint Suite
• Data Loss Prevention Enforce
• Data Loss Prevention Enterprise Suite
• Data Loss Prevention for Mobile
• Data Loss Prevention for Office 365 Email and Gmail with Email Safeguard
• Data Loss Prevention Form Recognition
• Data Loss Prevention Network Discover
• Data Loss Prevention Network Email
• Data Loss Prevention Network Monitor
• Data Loss Prevention Network Monitor and Prevent for Email
• Data Loss Prevention Network Monitor and Prevent for Email and Web
• Data Loss Prevention Network Monitor and Prevent for Web
• Data Loss Prevention Network Prevent for Email
• Data Loss Prevention Network Prevent for Email Virtual Appliance
• Data Loss Prevention Network Prevent for Web Virtual Appliance
• Data Loss Prevention Network Protect
• Data Loss Prevention Network Web
• Data Loss Prevention Oracle Standard Edition 2
• Data Loss Prevention Plus Suite
• Data Loss Prevention Sensitive Image Recognition
• Data Loss Protection Oracle Standard Edition

Issue/Introduction

Installing the Oracle 19c Client on the Enforce Server
- This is a required pre-requisite for installing or upgrading the Enforce Server.

Environment

Linux

Cause

The Oracle Client is a pre-requisite for installing or upgrading the Enforce Server

Resolution

VERSION DISCLAIMER: Please note that the following instructions are version agnostic, and can generally be used on any currently supported version. As such, you will find several variables denoted such as "<DLPversion>" to indicate where a version number "should" be used. You will need to replace these variables with the appropriate version that you are attempting to use. Below are a few examples of such translations... <DLPversion>  = 15.8 or 16.0 or 16.0.1 <DLPfullversion>  = 16.0.10000.60631 <ORACLEversion>  = 193000 or 19.3.0.0 <JREversion> = jdk8u322-b06 or 8u322b06

 

Download the Oracle 19c Client Installer: https://support.broadcom.com/group/ecx/downloads
Oracle 19c Client Installer Filename: LINUX.X64_<ORACLEversion>_client.zip
     ** The Oracle Client MUST be installed on the Enforce Server, if the Oracle Database is not installed locally on the Enforce Server.

Preparing to run the Oracle 19c Installer
1. Install the Oracle Dependencies
     https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/supported-red-hat-enterprise-linux-7-distributions-for-x86-64.html#GUID-2E11B561-6587-4789-A583-2E33D705E498
     yum install -y bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make smartmontools sysstat
   

2. Create the "oracle" user
     adduser oracle
     
     **Note: In order for the Environment Variables to work for Oracle, you must also configure them under the Oracle user.
          Create the Environment Variables:
           Environment Variables Quick Install Guide for Linux

3. Check your oracle ID's
     id oracle
     
     ** Note the UID, GID, and GROUPS are all showing "oracle" as their identifier
     ** this will be used later for the "UNIX_GROUP_NAME"
4. Create the following two directories
     mkdir -p /opt/oracle/oraInventory
     mkdir -p /opt/oracle/product/<ORACLEversion>/client_1
5. Change the owner of these new directories to "oracle"
     chown -R oracle. /opt/oracle
6. Change directory to your DLPInstallers location
     cd /DLPInstallers/<DLPversion>
7. Extract the Oracle Client files to your Installer location
     unzip LINUX.X64_<ORACLEversion>_client.zip -d /DLPInstallers/<DLPversion>/oracle
     
8. Change the owner of the "oracle/client" directory to "oracle"
     chown -R oracle. oracle/client
9. Modify the "client_install.rsp" file
     Path: /DLPInstallers/<DLPversion>/oracle/client/response
     Filename: client_install.rsp
     nano /DLPInstallers/<DLPversion>/oracle/client/response/client_install.rsp
          UNIX_GROUP_NAME: oracle
          INVENTORY_LOCATION: /opt/oracle/oraInventory
          ORACLE_HOME: /opt/oracle/product/<ORACLEversion>/client_1
          ORACLE_BASE: /opt/oracle
          INSTALL_TYPE: Administrator

Run the Oracle Client Installer
1. Switch to the 'oracle' user
     su oracle
2. Change directory to the "client" directory
     cd /DLPInstallers/<DLPversion>/oracle/client
3. Run the runInstaller
     ./runInstaller -silent -responseFile /DLPInstallers/<DLPversion>/oracle/client/response/client_install.rsp
4. After seeing the success message, hit "Enter" to get back to the command prompt
     
5. Copy the 'tnsnames.ora' file from your Oracle Server to the Enforce Server
     Oracle: C:\Oracle\Product\<ORACLEversion>\db_1\network\admin
     Enforce: /opt/oracle/product/<ORACLEversion>/client_1/network/admin
6. Run TNSPING to confirm the tnsnames.ora file is working
     tnsping protect
     
7. Log into SQL as the protect user and run the following command to confirm we can connect to the database and pull data.
     sqlplus protect@protect
     select * from v$version;