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

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/oraclecle/product/release_number/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:$R_HOME/port/Linux-X64/lib

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

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

   Note:

   The rqcfg.sql script ships with Oracle Database 23ai and resides in the $ORACLE_HOME/R/server directory. The script installs the OML4R Server components in the database and you need to run it only once.

   The rqcfg.sql 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 = ORACLE_HOME path
   define rhome = R_HOME path

   Option 2: Run the rqcfg.sql script from the Linux command line.

   In the example, the user is system with the password apassword, the RQSYS schema is in SYSAUX and SYSAUX is assigned the temporary tablespace TEMP. The value for ORACLE_HOME is /u01/app/oracle/product/23c/dbhome_1 and the value for R_HOME is the Linux default path, /usr/lib64/R:

   $ sqlplus -L -S system/apassword @$ORACLE_HOME/R/server/rqcfg.sql SYSAUX TEMP /u01/app/oracle/product/23c/dbhome_1 /usr/lib64/R

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-version.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 ore-supporting-linux-x86-64-version.zip -d
        /home/oracle/OML4R/ore-supporting-linux-x86-64-version.zip

   Unzip the supporting packages on each node:

   $ dcli -t -g nodes -l oracle unzip
        /home/oracle/OML4R/ore-supporting-linux-x86-64-version.zip -d
        /my_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/

   Note:

   The rqcfg.sql script creates an OML4R user. By default, the script does not grant the RQADMIN role to the user.

   Any OML4R user can use an embedded R execution function, but only those with the RQADMIN role can create and drop the R scripts in the OML4R script repository in the database. Use caution when granting the RQADMIN role.

6. Verify the OML4R loads.

   $ ORE
   
   > library(ORE)
   Loading required package: OREbase
   Attaching package: OREbase
   The following objects are masked from âpackage:baseâ:
       cbind, data.frame, eval, interaction, order, paste, pmax, pmin,
       rbind, table
   Loading required package: OREembed
   Loading required package: OREstats
   Loading required package: MASS
   Loading required package: OREgraphics
   Loading required package: OREeda
   Loading required package: OREmodels
   Loading required package: OREdm
   Loading required package: lattice
   Loading required package: OREpredict
   Loading required package: ORExml