Install Oracle Machine Learning for R for Oracle RAC Without DCLI

How to install OML4R for an Oracle Real Application Clusters (Oracle RAC) database if DCLI is unavailable.

If the Distributed Command Line Interface (DCLI) is not available, you must install each of the following components individually on each database instance in the Oracle RAC cluster.

  • R or Oracle R Distribution
  • OML4R Server
  • OML4R supporting packages

The first section contains installation instructions for Oracle Database 18c and later. The second section has instructions for Oracle Database 12c and earlier.

Install OML4R in an Oracle 18c and Later RAC Environment

Following these step to install Oracle R Distribution, OML4R, and the OML4R supporting packages.

  1. Install Oracle R Distribution. See Install R for Oracle Machine Learning for R.
  2. Start SQL*Plus, log in to your PDB directly and run the rqcfg.sql script. The following example uses the PDB PDB1 and gives example values for the script arguments.
    SQL> sqlplus / as sysdba
    SQL> alter session set container=PDB1;
    SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
    SQL> @$ORACLE_HOME/R/server/rqcfg.sql
    
    define permtbl = SYSAUX
    define temptbl = TEMP
    define orahome = /u01/app/oracle/product/18.0.0.0/dbhome_1
    define rhome = /usr/lib64/R
  3. At your operating system prompt, go to the ORACLE_HOME/bin directory and grant read and execute permission to all users to the ORE directory.
    cd  $ORACLE_HOME/bin
    chmod 755 ORE
  4. Create a directory to contain the OML4R 1.5.1 supporting packages for your system and change directories to it. To that directory, download the supporting package zip file as described in Install the OML4R Supporting Packages.
  5. Extract the supporting packages.
  6. For each package, at your operating system command prompt, run the following command.
    ORE CMD INSTALL package

Install OML4R in an Oracle 12c and Earlier RAC Environment

Following these step to install Oracle R Distribution, OML4R, and the OML4R supporting packages.

Note:

You can perform steps 2 and 3 simultaneously by first extracting the OML4R supporting packages bundle in the same directory from which you execute the server.sh script. (For Microsoft Windows, the script is server.bat.)
  1. Install Oracle R Distribution. See Install R for Oracle Machine Learning for R.
  2. Execute the server.sh script from the OML4R Server installer bundle. See Install Oracle Machine Learning for R Server
  3. Install the OML4R supporting packages. See Install Oracle Machine Learning for R Server for Oracle Database 12c and Earlier

When you execute the server.sh script on node 1, it installs the OML4R packages on the operation system in the $ORACLE_HOME/R/library directory. It also installs and configures the database components of OML4R. While running the script, you can create a new database user when prompted to do so. You can create a user while running the script only during the execution of the server.sh script on the first node.

When you execute the server.sh script on each subsequent node, the script only installs the OML4R packages on the operation system.