X

Best Practices from Oracle Development's A‑Team

Installing Oracle Analytics Cloud Remote Data Gateway Silently

Validated March 11, 2020 with RDG 5.5

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. 

The official documentation is  Connect to On-premises Data Sources and Known Issues.

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

Validations

March 11, 2020 with RDG 5.5

Versions

Oracle Analytics Cloud Remote Data Gateway version 105.5x

MacBook Pro OS 10.13.6 

Linux 7.7 

Topics

Before You Begin

Installing Remote Data Gateway Silently

 Before You Begin

Reviewing Supported Operating Systems

Ensure your operating system is supported by viewing the list at OAC Downloads.

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

The steps for a GUI installation are documented in Install Data Gateway. You might refer to it for insight on the different parameters used.

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 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.

scpPath to local file > 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

Create the Server Inventory Location File

Using sudo copy the uploaded file to the server location

ssh RDG-Host sudo cp uploaded file name > /etc/oraInst.loc

Validate the Server Inventory Location File

Verify the contents of the file

ssh RDG-Host sudo 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

scpPath to local file > RDG-Host:/home/opc/silentInstall.response

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 ./datagateway-linux-105.5.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 Oracle/Middleware/Silent_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 Oracle/Middleware/Silent_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.

 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

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha