Note: Private Access Channel is now available in Oracle Analytics and is recommended by Oracle for new connections to private data sources. For more information on the feature and the data sources it supports refer to:
    Connect to Private Data Sources Through a Private Access Channel
    Supported Data Sources
    A-Team Chronicles Private Access Channel Series

Validated January 20, 2021 for OAC 5.9

Introduction

This post is a step-by-step guide describing the tasks to install Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG) silently on Linux without a GUI. 

This post is one of the scenarios noted in the companion blog Installing Oracle Analytics Cloud Remote Data Gateway

Validations

January 20, 2021 for OAC 5.9

October 12, 2020 with RDG 5.8

July 22, 2020 with RDG 5.7

May 20, 2020 with RDG 5.6

March 11, 2020 with RDG 5.5

Topics

Before You Begin

Installing Remote Data Gateway Silently

 Before You Begin

Common Prerequisites

Installing RDG requires the following common items:

Credentials and Privileges to install software on the RDG host.

The IP address or host name where RDG is to be installed.

An SSH client with a configuration file containing the RDG host and a bastion host if the RDG host is in a private subnet. Refer here for the steps to create the configuration file. Note: All SSH commands below use the configuration file and assume the RDG host entry is named RDG-HOST

 Preparing to Install Remote Data Gateway

Inventory Location File

Create a Local Inventory Location File

The first screen shown by the GUI installer asks for the Oracle Central Inventory location and the operating system group associated with the opc user. Create a local file named oraInst.loc using your local TextEdit / Notepad with the following lines:

inventory_loc=/home/opc/oraInventory
inst_group=opc

Upload the Local Inventory Location File

Upload the file above to the opc user's home directory.

scp oraInst.loc RDG-HOST:/home/opc

Backup the Server Inventory Location File

Using sudo backup the existing file (if there is one).

ssh RDG-HOST sudo cp /etc/oraInst.loc /etc/oraInst.loc.backup

Note: This command may fail because the file does not exist and this is OK.

Create the Server Inventory Location File

Using sudo copy the uploaded file to the server location

ssh RDG-HOST sudo cp oraInst.loc /etc/oraInst.loc

Validate the Server Inventory Location File

Verify the contents of the file

ssh RDG-HOST cat /etc/oraInst.loc

RDG Installer Zip File

It is assumed that the RDG installer zip file has been copied to the server. In this section, the latest compressed installer is uncompressed and required configuration files are created. If it hasn't you can use this command:

scp < Path to the Local RDG Installer Zip file > RDG-HOST:/home/opc

Uncompress the Installer

Unzip the Installer into the opc user's home directory.

ssh RDG-HOST unzip < path to the Server Installer zip file >

RDG Installer Response File

Create a Local Response File

Create a response file using TextEdit / Notepad with the following lines. This post uses the default value for the Oracle home directory and admin/Admin123 for the configuration page credentials.

[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]
ORACLE_HOME=/home/opc/Oracle/Middleware/Oracle_Home
SELECT_RD_VERSION_RADIO_V1=false
CREDENTIALS_PAGE_ADMIN_USERNAME=admin
CREDENTIALS_PAGE_PASSWORD=Admin123

Upload the Local Response File

Upload the file above to the opc user's home directory. The name of the file is not important. This post uses silentInstall.response

scp silentInstall.response RDG-HOST:/home/opc

Validate the Server Response File

Verify the contents of the response file

ssh RDG-HOST cat silentInstall.response

 Installing RDG on Linux Silently

Run the Installer

The following example command runs the installer silently with the locations and values previously used in this post.

ssh RDG-HOST yourInstaller.bin -silent -responseFile /home/opc/silentInstall.response -invPtrLoc /etc/oraInst.loc

The result looks like this:

 Starting Remote Data Gateway

Start RDG

RDG is installed but is not yet started. Use the following commands to start it.

ssh RDG-HOST yourRDG_HOME/domain/bin/startJetty.sh

Note: If using a SSH tunnel, use Control-C to exit the session otherwise use Enter.

Validating the Installation and Obtaining the Port and URL

Run the status command and make a note of the HTTP Port and the URL for use in configuring RDG

ssh RDG-HOST yourRDG_HOME/domain/bin/status.sh

The result looks like this: 

Installing Additional RDG Agents

Additional RDG installations in different availability domains are recommended for High-Availability (HA) requirements. However, to avoid conflicts only one agent should be enabled in OAC at any one time.

 Summary

This post described how to install Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG) silently and without a GUI.

RDG is now ready for configuration as described here.

For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley