5 Installing Oracle R Enterprise on Exadata

This chapter explains how to install Oracle R Distribution and Oracle R Enterprise Server on Oracle Exadata Database Machine. This chapter includes these topics:

5.1 About Oracle R Enterprise on Exadata

Exadata is an ideal platform for Oracle R Enterprise. The parallel resources of R computations in Oracle R Enterprise take advantage of the massively parallel grid infrastructure of Exadata.

To install Oracle R Enterprise on Exadata: 

  1. On each node:

  2. On the first node only, create a user, as described in Section 7.5.

You can simplify the process of installing Oracle R Enterprise on Exadata by using the Distributed Command Line Interface (DCLI) as described in the following topics.

5.2 Using DCLI to Install Oracle R Enterprise on Exadata

You can use DCLI to simplify the installation of Oracle R Enterprise on Exadata. With DCLI, you can use a single command to install Oracle R Distribution and Oracle R Enterprise Server across multiple Exadata compute nodes.

Example 5-1 shows the output of the DCLI help option, which explains the basic syntax of the utility.

Example 5-1 DCLI Help Option Output

$ dcli -h
 
Distributed Shell for Oracle Storage
 
This script executes commands on multiple cells in parallel threads.
The cells are referenced by their domain name or ip address.
Local files can be copied to cells and executed on cells.
This tool does not support interactive sessions with host applications.
Use of this tool assumes ssh is running on local host and cells.
The -k option should be used initially to perform key exchange with
cells.  User may be prompted to acknowledge cell authenticity, and
may be prompted for the remote user password.  This -k step is serialized
to prevent overlayed prompts.  After -k option is used once, then
subsequent commands to the same cells do not require -k and will not require
passwords for that user from the host.
Command output (stdout and stderr) is collected and displayed after the
copy and command execution has finished on all cells.
Options allow this command output to be abbreviated.

Return values:
 0 -- file or command was copied and executed successfully on all cells
 1 -- one or more cells could not be reached or remote execution returned
      non-zero status.
 2 -- An error prevented any command execution

Examples:
 dcli -g mycells -k
 dcli -c stsd2s2,stsd2s3 vmstat
 dcli -g mycells cellcli -e alter iormplan active
 dcli -g mycells -x reConfig.scl
 
usage: dcli [options] [command]

options:
 --version           show program's version number and exit
 -c CELLS            comma-separated list of cells
 -d DESTFILE         destination directory or file
 -f FILE             file to be copied
 -g GROUPFILE        file containing list of cells
 -h, --help          show help message and exit
 -k                  push ssh key to cell's authorized_keys file
 -l USERID           user to login as on remote cells (default: celladmin)
 -n                  abbreviate non-error output
 -r REGEXP           abbreviate output lines matching a regular expression
 -s SSHOPTIONS       string of options passed through to ssh
 --scp=SCPOPTIONS    string of options passed through to scp if different from
                     sshoptions
 --serial            serialize execution over the cells
 -t                  list target cells
 --unkey             drop keys from target cells' authorized_keys file
 -v                  print extra messages to stdout
 --vmstat=VMSTATOPS  vmstat command options
 -x EXECFILE         file to be copied and executed

See Also:

My Oracle Support for more details about DCLI. Go to the following website, log in with your Customer Support Identifier, and type DCLI in the search box.

https://support.oracle.com/

5.3 Installing Oracle R Distribution Across Exadata Compute Nodes

This section explains how to run DCLI to install Oracle R Distribution across multiple Exadata Linux compute nodes. The commands are summarized in Section 5.3.1.

Important:

Before beginning the installation, review the instructions for installing Oracle R Distribution in Chapter 3.

To install Oracle R Distribution on Exadata using DCLI, follow these steps: 

  1. Configure the Exadata environment to enable automatic authentication for DCLI on each compute node.

    1. Generate an SSH public-private key for the root user. Execute the following command as root on any node:

      $ ssh-keygen -N '' -f /.ssh/id_dsa -t dsa
      

      This command generates public and private key files in the .ssh subdirectory of the home directory of the root user.

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

      $ cat nodes
      exadb01
      exadb02
      
    3. Run the DCLI command with the -k option to establish SSH trust across all the nodes. The -k option causes DCLI to contact each node sequentially (not in parallel) and prompts you to enter the password for each node.

      $ dcli -t -g nodes -l root -k -s "\-o StrictHostkeyChecking=no"
      

      DCLI with -k establishes SSH Trust and User Equivalence. Subsequent DCLI commands will not prompt for passwords.

  2. Download the file: ord-linux-x86_64-3.1.1.tar.gz. To download this file, you must obtain permission from Oracle Support:

    1. Log in to My Oracle Support.

      https://support.oracle.com/
      
    2. Click Contact Us.

    3. Request permission to access this file:

      ord-linux-x86_64-3.1.1.tar.gz
      
    4. When permission is granted, log in as root to any compute node and download the file.

  3. Create a directory and replicate the downloaded file in this directory across all nodes. For example, the following commands create the directory /home/oracle/ORD and replicate the file ord-linux-x86_64-3.1.1.tar.gz in this directory.

    $ dcli -t -g nodes -l root mkdir -p /home/oracle/ORD
    $ dcli -t -g nodes -l root -f ord-linux-x86_64-3.1.1.tar.gz -d
              /home/oracle/ORD/ord-linux-x86_64-3.1.1.tar.gz
    
  4. Uncompress and untar the file to replicate the dependent RPMs across all nodes.

    $ dcli -t -g nodes -l root tar xvfz 
              /home/oracle/ORD/ord-linux-x86_64-3.1.1.tar.gz -C /home/oracle/ORD
    $ ls /home/oracle/ORD/ord-linux-x86_64-3.1.1
    

    Alternatively, you can download these RPMs from the Oracle public yum server. The locations of the RPMs are listed in Example 5-2 through Example 5-7.

    Example 5-2 Oracle R Distribution 3.1.1 RPMs for Oracle Linux 5

    The Oracle R Distribution RPMs for Oracle Linux 5 are listed as follows:

    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /R-3.1.1-2.el5.x86_64.rpm
    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /R-core-3.1.1-2.el5.x86_64.rpm
    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /R-devel-3.1.1-2.el5.x86_64.rpm
    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /libRmath-3.1.1-2.el5.x86_64.rpm
    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /libRmath-devel-3.1.1-2.el5.x86_64.rpm
    http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/getPackage
            /libRmath-static-3.1.1-2.el5.x86_64.rpm
    

    If the dependent RPMs for Oracle Linux 5, listed in Example 5-2, are not automatically included, then download and install them explicitly. The dependent RPMs are listed in Example 5-3.

    Example 5-3 Oracle R Distribution 3.1.1 RPM Dependencies for Oracle Linux 5

    The Oracle R Distribution dependent RPMs for Oracle Linux 5 are listed as follows:

    atk-1.12.2-1.fc6.x86_64.rpm
    avahi-0.6.16-10.el5_6.x86_64.rpm
    avahi-compat-libdns_sd-0.6.16-10.el5_6.x86_64.rpm
    avahi-compat-libdns_sd-devel-0.6.16-10.el5_6.x86_64.rpm
    bitstream-vera-fonts-1.10-7.noarch.rpm
    bzip2-devel-1.0.3-6.el5_5.x86_64.rpm
    Cairo-1.2.4-5.el5.x86_64.rpm
    Cairo-devel-1.2.4-5.el5.x86_64.rpm
    chkfontpath-1.10.1-1.1.x86_64.rpm
    cups-1.3.7-30.el5_9.3.x86_64.rpm
    cups-devel-1.3.7-30.el5_9.3.x86_64.rpm
    cups-libs-1.3.7-30.el5_9.3.x86_64.rpm
    dbus-python-0.70-9.el5_4.x86_64.rpm
    desktop-file-utils-0.10-7.x86_64.rpm
    dialog-1.0.20051107-1.2.2.x86_64.rpm
    e2fsprogs-devel-1.39-36.0.1.el5_9.x86_64.rpm
    ed-0.2-39.el5_2.x86_64.rpm
    fontconfig-devel-2.4.1-7.el5.x86_64.rpm
    freetype-devel-2.2.1-32.el5_9.1.x86_64.rpm
    gcc-gfortran-4.1.2-54.el5.x86_64.rpm
    gdk-pixbuf-0.22.0-25.el5.x86_64.rpm
    gdk-pixbuf-devel-0.22.0-25.el5.x86_64.rpm
    ghostscript-8.70-14.el5_8.1.x86_64.rpm
    ghostscript-fonts-5.50-13.1.1.noarch.rpm
    glib2-devel-2.12.3-4.el5_3.1.x86_64.rpm
    gmp-4.1.4-10.el5.x86_64.rpm
    gnutls-devel-1.4.1-14.el5_10.x86_64
    gtk2-2.10.4-29.el5.x86_64.rpm
    gtk+-1.2.10-57.el5.x86_64.rpm
    hicolor-icon-theme-0.9-2.1.noarch.rpm
    keyutils-libs-devel-1.2-1.el5.x86_64.rpm
    krb5-devel-1.6.1-70.el5_9.2.x86_64.rpm
    libfontenc-1.0.2-2.2.el5.x86_64.rpm
    libFS-1.0.0-3.1.x86_64.rpm
    libgcrypt-devel-1.4.4-7.el5_10.x86_64.rpm
    libgfortran-4.1.2-54.el5.x86_64.rpm
    libgpg-error-devel-1.4-2.x86_64.rpm
    libpng-devel-1.2.10-17.el5_8.x86_64.rpm
    libRmath-3.1.1-2.el5.x86_64.rpm
    libRmath-devel-3.1.1-2.el5.x86_64.rpm
    libselinux-devel-1.33.4-5.7.el5.x86_64.rpm
    libsepol-devel-1.15.2-3.el5.x86_64.rpm
    libtiff-3.8.2-19.el5_10.x86_64.rpm
    libtiff-devel-3.8.2-19.el5_10.x86_64.rpm
    libX11-devel-1.0.3-11.el5_7.1.x86_64.rpm
    libXau-devel-1.0.1-3.1.x86_64.rpm
    libXdmcp-devel-1.0.1-2.1.x86_64.rpm
    libXext-devel-1.0.1-2.1.i386.rpm
    libXext-devel-1.0.1-2.1.x86_64.rpm
    libXfont-1.2.2-1.0.4.el5_7.x86_64.rpm
    libXft-devel-2.1.10-1.1.x86_64.rpm
    libXrender-devel-0.9.1-3.1.x86_64.rpm
    mesa-libGL-devel-6.5.1-7.11.el5_9.x86_64.rpm
    netpbm-10.35.58-10.el5.x86_64.rpm
    netpbm-progs-10.35.58-10.el5.x86_64.rpm
    pango-1.14.9-8.0.1.el5_7.3.x86_64.rpm
    pango-devel-1.14.9-8.0.1.el5_7.3.x86_64.rpm
    paps-0.6.6-20.el5.x86_64.rpm
    pcre-devel-6.6-9.el5.x86_64.rpm
    poppler-0.5.4-19.el5.x86_64.rpm
    poppler-utils-0.5.4-19.el5_9.2.x86_64.rpm
    tcl-devel-8.4.13-6.el5.x86_64.rpm
    tetex-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-dvips-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-fonts-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-latex-3.0-33.8.el5_5.6.x86_64.rpm
    tetex-latex-3.0-33.15.el5_8.1.x86_64.rpm
    texinfo-4.8-14.el5.x86_64.rpm
    texinfo-tex-4.8-14.el5.x86_64.rpm
    tk-devel-8.4.13-5.el5_1.1.x86_64.rpm
    ttmkfdir-3.0.9-23.el5.x86_64.rpm
    urw-fonts-2.3-6.1.1.noarch.rpm
    xorg-x11-font-utils-7.1-3.x86_64.rpm
    xorg-x11-proto-devel-7.1-13.el5.x86_64.rpm
    xorg-x11-xfs-1.0.2-5.el5_6.1.x86_64.rpm
    zlib-devel-1.2.3-7.el5.x86_64.rpm
    

    Example 5-4 Oracle R Distribution 3.1.1 RPMs for Oracle Linux 6

    The Oracle R Distribution RPMs for Oracle Linux 6 are listed as follows:

    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
            /R-3.1.1-2.el6.x86_64.rpm
    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
            /R-core-3.1.1-2.el6.x86_64.rpm
    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
            /R-devel-3.1.1-2.el6.x86_64.rpm
    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
            /libRmath-3.1.1-2.el6.x86_64.rpm
    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
           /libRmath-devel-3.1.1-2.el6.x86_64.rpm
    http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/x86_64/getPackage
           /libRmath-static-3.1.1-2.el6.x86_64.rpm
    

    If the following dependent RPM is not automatically included, then download and install it explicitly:

    texinfo-tex-4.13a-8.el6.x86_64.rpm
    

    Example 5-5 Oracle R Distribution 3.0.1 RPMs for Oracle Linux 5

    The Oracle R Distribution RPMs for Oracle Linux 5 are listed as follows:

    R-3.0.1-2.x86_64.rpm
    R-core-3.0.1-2.x86_64.rpm
    R-devel-3.0.1-2.x86_64.rpm
    libRmath-3.0.1-2.x86_64.rpm
    libRmath-devel-3.0.1-2.x86_64.rpm
    libRmath-static-devel-3.0.1-2.x86_64.rpm
    

    If the dependent RPMs for Oracle Linux 5, listed in Example 5-5, are not automatically included, then download and install them explicitly. The dependencies are listed in Example 5-6.

    Example 5-6 Oracle R Distribution 3.0.1 RPM Dependencies for Oracle Linux 5

    The Oracle R Distribution dependent RPMs for Oracle Linux 5 are listed as follows:

    atk-1.12.2-1.fc6.x86_64.rpm
    avahi-0.6.16-10.el5_6.x86_64.rpm
    avahi-compat-libdns_sd-0.6.16-10.el5_6.x86_64.rpm
    bitstream-vera-fonts-1.10-7.noarch.rpm
    bzip2-devel-1.0.3-6.el5_5.x86_64.rpm
    Cairo-1.2.4-5.el5.x86_64.rpm
    chkfontpath-1.10.1-1.1.x86_64.rpm
    cpp-4.1.2-54.el5.x86_64.rpm
    cups-1.3.7-30.el5_9.3.x86_64.rpm
    cups-libs-1.3.7-30.el5_9.3.x86_64.rpm
    dbus-python-0.70-9.el5_4.x86_64.rpm
    desktop-file-utils-0.10-7.x86_64.rpm
    dialog-1.0.20051107-1.2.2.x86_64.rpm
    ed-0.2-39.el5_2.x86_64.rpm
    gcc-4.1.2-54.el5.x86_64.rpm
    gcc-c++-4.1.2-54.el5.x86_64.rpm
    gcc-gfortran-4.1.2-54.el5.x86_64.rpm
    ghostscript-8.70-14.el5_8.1.x86_64.rpm
    ghostscript-fonts-5.50-13.1.1.noarch.rpm
    gmp-4.1.4-10.el5.x86_64.rpm
    gtk2-2.10.4-29.el5.x86_64.rpm
    hicolor-icon-theme-0.9-2.1.noarch.rpm
    libFS-1.0.0-3.1.x86_64.rpm
    libX11-1.0.3-11.el5_7.1.x86_64.rpm
    libX11-devel-1.0.3-11.el5_7.1.x86_64.rpm
    libXau-devel-1.0.1-3.1.x86_64.rpm
    libXdmcp-devel-1.0.1-2.1.x86_64.rpm
    libXfont-1.2.2-1.0.4.el5_7.x86_64.rpm
    libfontenc-1.0.2-2.2.el5.x86_64.rpm
    libgcc-4.1.2-54.el5.i386.rpm
    libgcc-4.1.2-54.el5.x86_64.rpm
    libgfortran-4.1.2-52.el5_8.1.i386.rpm
    libgfortran-4.1.2-54.el5.x86_64.rpm
    libstdc++-4.1.2-54.el5.i386.rpm
    libstdc++-4.1.2-54.el5.x86_64.rpm
    libstdc++-devel-4.1.2-54.el5.i386.rpm
    libstdc++-devel-4.1.2-54.el5.x86_64.rpm
    libtiff-3.8.2-18.el5_8.x86_64.rpm
    mesa-libGL-6.5.1-7.11.el5_9.x86_64.rpm
    mesa-libGL-devel-6.5.1-7.11.el5_9.x86_64.rpm
    netpbm-10.35.58-10.el5.x86_64.rpm
    netpbm-progs-10.35.58-10.el5.x86_64.rpm
    pango-1.14.9-8.0.1.el5_7.3.x86_64.rpm
    paps-0.6.6-20.el5.x86_64.rpm
    pcre-6.6-6.el5_6.1.x86_64.rpm
    pcre-devel-6.6-6.el5_6.1.x86_64.rpm
    poppler-0.5.4-19.el5.x86_64.rpm
    poppler-utils-0.5.4-19.el5.x86_64.rpm
    tcl-8.4.13-6.el5.x86_64.rpm
    tcl-devel-8.4.13-6.el5.x86_64.rpm
    tetex-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-dvips-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-fonts-3.0-33.15.el5_8.1.x86_64.rpm
    tetex-latex-3.0-33.15.el5_8.1.x86_64.rpm
    texinfo-4.8-14.el5.x86_64.rpm
    texinfo-tex-4.8-14.el5.x86_64.rpm
    tk-devel-8.4.13-5.el5_1.1.x86_64.rpm
    ttmkfdir-3.0.9-23.el5.x86_64.rpm
    urw-fonts-2.3-6.1.1.noarch.rpm
    xorg-x11-font-utils-7.1-3.x86_64.rpm
    xorg-x11-proto-devel-7.1-13.el5.x86_64.rpm
    xorg-x11-xfs-1.0.2-5.el5_6.1.x86_64.rpm
    zlib-1.2.3-7.el5.i386.rpm
    zlib-1.2.3-7.el5.x86_64.rpm
    zlib-devel-1.2.3-7.el5.x86_64.rpm
    

    Example 5-7 Oracle R Distribution 3.0.1 RPMs for Oracle Linux 6

    The Oracle R Distribution RPMs for Oracle Linux 6 are listed as follows:

    R-3.0.1-2.el6.x86_64.rpm
    R-core-3.0.1-2.el6.x86_64.rpm
    R-devel-3.0.1-2.el6.x86_64.rpm
    libRmath-3.0.1-2.el6.x86_64.rpm
    libRmath-devel-3.0.1-2.el6.x86_64.rpm
    libRmath-static-3.0.1-2.el6.x86_64.rpm
    

    If the following dependent RPM is not automatically included, then download and install it explicitly:

    texinfo-tex-4.13a-8.el6.x86_64.rpm
    
  5. To install the new RPMs and update existing RPMs across nodes, execute the following RPM command:

    $ dcli -t -g nodes -l root rpm -i --force 
              /home/oracle/ORD/ord-linux-x86_64-3.1.1/*.rpm
    

    The --force flag prevents errors from circular dependencies.

  6. Verify the R installations on each node by first returning to the location where R is installed and then starting R.

    $ dcli -g nodes -l oracle R RHOME
    exadb01: /usr/lib64/R
    exadb02: /usr/lib64/R
    

    The following command returns this output for each node.

    $ dcli -g nodes -l oracle R --vanilla
    exadb01: Oracle Distribution of R version 3.1.1 (--) -- "Good Sport"
    exadb01: Copyright (C) The R Foundation for Statistical Computing
    exadb01: Platform: x86_64-unknown-linux-gnu (64-bit)
    exadb01:
    exadb01: R is free software and comes with ABSOLUTELY NO WARRANTY.
    exadb01: You are welcome to redistribute it under certain conditions.
    exadb01: Type 'license()' or 'licence()' for distribution details.
    exadb01:
    exadb01: Natural language support but running in an English locale
    exadb01:
    exadb01: R is a collaborative project with many contributors.
    exadb01: Type 'contributors()' for more information and
    exadb01: 'citation()' on how to cite R or R packages in publications.
    exadb01:
    exadb01: Type 'demo()' for some demos, 'help()' for on-line help, or
    exadb01: 'help.start()' for an HTML browser interface to help.
    exadb01: Type 'q()' to quit R.
    exadb01:
    exadb01: You are using Oracle's distribution of R. Please contact
    exadb01: Oracle Support for any problems you encounter with this
    exadb01: distribution.
    

5.3.1 DCLI Command Summary for Oracle R Distribution installation on Exadata

The DCLI commands used to install Oracle R Distribution 3.1.1 on a Linux Exadata system are listed in Example 5-8.

Example 5-8 DCLI Command Summary for Oracle R Distribution

ssh-keygen -N " -f ~/.ssh/id_dsa -t dsa
vi nodes # enter node names
dcli -t -g nodes -l root -k -s "\-o StrictHostkeyChecking=no" 
dcli -t -g nodes -l root mkdir -p /home/oracle/ORD
dcli -t -g nodes -l root -f ord-linux-x86_64-3.1.1.tar.gz -d
           /home/oracle/ORD/ord-linux-x86_64-3.1.1.tar.gz 
dcli -t -g nodes -l root tar xvfz /home/oracle/ORD/ord-linux-x86_64-3.1.1.tar.gz
          -C /home/oracle/ORD
dcli -t -g nodes -l root rpm -i --force 
          /home/oracle/ORD/ord-linux-x86_64-3.1.1/*.rpm
dcli -g nodes -l root R RHOME
dcli -g nodes -l root R --vanilla

5.4 Installing Oracle R Enterprise Server Across Exadata Compute Nodes

This section explains how to run DCLI to install Oracle R Enterprise Server across multiple Exadata Linux compute nodes. The commands are summarized in Section 5.4.1.

Important:

Before beginning the installation, review the instructions for installing Oracle R Enterprise Server in Chapter 4.

To install Oracle R Enterprise Server on Exadata using DCLI, follow these steps: 

  1. Ensure that the ORACLE_HOME, ORACLE_SID, R_HOME, PATH, and LD_LIBRARY_PATH environment variables are properly set on each node. For example, you could specify values like the following in a bashrc file:

    export ORACLE_HOME=/hostname/app/oracle/product/11.2.0.4/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:$R_HOME/lib
    
  2. Go to the Oracle R Enterprise home page on the Oracle Technology Network:.

    http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/

    Select Oracle R Enterprise Downloads. On the Downloads page, select Oracle R Enterprise Server and the Supporting Packages for Linux. The following files are downloaded for Oracle R Enterprise 1.4.1.

    ore-server-linux-x86-64-1.4.1.zip
    ore-supporting-linux-x86-64-1.4.1.zip
    
  3. Login as root, and copy the installers for Oracle R Enterprise Server and the supporting packages across nodes. For example:

    $ dcli -g nodes -l oracle mkdir -p /home/oracle/ORE
    $ dcli -g nodes -l oracle -f ore-server-linux-x86-64-1.4.1.zip -d 
         /home/oracle/ORE/ore-server-linux-x86-64-1.4.1.zip
    $ dcli -g nodes -l oracle -f ore-supporting-linux-x86-64-1.4.1.zip -d 
         /home/oracle/ORE/ore-supporting-linux-x86-64-1.4.1.zip
    
  4. Unzip the supporting packages on each node:

    $ dcli -t -g nodes -l oracle unzip   
         /home/oracle/ORE/ore-supporting-linux-x86-64-1.4.1.zip -d 
         /my_destination_directory/
    
  5. Install Oracle R Enterprise server components:

    $ dcli -t -g nodes -l oracle "cd /my_destination_directory; ./server.sh -y
          --admin --sys syspassword --perm permtablespace
          --temp temptablespace --rqsys rqsyspassword
          --user-perm usertablespace --user-temp usertemptablespace
          --pass rquserpassword --user RQUSER"
    

    Note:

    The server script creates a user for Oracle R Enterprise. By default, the script does not grant the rqadmin role to the user.

    Any Oracle R Enterprise user can execute embedded R, but only those with the rqadmin role can create and drop the R scripts in the database. Use caution when granting the rqadmin role.

    See Section 7.5.1, "About the RQADMIN Role"

  6. Verify Oracle R Enterprise loads.

    > 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 
    

5.4.1 DCLI Commands Summary for Oracle R Enterprise Server

The DCLI commands used to install Oracle R Enterprise Server 1.4.1 and the supporting packages on a Linux Exadata system are listed in Example 5-9.

Example 5-9 DCLI Command Summary for Oracle R Enterprise Server

dcli -g nodes -l oracle mkdir -p /home/oracle/ORE
dcli -g nodes -l oracle -f ore-server-linux-x86-64-1.4.1.zip -d
     /home/oracle/ORE/ore-server-linux-x86-64-1.4.1.zip
dcli -g nodes -l oracle -f ore-supporting-linux-x86-64-1.4.1.zip -d
     /home/oracle/ORE/ore-supporting-linux-x86-64-1.4.1.zip
dcli -t -g nodes -l oracle /home/oracle/ORE/server/./server.sh
./demo_user.sh
cd /home/oracle/ORE 
sqlplus / as sysdba
     grant RQADMIN to rquser;
     grant CREATE TABLE to rquser;
     grant CREATE SESSION to rquser;
     grant CREATE VIEW to rquser;
     grant CREATE PROCEDURE to rquser;
     grant CREATE MINING MODEL to rquser;
exit;
dcli -t -g nodes -l oracle ORE -e "library(ORE)"