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
March 11, 2020 with RDG 5.5
Oracle Analytics Cloud Remote Data Gateway version 105.5x
MacBook Pro OS 10.13.6
Before You Begin
Installing Remote Data Gateway Silently
Ensure your operating system is supported by viewing the list at OAC Downloads.
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 steps for a GUI installation are documented in Install Data Gateway. You might refer to it for insight on the different parameters used.
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:
Upload the file above to the opc user's home directory.
scp < Path to local file > 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
Using sudo copy the uploaded file to the server location
ssh RDG-Host sudo cp < uploaded file name > /etc/oraInst.loc
Verify the contents of the file
ssh RDG-Host sudo 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.
#DO NOT CHANGE THIS.
Response File Version=220.127.116.11.0
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 < Path to local file > RDG-Host:/home/opc/silentInstall.response
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 ./datagateway-linux-105.5.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 Oracle/Middleware/Silent_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 Oracle/Middleware/Silent_Home/domain/bin/status.sh
The result looks like this:
Additional RDG installations in different availability domains are recommended for High-Availability (HA) requirements.
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