5.3 Install Oracle Machine Learning for R for Oracle RAC Without DCLI

How to install Oracle Machine Learning for R 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
  • Oracle Machine Learning for R Server
  • Oracle Machine Learning for R supporting packages

The below section contains installation instructions for Oracle AI Database 26ai.

Install Oracle Machine Learning for R in an Oracle 23ai RAC Environment

Following these step to install Oracle R Distribution, Oracle Machine Learning for R, and the Oracle Machine Learning for R supporting packages.

  1. Install Oracle R Distribution. See Install R for Oracle Machine Learning for R on On-Premises Oracle AI Database.
  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/23.4.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 run permission to all users to the ORE directory.
    cd  $ORACLE_HOME/bin
    chmod 755 ORE
  4. Create a directory to contain the Oracle Machine Learning for R 2.0 supporting packages for your system and change directories to it. To that directory, download the supporting package zip file as described in Install the Oracle Machine Learning for R 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