Skip Headers
Oracle® R Enterprise Installation and Administration Guide
Release 1.3.1 for Windows, Linux, Solaris, and AIX

E36763-17
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Installing Oracle R Enterprise Server

This chapter explains how to install Oracle R Enterprise Server. This chapter includes these topics:

4.1 About Oracle R Enterprise Server

4.1.1 What Is Oracle R Enterprise Server?

Oracle R Enterprise Server enables an Oracle database to support an Oracle R Enterprise client.

Oracle R Enterprise Server includes the following:

  • The RQSYS schema

  • Libraries used by Oracle Database

  • Oracle R Enterprise packages, which support embedded R execution

4.1.2 Server Components of Oracle R Enterprise

Oracle R Enterprise includes several components that must be installed separately on the server computer.

These Oracle R Enterprise Server components must be installed in this order: 

  1. Oracle Database Enterprise Edition

  2. Oracle R Distribution or open source R

  3. Oracle R Enterprise Server, which includes the Oracle R Enterprise packages

  4. Oracle R Enterprise client supporting packages

An illustration of the client and server components of Oracle R Enterprise is shown in Figure 1-2.

4.1.3 About the Oracle R Enterprise Server Installation Script

The Oracle R Enterprise Server installation script performs the following:

  1. Verifies the environment:

    • Verifies the presence of an R installation

    • Verifies the presence of the libR.so, libRblas.so, and libRlapack.so libraries in $R_HOME/lib, where $R_HOME is /usr/lib64/R

    • Verifies that $ORACLE_HOME and $ORACLE_SID are set

  2. Starts SQL*Plus as sysdba and connects to the database specified in ORACLE_SID

  3. In the database:

    • Determines if Oracle R Enterprise Server is already installed by querying DBA_USERS for the user RQSYS.

      If RQSYS is found, the installer checks the version of Oracle R Enterprise in the sys.rq_config file. The Installer uses the version information later to install the correct PL/SQL packages.

    • Prompts for the location of permanent and temporary tablespaces for RQSYS. By default, the tablespaces are created in SYSAUX and TEMP.

    • Copies Oracle R Enterprise Server libraries to $ORACLE_HOME/lib.

    • Creates the RQSYS schema, if it does not already exist.

    • Creates objects in RQSYS and installs the Oracle R Enterprise PL/SQL packages.

  4. Installs the Oracle R Enterprise client packages in $ORACLE_HOME/R/library

4.2 Oracle R Enterprise Server Requirements

Before installing Oracle R Enterprise Server, verify the following requirements:

4.2.1 System Requirements

  • The operating system must conform to the requirements specified in Section 1.7.

  • Oracle Database must be installed and configured as described in Chapter 2.

  • R must be installed as described in Chapter 3.

4.2.1.1 Verifying 64-Bit Architecture on Microsoft Windows

Oracle R Enterprise only runs on 64-bit operating systems. You can determine if your Windows system is 64-bit by following these steps:

  • Windows 7 or Windows Vista:

    1. From Windows Control Panel, choose System.

    2. Verify that System type is 64-bit Operating System.

  • Windows XP:

    1. From the Start menu, choose My Computer.

    2. Click Properties.

    3. On the System tab, verify that the system is x64 Edition.

4.2.2 Environment Variable Requirements

Before installing Oracle R Enterprise Server, ensure that environment variables are set as shown in Table 4-1.

Table 4-1 Environment Variable Requirements for Oracle R Enterprise Server

Platform Environment Variable Requirement

all

ORACLE_SID must specify the service identifier (SID) of the database that will support Oracle R Enterprise.

ORACLE_HOME must specify the home directory of the database identified by ORACLE_SID.

Linux

LD_LIBRARY_PATH must include $ORACLE_HOME/lib.

PATH must include $ORACLE_HOME/bin.

Oracle Solaris

LD_LIBRARY_PATH must include $ORACLE_HOME/lib.

PATH must include $ORACLE_HOME/bin.

IBM AIX

LIBPATH must include $ORACLE_HOME/lib.

PATH must include $ORACLE_HOME/bin.

Microsoft Windows

PATH must include %ORACLE_HOME%\bin.


4.2.2.1 Creating Environment Variable on Windows

If the PATH, ORACLE_SID, and ORACLE_HOME environment variables do not exist, you must create them and assign the values specified in Table 4-1. On Windows systems, you must be an administrator to create or modify environment variables.

Follow these steps to create or modify environment variables on Windows: 

  • Windows 7 and Windows Vista:

    1. Right-click the Computer icon and choose Properties.

    2. Choose Advanced system settings.

    3. On the Advanced tab, choose Environment Variables.

    4. Create or modify the environment variables.

  • Windows XP:

    1. Right-click the My Computer icon and choose Properties.

    2. On the Advanced tab, choose Environment Variables.

    3. Create or modify the environment variables.

4.2.3 User Requirements

The operating system user that installs Oracle R Enterprise Server must meet the requirements described in Table 4-2.

Table 4-2 User Requirements for Oracle R Enterprise Server Installer

Platform User Requirement

Linux and UNIX

  • Member of the DBA group

  • Has write access to $ORACLE_HOME/lib

Microsoft Windows

  • Administrator access

  • Member of the ORA_DBA group

  • Has write access to %ORACLE_HOME%\lib


4.2.3.1 About Operating System Authentication

The Oracle R Enterprise Server installation script uses system authentication to connect to the database identified by ORACLE_HOME and ORACLE_SID. System authentication is based on the operating system credentials of the user instead of the database credentials.

For example, on a Linux system, the Oracle R Enterprise installation script uses this statement to start SQL*Plus without a password:

$ORACLE_HOME/bin/sqlplus / as sysdba

Membership in a special operating system group enables system authentication for Oracle Database. The operating system group is created during installation of the database, and the identity of the installer is automatically assigned to the group. The generic name for the group is OSDBA. On Linux and UNIX, the name for OSDBA is DBA. On Windows, the name for OSDBA is ORA_DBA.

The user that installs Oracle R Enterprise Server must belong to OSDBA.

See Also:

4.3 Installing Oracle R Enterprise Server on Linux or UNIX

These installation instructions apply to the Linux and UNIX platforms described in Section 1.7.

To install Oracle R Enterprise Server on Linux or UNIX: 

  1. Ensure that your system satisfies the requirements specified in Section 4.2, "Oracle R Enterprise Server Requirements".

  2. Ensure that your user ID has the permissions described in Section 4.2.3, "User Requirements"

  3. Create an installation directory for the Oracle R Enterprise server components. The directory can have any name. For example:

    ~/oreserver_install_dir
    
  4. Go to the Oracle R Enterprise Downloads page on the Oracle Technology Network:

    http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html

  5. Accept the license agreement and select Oracle R Enterprise Downloads (v1.3.1).

  6. Select Oracle R Enterprise Server Install for Oracle Database for your platform. Save the file in the installation directory that you created in Step 3.

    ~/oreserver_install_dir/ore-server-platform-arch-1.3.1.zip
    
  7. Unzip the file as follows:

    % unzip ore-server-platform-arch-1.3.1.zip
    

    The files are unzipped into the server subdirectory:

    ~/oreserver_install_dir/server/
    
  8. Run the installation script in the server subdirectory.

    % cd server/
    % ./install.sh
    
  9. When prompted, provide the locations of permanent and temporary tablespaces for the RQSYS schema. SYSAUX and TEMP are used by default.

    Tip:

    Refer to Section 4.1.3 for a description of the actions performed by the Oracle R Enterprise Server installation script.
  10. When the Oracle R Enterprise Server installation script is finished, complete the installation by installing the client supporting packages.

    1. Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).

    2. Accept the license agreement and select Oracle R Enterprise Client Supporting Packages for your platform. Save the file in the installation directory.

      ~/oreserver_install_dir/ore-supporting-platform-arch-1.3.1.zip
      
    3. Unzip the file as follows:

      % unzip ore-supporting-platform-arch-1.3.1.zip
      

      The files are unzipped into the supporting subdirectory:

      ~/oreserver_install_dir/supporting/
      
    4. Install the packages:

      % cd supporting
      % ORE CMD INSTALL ROracle_1.1-9_R_x86_64-unknown-linux-gnu.tar.gz
      % ORE CMD INSTALL DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz
      % ORE CMD INSTALL png_0.1-4_R_x86_64-unknown-linux-gnu.tar.gz
      

      The packages are installed in $ORACLE_HOME/R/library.

  11. Follow the procedures in Section 6.1 to create and configure a database user account for Oracle R Enterprise.

See Also:

Appendix A for the steps in a typical installation of Oracle R Enterprise on a Linux server and Windows client

4.3.1 Installing Additional R Packages on Linux or UNIX

On Linux and UNIX platforms, the Oracle R Enterprise Server installation provides the ORE script, which you can run from the operating system prompt to install additional R packages. The ORE script is a wrapper for the R installation command: R CMD INSTALL.

By default, R packages are installed in /usr/lib64/R/library. The ORE script, however, installs R packages in a subdirectory under $ORACLE_HOME/R/library.

To execute the script:

% ORE CMD INSTALL R_package_name

4.4 Installing Oracle R Enterprise Server on Microsoft Windows

These installation instructions apply to Microsoft Windows 64-bit platforms, as described in Table 1-1.

To install Oracle R Enterprise Server on Windows: 

  1. Ensure that your system satisfies the requirements specified in Table 4-2.

  2. Ensure that your user ID has the permissions described in Section 4.2.3, "User Requirements"

  3. Create an installation directory for the Oracle R Enterprise server components. The directory can have any name. For example:

    c:\oreserver_install_dir
    
  4. Go to the Oracle R Enterprise Downloads page on the Oracle Technology Network:

    http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html

  5. Accept the license agreement and select Oracle R Enterprise Server Install for Oracle Database on Windows 64 bit platform. Save the file in the installation directory that you created in Step 3.

    c:\oreserver_install_dir\ore-server-win-x86_64-1.3.1.zip
    
  6. Unzip the file. The files are unzipped in the server subdirectory:

    c:\oreserver_install_dir\server
    
  7. In a command window, change to the server subdirectory and execute the installation batch file:

    > cd c:\oreserver_install_dir\server
    > install.bat
    
  8. When prompted, provide the locations of permanent and temporary tablespaces for the RQSYS schema. SYSAUX and TEMP are used by default.

    Tip:

    Refer to Section 4.1.3 for a description of the actions performed by the Oracle R Enterprise Server installation script.
  9. When the Oracle R Enterprise Server installation script is finished, complete the installation by installing the client supporting packages.

    1. Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).

    2. Accept the license agreement and select Oracle R Enterprise Client Supporting Packages for Windows Platform. Save the file in the installation directory.

      c:\oreserver_install_dir\ore-supporting-win-x86_64-1.3.1.zip
      
    3. Unzip the file. The files are unzipped in the supporting subdirectory.

      c:\oreserver_install_dir\supporting\
      
    4. Start R from the Windows Start menu. If you have installed both 32- and 64-bit R, be sure to choose 64-bit R.

      The R Console window is displayed.

    5. Install the packages as follows:

      R> install.packages("c:/oreserver_install_dir/supporting/
                          ROracle_1.1-9.zip", repos=NULL)
      R> install.packages("c:/oreserver_install_dir/supporting/
                          DBI_0.2-5.zip", repos=NULL)
      R> install.packages("c:/oreserver_install_dir/supporting/
                          png_0.1-4.zip", repos=NULL)
      

      The packages are installed in $ORACLE_HOME/R/library.

  10. Follow the procedures in Section 6.1 to create and configure a user account for Oracle R Enterprise.

4.5 Installing Oracle R Enterprise Server on Oracle Exadata Database Machine

Oracle Exadata Database Machine consists of several compute nodes, along with storage and other facilities. Each node hosts an Oracle database.

To install Oracle R Enterprise Server on Oracle Exadata Database Machine: 

  1. On each node:

    • Install Oracle R Distribution as described in Section 3.5.

    • Ensure that the environment is configured as described in Section 4.2. Environment variables must be set on each node.

    • Install Oracle R Enterprise Server, as described in Section 4.3.

    • Install Oracle R Enterprise client supporting packages, as described in Section 5.2.

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

4.6 Verifying the Oracle R Enterprise Server Installation

The Oracle R Enterprise server installation script creates log files in the server subdirectory of the installation directory. Examine the log files to verify the success of the installation process.

The following commands on a Linux or UNIX system list the log files:

% cd ./oreserver_install_dir/server
% ls *.log
rqinst.log  rqproc.log

If there are problems with the installation and you are unable to resolve them, you can request help from My Oracle Support or from the Oracle R Enterprise discussion forum.