5.2.2 Install OML4R Server Across Exadata Compute Nodes Using DCLI for 19c

How to use DCLI to install OML4R Server across multiple Exadata Linux compute nodes for Oracle Database 19c.

To install OML4R Server on Exadata using DCLI for Oracle Database 19c, follow these steps:

1. Get a list of the compute nodes in the rack.

   In the following example, the cat nodes command lists the nodes for a two-node cluster.

   $ cat nodes
   exadb01
   exadb02

2. In a text editor, create a file that contains the names of all of the compute nodes in the rack. Specify each node name on a separate line. For example, the nodes file for a two-node cluster would contain entries such as the following:

   exadb01
   exadb02

3. Ensure that the ORACLE_HOME, ORACLE_SID, R_HOME, PATH, and LD_LIBRARY_PATH environment variables are properly set on each node, and are defined in the same shell in which you will run the DCLI script. For example, you could specify values like the following in a bashrc file:

   export ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1
   export ORACLE_SID=ORCL
   export R_HOME=/usr/lib64/R
   export PATH=$PATH:$R_HOME/bin:$ORACLE_HOME/bin
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$RHOME_lib

4. Option 1: On the first database node only, run as sysdba the server.sh script from your PDB.

   $ sqlplus / as sysdba;
   SQL> alter session set container=ORCLPDB;
   SQL> @server/rqcfg.sql

   Note:

   This script installs the OML4R Server components in the database and you need to run it only once.

   The server.sh script prompts you for the following input parameters:

   define permtbl = permanent tablespace name for RQSYS schema
   define temptbl = temporary tablespace name for RQSYS schema
   define orahome = hard-coded ORACLE_HOME path
   define rhome = hard-coded R_HOME path

5. Download and install the OML4R supporting packages.

   To download ths supporting packages, go to the Oracle Machine Learning for R Downloads website. Select Supporting in the column for your version of the database, accept the license agreement, and download the ore-supporting-linux-x86-64-2.0.zip file.

   Log in as root and copy the installers for the supporting packages across the nodes. For example:

   $ dcli -g nodes -l oracle mkdir -p /home/oracle/OML4R
   
   $ dcli -g nodes -l oracle -f oml4r-supporting-linux-x86-64-2.0.zip -d
        /home/oracle/OML4R/oml4r-supporting-linux-x86-64-2.0.zip

   Unzip the supporting packages on each node:

   $ dcli -t -g nodes -l oracle unzip
        /home/oracle/OML4R/oml4r-supporting-linux-x86-64-2.0.zip -d
        /destination_directory/

   Install the OML4R supporting packages, as in the following example:

   $ dcli -t -g nodes -l oracle R CMD INSTALL /my_destination_directory/supporting/* -l $ORACLE_HOME/R/library/