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
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
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
Before You Begin
Installing Remote Data Gateway Silently
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
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 file above to the opc user's home directory.
scp oraInst.loc RDG-HOST:/home/opc
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.
Using sudo copy the uploaded file to the server location
ssh RDG-HOST sudo cp oraInst.loc /etc/oraInst.loc
Verify the contents of the file
ssh RDG-HOST cat /etc/oraInst.loc
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
Unzip the Installer into the opc user's home directory.
ssh RDG-HOST unzip < path to the Server Installer zip 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 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
Verify the contents of the response file
ssh RDG-HOST cat silentInstall.response
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
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.
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:
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.
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
Previous Post