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

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

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

4 Install Server

This chapter describes how to install the Oracle R Enterprise server on Linux, Solaris, or AIX. You can also install the server on Oracle Exadata, as described in Install Server on Oracle Exadata Database Machine.

Install the same release of Oracle R Enterprise for both client and server.

Install the server as follows:

  1. Make sure that the Prerequisites for your platform are satisfied.

  2. Make sure that Oracle Database Requirements is installed on the system where you plan to install the server. Make sure that any required patches are installed properly.

  3. Install R, as described in R Requirement.

    Install R before you install the server.

    Before you start the server installation, check that you can run R. This usually means that the R executable is in your PATH environment variable.

  4. Make sure that the Required Privileges are satisfied. If you do not run the install script from an appropriate account, the script will fail.

  5. Properly set certain Environment Variables. Define ORACLE_SID. Add $ORACLE_HOME/lib to LD_LIBRARY_PATH and $ORACLE_HOME/bin to PATH.

  6. Read Server Installation Overview or go to Install Server on Microsoft Windows, Install Server on Linux, Install Server on Solaris, or Install Server on AIX to begin the install. You can also Install Server on Oracle Exadata Database Machine.

  7. Follow the directions in Install Server on Microsoft Windows, Install Server on Linux, Install Server on Solaris, Install Server on AIX, or Install Server on Oracle Exadata Database Machine to install the server.

  8. Install the Oracle R Enterprise Client Supporting Packages.

Before you can run Oracle R Enterprise, you must create at least one user, as described in Oracle R Enterprise Users. Then you can Validate Oracle R Enterprise Installation.

Before You Install the Server

The install scripts for the Oracle R Enterprise server require:

This section also contains the Server Installation Overview that explains how the installation script works.

Required Privileges

Important: Before you start installation, make sure that:

  • You have DBA privileges, that is, you can run as oracle:

    • On Windows, you must be a member of the ORA_DBA group; see Notes for Microsoft Windows Installation for more information.

    • On Linux, you must be a member of the DBA group; the user oracle satisfies this requirement. Note that root is not usually a member of the DBA group.

      If necessary, users can be added to the DBA group with

      useradd -G dba <username>
      
    • On Solaris, you must be a member of the DBA group

    • On AIX, you must be a member of the DBA group

    In any case, make sure that you are logged in to an account in which you can run sqlplus / as sysdba before you run the install script.

  • You have write privileges at the operating system level to the directory $ORACLE_HOME/lib; the user oracle satisfies this requirement

In summary, for all platforms, you can use the account that you used to install the database to install the server. Check that you can run R from this account.

Environment Variables

Make sure that these environment variables exist and are defined properly:

  • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH (LIBPATH for AIX)

  • Add $ORACLE_HOME/bin to PATH

  • Define the variable $ORACLE_SID; it contains the SID for the database where you install Oracle R Enterprise.

For Microsoft Windows, you must add R to the PATH environment variable. If you installed R in the default location, you must add one of the following to PATH:

  • For 64-bit Windows, C:\Program Files\R\R-2.15.1\bin\x64

  • For 32-bit Windows, C:\Program Files\R\R-2.15.1\bin\i386

Note that the R_HOME environment variable does not need to be explicitly set, as install.bat or install.sh finds it during the installation.

Server Installation Overview

The installation scripts for the server works as follows:

  1. Before the Oracle R Enterprise server install starts, the script checks for the presence of an R installation.

  2. Once the script verifies that R is known to be installed and its location known via PATH, the install checks for the presence of these libraries in $R_HOME/lib/. In particular, the script checks for

    • $R_HOME/lib/libR.so

    • $R_HOME/lib/libRblas.so

    • $R_HOME/lib/libRlapack.so

  3. Next the script checks the location of the database installation by checking for the presence of environment variable ORACLE_HOME and ORACLE_SID.

    If ORACLE_HOME is set, the install expects that the $ORACLE_HOME/lib directory is present.

    Before you start the script check that ORACLE_HOME and ORACLE_SID are present and properly set.

  4. Next the script checks Oracle database instance information. The check includes looking for environment variable ORACLE_SID and then connecting to the instance by starting

    sqlplus  /as sysdba
    

    Logging into the database as sysdba is critical for the install script to proceed.

    If sqlplus fails to connect to the database instance, the install process aborts.

    Before you start the installation script, check that you can connect to the database using this sqlplus command.

  5. If Oracle R Enterprise has been installed on the database, that is, if you installed release 1.0, 1.1, or 1.2, then the installer expects to find a user name RQSYS in dba_users table and the Oracle R Enterprise version number details in SYS.RQ_CONFIG. The installer uses this information subsequently to install the correct SQL packages.

  6. The script prompts you to optionally enter the names of permanent and temporary table spaces for the RQSYS schema; the default schemas are SYSAUX and TEMP.

    At this point, the install script has determined it has found the prerequisites satisfactory and proceeds to do the actual installation.

  7. The install script now attempts to copy libraries to $ORACLE_HOME/lib.

    If $ORACLE_HOME/lib is not writable then the installer errors out.

  8. The install script now installs the RQSYS schema. Installing the schema requires logging into the database as SYSDBA.

  9. Finally, the ORE packages are installed under $ORACLE_HOME/R/library.

Install Server on Microsoft Windows

These directions describe how to install Oracle R Enterprise on Microsoft Windows XP or later for the 64-bit architecture.

Review Before You Install the Server before you run the installation script. Make sure that all environment variables are properly set and that all required directories are present.

Follow these steps to install the server:

  1. Before you start the installation, make sure that these environment variables exist and are defined properly:

    • Add %ORACLE_HOME%\bin to PATH

    • Add R to the PATH environment variable. If you installed R in the default location, you must add one of the following to PATH:

      • For 64-bit Windows, C:\Program Files\R\R-2.15.1\bin\x64

      • For 32-bit Windows, C:\Program Files\R\R-2.15.1\bin\i386

    • Define the variable ORACLE_SID; it contains the SID for the database where you install ORE.

    For information about setting environment variables in Windows, see Notes for Microsoft Windows Installation.

  2. You must have DBA privileges that is, you can run as oracle. The install scripts run SQL*Plus / as sysdba and write to ORACLE_HOME.

  3. Download the appropriate files for your system, as described in Download Oracle R Enterprise Software. You must download two archives:

    • ore-server-win-x86_64-1.3.1.zip

    • ore-supporting-win-x86_64-1.3.1.zip

  4. Unzip the server download ore-server-win-x86_64-1.3.1.zip.

  5. Make sure that you are logged in to an account that has DBA privileges.

  6. Open a command window and navigate to the directory where you unzipped the server download.

  7. Execute install.bat.

    Note:

    If install.bat fails, go to Before You Install the Server and check that all requirements are satisfied.

    For example, if the environment variables ORACLE_HOME and ORACLE_SID are not set, install.bat will fail.

  8. Install the R supporting packages ore-supporting-win-x86_64-1.3.1.zip.

    To install the supporting packages, unzip ore-supporting-win-x86_64-1.3.1.zip, and then use these commands:

    install.packages("<dep path>/supporting/ROracle_1.1-8.zip", repos=NULL)
    install.packages("<dep path>/supporting/DBI_0.2-5.zip", repos=NULL)
    install.packages("<dep path>/supporting/png_0.1-4.zip", repos=NULL)
    

    <dep path> is the directory where you unzipped ore-supporting-win-x86_64-1.3.1.zip.

    Each package install produces the message "successfully unpacked and MD5 sums checked" in the R Console.

  9. After installation completes, create at least one user, as described in Oracle R Enterprise Users. It may be necessary to make certain GRANTs to users who perform certain tasks; see Required GRANTs.

  10. You may wish to use Oracle Wallet, especially if you plan to run scripts in light-out mode. For information, see Configure Oracle Wallet (Optional)

  11. Validate Oracle R Enterprise Installation.

Check PC Architecture

Follow these steps to find out if your computer is running a 64-bit version of Windows:

  • If the operating system is Windows 7 or Windows Vista:

    1. Open System: Click Start button, right-click Computer, and then click Properties.

    2. System shows the system type.

  • If the operating system is Windows XP:

    1. Click Start.

    2. Right-click My Computer, and then click Properties.

    3. If you don't see "x64 Edition" listed, then you're running the 32-bit version of Windows XP.

      If "x64 Edition" is listed under System, you're running the 64-bit version of Windows XP.

Notes for Microsoft Windows Installation

Before you install the Server on Windows, perform these checks:

Check Membership in ORA_DBA

If you installed Oracle on Windows, you are automatically added to ORA_DBA. Checking that you are a member of the ORA_DBA group depends on the release of Windows:

For information about ORA_DBA, see the Oracle Database Platform Guide 11g Release 2 (11.2) for Microsoft Windows.

Create or Modify Environment Variables

The install script looks at the PATH system variable to find the Database executable. On Windows, you may not have a PATH system variable defined.

If the PATH variable does not exist, create it and set it to %ORACLE_HOME%\bin, the directory where the executable for the Database resides.

Windows does not require the LD_LIBRARY_PATH environment variable that is required by the other platforms.

You view, edit and create s environment variable from the Advanced tab of System. The steps to navigate to this tab depends on the version of Windows installed on your system:

  • For Microsoft Windows XP, go to Start then Control Panel. Double-click System. On the Advanced tab click Environment Variables.

  • For Microsoft Windows Vista, click Start, type Accounts in the Start search box, and then click User Accounts under Programs. In the User Accounts dialog box, click Change my environment variables under Tasks. Make changes and then click OK when done.

  • For Microsoft Windows 7, go to Start then Control Panel. Double click System and Security, then System, and then Advanced system settings.

It may be necessary to log in as an administrator to change environment variables.

Check R Installation

You must install R (64-bit) before you install the server. Before you start the server installation, check that you can run R If you installed R in the default location, the GUI executable resides in C:\Program Files\R\R-2.15.1\bin\x64.

Install Server on Linux

These directions describe how to install Oracle R Enterprise on Oracle Linux or Red Hat Linux on the Linux x86-64 platform. To install the server on Oracle Exadata, see Install Server on Oracle Exadata Database Machine.

Review Before You Install the Server before you run the installation script. Make sure that all environment variables are properly set and that all required directories are present.

Follow these steps to install the server:

  1. Install a Database that satisfies Oracle Database Requirements. Make sure that any required patches are installed properly. If the Database is already installed, make sure that it satisfies the requirements.

  2. Install R, as described in R Requirement.

  3. Make sure that these environment variables exist and are defined properly:

    • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH

    • Add $ORACLE_HOME/bin to PATH

    • Define the variable $ORACLE_SID; it contains the SID for the database where you install ORE.

  4. You must have DBA privileges that is, you can run as oracle. The install scripts run SQL*Plus / as sysdba and write to ORACLE_HOME.

  5. Download ore-server-linux-x86-64-1.3.1.zip as described in Download Oracle R Enterprise Software. If you install the server on Oracle Database 11g Release 2 (11.2), you must download the archive.

  6. Unzip ore-server-linux-x86-64-1.3.1.zip into an empty directory on your local system. This creates a directory containing library files, SQL scripts, and the install shell script install.sh.

  7. Run install.sh. to create objects in the SYS and RQSYS schemas.

    This script copies ORE packages to $ORACLE_HOME/R/library and R_LIBS_USER.

    The script executes rqinst.sqlwith SYSAUX and TEMP as the default and temporary tablespaces.

    The script creates all SQL objects required by Oracle R Enterprise in the RQSYS user schema. The RQSYS schema is created as a locked account with expired password and no connect privileges.

  8. Install the Oracle R Enterprise Client Supporting Packages ore-supporting-linux-x86-64-1.3.1.zip as follows:

    Unzip the download. Go to the directory where you unzipped the archive and use the ORE script to install the packages:

    ORE CMD INSTALL DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz
    ORE CMD INSTALL ROracle_1.1-8_R_x86_64-unknown-linux-gnu.tar.gz
    ORE CMD INSTALL png_0.1-4_R_x86_64-unknown-linux-gnu.tar.gz
    
  9. After installation completes, create at least one user, as described in Oracle R Enterprise Users. It may be necessary to make certain GRANTs to users who perform certain tasks; see Required GRANTs.

  10. You may wish to use Oracle Wallet, especially if you plan to run scripts in light-out mode. For information, see Configure Oracle Wallet (Optional)

  11. Validate Oracle R Enterprise Installation.

Install Server on Solaris

These directions describe how to install Oracle R Enterprise on Oracle Solaris on SPARC and x86-64 platforms.

Review Before You Install the Server before you run the installation script. Make sure that all environment variables are properly set and that all required directories are present.

After the client installation completes, follow these steps to install the server:

  1. Install a Database that satisfies Oracle Database Requirements. Make sure that any required patches are installed properly. If the Database is already installed, make sure that it satisfies the requirements.

  2. Install R, as described in R Requirement.

  3. Before you start the installation, make sure that these environment variables exist and are defined properly:

    • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH

    • Add $ORACLE_HOME/bin to PATH

    • Define the variable $ORACLE_SID; it contains the SID for the database where you install ORE.

  4. You must have DBA privileges that is, you can run as oracle. The install scripts run SQL*Plus / as sysdba and write to ORACLE_HOME.

  5. Download ore-server-solaris-sparc-64-1.3.1.zip or ore-server-solaris-x86-64-1.3.1.zip as described in Download Oracle R Enterprise Software. If you install the server on Oracle Database 11g Release 2 (11.2), you must download the archive.

  6. Unzip ore-server-solaris-sparc-64-1.3.1.zip or ore-server-solaris-x86-64-1.3.1.zip into an empty directory on your local system. This creates a directory containing library files, SQL scripts, and the install shell script install.sh.

  7. Run install.sh. to create objects in the SYS and RQSYS schemas.

    This script copies ORE packages to $ORACLE_HOME/R/library and R_LIBS_USER.

    The script executes rqinst.sqlwith SYSAUX and TEMP as the default and temporary tablespaces.

    The script creates all SQL objects required by Oracle R Enterprise in the RQSYS user schema. The RQSYS schema is created as a locked account with expired password and no connect privileges.

  8. Install the Oracle R Enterprise Client Supporting Packages. ore-supporting-solaris-sparc-64-1.3.1.zip (or ore-supporting-solaris-x86-64-1.3.1.zip):

    Unzip the download. Go to the directory where you unzipped the archive, and use the ORE script to install the packages.

    Run these commands for x86:

    ORE CMD INSTALL DBI_0.2-5_R_x86_64-unknown-solaris-sun.tar.gz
    ORE CMD INSTALL ROracle_1.1-8_R_x86_64-unknown-solaris-sun.tar.gz
    ORE CMD INSTALL png_0.1-4_R_x86_64-unknown-solaris-sun.tar.gz
    

    Run these commands for SPARC:

    ORE CMD INSTALL DBI_0.2-5_R_sparc_64-unknown-solaris-sun.tar.gz
    ORE CMD INSTALL ROracle_1.1-8_R_sparc_64-unknown-solaris-sun.tar.gz
    ORE CMD INSTALL png_0.1-4_R_sparc_64-unknown-solaris-sun.tar.gz
    
  9. After installation completes, create at least one user, as described in Oracle R Enterprise Users. It may be necessary to make certain GRANTs to users who perform certain tasks; see Required GRANTs.

  10. You may wish to use Oracle Wallet, especially if you plan to run scripts in light-out mode. For information, see Configure Oracle Wallet (Optional)

  11. Validate Oracle R Enterprise Installation.

Install Server on Oracle Exadata Database Machine

Oracle Exadata Database Machine is a complete preoptimized and preconfigured package of software, servers, and storage that provides an optimal solution for all database workloads. It combines Oracle Exadata Storage Server Software, Oracle Database software, and Sun hardware components to deliver extreme performance in a highly available and highly secure environment. Along with Oracle's unique clustering and workload management capabilities, the Database Machine is also well-suited for consolidating multiple databases onto a single grid.

Oracle Exadata Install Steps describe how to install Oracle R Enterprise on Oracle Exadata.

Oracle Exadata Install Steps

An Oracle Exadata Database Machine consists of several compute nodes, along with storage and other facilities. Oracle R Enterprise server must be installed on every compute node), that is on every server where the database is installed.

Follow these steps to install Oracle R Enterprise server on Oracle Exadata:

  • Install the following software on each compute node:

  • Each compute node has it's own ORACLE_HOME, ORACLE_SID, and PATH environment variable.

  • You must install the following software on each Oracle R Enterprise client, as described in Install Client:

    • Oracle R Distribution

    • Oracle R Enterprise Client packages

    • Oracle R Enterprise Client supporting packages

    The client systems must be able to communicate with the server The clients can run on Microsoft Windows, Linux, or Solaris.

Install Server on AIX

These directions describe how to install Oracle R Enterprise on IBM AIX on 64-bit platforms.

Review Before You Install the Server before you run the installation script. Make sure that all environment variables are properly set and that all required directories are present.

After the client installation completes, follow these steps to install the server:

  1. Install a Database that satisfies Oracle Database Requirements. Make sure that any required patches are installed properly. If the Database is already installed, make sure that it satisfies the requirements.

  2. Install R, as described in R Requirement.

  3. Before you start the installation, make sure that these environment variables exist and are defined properly:

    • Add $ORACLE_HOME/lib to LIBPATH

    • Add $ORACLE_HOME/bin to PATH

    • Define the variable $ORACLE_SID; it contains the SID for the database where you install ORE.

  4. You must have DBA privileges that is, you can run as oracle. The install scripts run SQL*Plus / as sysdba and write to ORACLE_HOME.

  5. Download ore-server-aix-ppc64-1.3.1.zip as described in Download Oracle R Enterprise Software.

  6. Unzip ore-server-aix-ppc64-1.3.1.zip into an empty directory on your local system. This creates a directory containing library files, SQL scripts, and the install shell script install.sh.

  7. Run install.sh. to create objects in the SYS and RQSYS schemas.

    This script copies ORE packages to $ORACLE_HOME/R/library and R_LIBS_USER.

    The script executes rqinst.sqlwith SYSAUX and TEMP as the default and temporary tablespaces.

    The script creates all SQL objects required by Oracle R Enterprise in the RQSYS user schema. The RQSYS schema is created as a locked account with expired password and no connect privileges.

  8. Install the Oracle R Enterprise Client Supporting Packages. ore-supporting-aix-ppc64-1.3.1.zip:

    Unzip the download. Go to the directory where you unzipped the archive, and use the ORE script to install the packages.

    Run these commands for x86:

    ORE CMD INSTALL DBI_0.2-5_R_ppc64-unknown-aix.tar.gz
    ORE CMD INSTALL ROracle_1.1-8_R_ppc64-unknown-aix.tar.gz
    ORE CMD INSTALL png_0.1-4_R_ppc64-unknown-aix.tar.gz
    
  9. After installation completes, create at least one user, as described in Oracle R Enterprise Users. It may be necessary to make certain GRANTs to users who perform certain tasks; see Required GRANTs.

  10. You may wish to use Oracle Wallet, especially if you plan to run scripts in light-out mode. For information, see Configure Oracle Wallet (Optional)

  11. Validate Oracle R Enterprise Installation.