2 Installation

Oracle R Distribution

Oracle R Distribution is Oracle's free distribution of the open source R environment for Linux, Solaris, and AIX.

It is recommended that you use Oracle R Distribution with Oracle R Enterprise for these reasons:

• Oracle R Distribution has been enhanced for faster performance by taking advantage of hardware specific math library implementations.

• Oracle R Distribution has been compiled with the flags that are required by Oracle R Enterprise.

• Oracle offers support for users of Oracle R Distribution on Linux, AIX. and Solaris 64 bit (SPARC and Intel) platforms.

For information about Oracle R Distribution, including an installation guide and download sites, go to http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

Install R on Windows

Follow these steps to install R 2.13.2 on Windows:

1. Go to http://www.r-project.org; click CRAN under the heading Download, Packages.

2. Select a CRAN Mirror.

3. Click Download R for Windows.

4. Click base.

5. Under the heading Other builds, click Previous releases in the third bullet.

6. Click R 2.13.2 (September, 2011) to start the download.

When the download completes, double click R-2.13.2-win.exe to launch the Windows installer for R. Follow the instructions to complete the installation.

It is strongly recommended that you perform a full R installation on 64-bit Windows platforms, so that 64-bit R is installed. (The full R install for 64-bit Windows installs both 32-bit and 64-bit R.) The Oracle R Enterprise 64-bit Windows Server requires 64-bit R.

Install Oracle R Distribution on Linux

You can install R from CRAN at http://www.r-project.org or you can install Oracle R Distribution. If you install from CRAN, be sure to download R 2.13.2 (September, 2011).

It is recommended that you install Oracle R Distribution because it has been compiled with the correct flags for Oracle R Enterprise.

For an installation guide and download sites for Oracle R Distribution, go to http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

This section describes how to install Oracle R Distribution on Oracle Linux or Red Hat Linux. To install Oracle R Distribution on Oracle Exadata Machine, see Install Oracle R Distribution on Oracle Exadata.

Go to http://public-yum.oracle.com/ and follow these steps to install R:

1. Install the yum repos as follows:

   cd /etc/yum.repos.d
   wget http://public-yum.oracle.com/public-yum-el5.repo
   

2. Open a text editor on the file just downloaded, /etc/yum.repos.d/public-yum-el5.repo, and set "enabled=1" for [ol5_u6_base] and [el5_addons].

3. This step is optional.

   Type the following commands in a shell to check that your yum repository is configured correctly:

   sudo yum repolist
   

   The output should look like this:

   el5_addons                             |  951 B     00:00     
   ol5_u6_base                             | 1.2 kB     00:00     
   repo id              repo name                                status
   base                 Red Hat Linux - Base                     enabled: 3,024
   el5_addons           Enterprise Linux 5 - x86_64 - addons     enabled:    93
   ol5_u6_base          Oracle Linux 5 - U6 - x86_64 - base      enabled: 4,551
   

   Make sure that both the el5_addons and ol5_u6_base repos are listed. The list of repos can be different depending on the Linux version and current user's configuration of yum.

4. To install R, use the following command:

   sudo yum install R.x86_64
   

If the installation is successful, you should see the following messages. The list of required packages may be longer (if you install ORE on Oracle Exadata) or shorter depending on your specific Linux environment and packages installed prior to this R installation.

Make sure to look for the keywords Dependencies Resolved.

Install Oracle R Distribution on Oracle Exadata

Oracle R Distribution is recommend for Oracle Exadata. For an installation guide and download sites for Oracle R Distribution, go to http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

Using http://public-yum.oracle.com/ is the recommended way to install R on Oracle Exadata.

If you cannot use http://public-yum.oracle.com/, you can follow these steps to install R using RPMs.

The required RPMs are in one of these locations

• http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/5/base/x86_64/

• The three libMath RPMs libSM-1.0.1-3.1.x86_64.rpm, libRmath-static-2.13.2-4.el5.x86_64.rpm, and libRmath-2.13.2-4.el5.x86_64.rpm are in http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/

Follow these steps to install Oracle R Distribution on Oracle Exadata:

1. Make sure that the following RPMs are installed. If any are missing, download and install them:

   rpm -Uvh libsmi-devel-0.4.5-2.el5.x86_64.rpm
   rpm -Uvh libsmi-0.4.5-2.el5.x86_64.rpm
   rpm -Uvh libSM-devel-1.0.1-3.1.x86_64.rpm
   rpm -Uvh libsmbclient-devel-3.0.33-3.28.el5.x86_64.rpm
   rpm -Uvh libsmbclient-3.0.33-3.28.el5.x86_64.rpm
   rpm -Uvh libSM-1.0.1-3.1.x86_64.rpm
   rpm -Uvh libRmath-static-2.13.2-4.el5.x86_64.rpm
   rpm -Uvh libRmath-devel-2.13.2-4.el5.x86_64.rpm
   rpm -Uvh libRmath-2.13.2-4.el5.x86_64.rpm
   rpm -Uvh libpng-1.2.10-7.1.el5_3.2.x86_64.rpm
   rpm -Uvh libjpeg-6b-37.x86_64.rpm
   rpm -Uvh libICE-devel-1.0.1-2.1.x86_64.rpm
   rpm -Uvh libICE-1.0.1-2.1.x86_64.rpm
   rpm -Uvh libgssapi-0.10-2.x86_64.rpm
   rpm -Uvh libgsf-1.24.1-6.1.x86_64.rpm
   rpm -Uvh libFS-1.0.0-3.1.x86_64.rpm
   rpm -Uvh libfontenc-1.0.2-2.2.el5.x86_64.rpm
   

2. Download and install these RPMs in the order in which they are listed:

   rpm -Uvh cairo-1.2.4-5.el5.x86_64.rpm
   rpm -Uvh libtiff-3.8.2-7.el5_3.4.x86_64.rpm
   rpm -Uvh bitstream-vera-fonts-1.20-7.noarch.rpm
   rpm -Uvh pango-1.24.9-6.el5.x86_64.rpm
   rpm -Uvh cups-libs-1.2.7-18.el5.x86_64.rpm
   rpm -Uvh paps-0.6.6-19.el5.x86_64.rpm
   rpm -Uvh atk-1.22.2-1.fc6.x86_64.rpm
   rpm -Uvh hicolor-icon-theme-0.9-2.1.noarch.rpm
   rpm -Uvh gtk2-2.10.4-20.el5.x86_64.rpm
   rpm -Uvh poppler-0.5.4-4.4.el5_4.11.x86_64.rpm
   rpm -Uvh poppler-utils-0.5.4-4.4.el5_4.11.x86_64.rpm
   rpm -Uvh dbus-python-0.70-9.el5_4.x86_64.rpm
   rpm -Uvh avahi-0.6.16-7.el5.x86_64.rpm
   rpm -Uvh avahi-compat-libdns_sd-0.6.16-7.el5.x86_64.rpm
   rpm -Uvh cups-1.2.7-18.el5.x86_64.rpm
   rpm -Uvh netpbm-10.35.58-8.el5.x86_64.rpm
   rpm -Uvh desktop-file-utils-0.10-7.x86_64.rpm
   rpm -Uvh dialog-1.0.20051107-1.2.2.x86_64.rpm
   rpm -Uvh ed-0.2-39.el5_2.x86_64.rpm
   rpm -Uvh tetex-fonts-3.0-33.8.el5.x86_64.rpm
   rpm -Uvh tetex-3.0-33.8.el5.x86_64.rpm
   rpm -Uvh tetex-dvips-3.0-33.8.el5.x86_64.rpm
   rpm -Uvh libFS-1.0.0-3.1.x86_64.rpm
   rpm -Uvh xorg-x11-xfs-utils-1.0.2-4.x86_64.rpm
   rpm -Uvh xorg-x11-font-utils-7.1-2.x86_64.rpm
   rpm -Uvh ttmkfdir-3.0.9-23.el5.x86_64.rpm
   rpm -Uvh chkfontpath-1.20.1-1.2.x86_64.rpm xorg-x11-xfs-1.0.2-4.x86_64.rpm
   rpm -Uvh urw-fonts-2.3-6.1.2.noarch.rpm
   rpm -Uvh ghostscript-8.15.2-9.11.el5.x86_64.rpm  ghostscript-fonts-5.50-13.1.2.noarch.rpm
   rpm -Uvh netpbm-progs-10.35.58-8.el5.x86_64.rpm
   rpm -Uvh tetex-latex-3.0-33.8.el5.x86_64.rpm
   

3. Finally download and install the core RPM for R:

   rpm -Uvh R-core-2.13.2-4.el5.x86_64.rpm
   

Install R on Solaris

R for Solaris is available in two ways:

• Oracle R Distribution is available for Solaris. Oracle R Distribution is compiled with the flags required for Oracle R Enterprise.

  For an installation guide and download sites for Oracle R Distribution, go to http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

• Open-source R can be configured and built for Solaris using source code from CRAN. See the R Installation and Administration guide http://cran.r-project.org/doc/manuals/R-admin.pdf for details.

  If you install from CRAN, be sure to download R 2.13.2 (September, 2011).

Install R on AIX

R for IBM AIX is available in two ways:

• Oracle R Distribution is available for AIX. Oracle R Distribution is compiled with the flags required for Oracle R Enterprise.

  For an installation guide and download sites for Oracle R Distribution, go to http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

• Open-source R can be configured and built for AIX using source code from CRAN. See the R Installation and Administration manual http://cran.r-project.org/doc/manuals/R-admin.pdf for details.

  If you install from CRAN, be sure to download R 2.13.2 (September, 2011).

Use Oracle Universal Installer (Server Only)

If you are connecting to Oracle Database 12c Release 1 (12.1), Oracle Universal Installer automatically copies the files required to install Oracle R Enterprise server to the directory

ORACLE_HOME/R/ORE1_2

All files to install the server are in this directory.

You must download client files, even if you install the client on the same system as the server, as described in Download from Oracle Technology Network.

Download from Oracle Technology Network

Oracle R Enterprise software is available for download from Oracle Technology Network. You must have a free Oracle Technology Network account in order to down load software. See http://www.oracle.com/technetwork/community/join/why-join/index.html for information.

To download software for Oracle R Enterprise, go to Oracle R Enterprise Downloads at http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

Before you can download any files, you must accept the OTN License Agreement.

To download the latest software, click the links for your platform:

• Microsoft Windows:

  • Oracle R Enterprise Client Packages for Windows Platform (includes client packages for both 32-bit and 64-bit architectures)

  • Oracle R Enterprise Client Supporting Packages for Windows Platform (includes client supporting packages for both 32-bit and 64-bit architectures)

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on Windows 32-bit

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on Windows 64-bit

• Linux 64-bit:

  • Oracle R Enterprise Client Packages for Linux 64-bit Platform

  • Oracle R Enterprise Client Supporting Packages for Linux 64-bit Platform

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on Linux 64-bit

• Solaris SPARC 64-bit

  • Oracle R Enterprise Client Packages for Solaris SPARC 64-bit Platform

  • Oracle R Enterprise Client Supporting Packages for Solaris SPARC 64-bit Platform

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on Solaris SPARC 64-bit

• Solaris x386 64-bit

  • Oracle R Enterprise Client Packages for Solaris x386 64-bit Platform

  • Oracle R Enterprise Client Supporting Packages for Solaris x386 64-bit Platform

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on Solaris x386 64-bit

• IBM AIX 5.3 or higher on POWER Systems (64-Bit)

  • Oracle R Enterprise Client Packages for AIX 64-bit Platform

  • Oracle R Enterprise Client Supporting Packages for AIX 64-bit Platform

  • Oracle R Enterprise Server Install for Oracle Database 12c Release 1 (12.1) on AIX 64-bit

You must download the client or server software plus the supporting packages; for example to install the Client on Microsoft Windows, you must download Oracle R Enterprise Client Packages for Windows Platform and Oracle R Enterprise Client Supporting Packages for Windows Platform.

Click the link for the software that you require. Sign on using your Oracle Technology Network login.

When you download Windows software be sure to download the correct version of the Server software for your system.

When you download Solaris software be sure to download the correct version for your system.

A zip archive is downloaded for all platforms. Save the archive on your local system and unzip it.

Before You Install the Server

The install scripts for the Oracle R Enterprise server require that certain environment variables are properly set.

Important: Before you start installation, make sure that:

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

  • 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.

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

  • 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 with DBA privileges before you run the install script.

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

• You can run R. This usually means that the R executable in your PATH environment variable.

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.

The installation scripts work as follows:

1. Before the Oracle R Enterprise server install starts, it checks for the presence of an R installation in the form of environment variable R_HOME. Make sure that R_HOME exists and is set properly.

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 the 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, then the installer expects to find a user name called 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 the R installation.

You can now create Oracle R Enterprise users as described in Create Users.

Note that the installation creates Administrative Roles that are required for users to performs certain tasks. You may have to grant these roles to users.

Install Server on Microsoft Windows

These directions describe how to install Oracle R Enterprise on Microsoft Windows XP or later for the 32-bit or 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

   • 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. For Oracle Database 12c Release 1 (12.1), Oracle Universal Installer copies the installation files to $ORACLE_HOME/R/ORE_1_2.

   To install the server, open a command window and navigate to $ORACLE_HOME/R/ORE_1_2, and execute install.bat.

4. Alternatively, you can download the software, as described in Download Oracle R Enterprise Software. If you download the software, follow these steps:

   1. Unzip the download.

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

   3. Execute install.bat.

5. 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.

6. After installation completes, create at least one user, as described in Create Users. It may be necessary to grant Administrative Roles to users who perform certain tasks.

7. Install the R supporting packages ore-supporting-windows-1.2.zip if they are not installed already. For directions, see Install Client on Microsoft Windows.

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

   Finally Start the Oracle R Enterprise Client on Microsoft Windows or Start the Oracle R Enterprise Client on Linux, Solaris, or AIX.

9. After you have installed both client and server, Validate Oracle R Enterprise Installation.

Install Server on Linux

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

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. Before you start the installation, make sure that these environment variables exist and are defined properly:

   • Set the environment variable R_HOME. In the bash shell use

     export R_HOME=/usr/lib64/R
     

   • Add $R_HOME to LD_LIBRARY_PATH. In the bash shell use

     export LD_LIBRARY_PATH=$RHOME/lib:$LD_LIBRARY_PATH
     

   • Add $R_HOME/bin to PATH. In the bash shell, use

     export  PATH=/usr/lib64/R:$PATH
     

   • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH

   • Add $ORACLE_HOME/bin to PATH

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

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. For Oracle Database 12c Release 1 (12.1), Oracle Universal Installer copies the installation files to $ORACLE_HOME/R/ORE_1_2.

   To install the server, navigate to $ORACLE_HOME/R/ORE_1_2, and execute install.sh.

4. Alternatively, you can download the software, as described in Download Oracle R Enterprise Software. If you download the software, follow these steps:

   1. Unzip the download.

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

   3. Execute install.sh.

5. This script copies several libraries to $ORACLE_HOME/lib.

   The script executes rqinst.sql with 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.

6. After installation completes, create at least one user as described in Create Users. It may be necessary to grant Administrative Roles to users who perform certain tasks.

7. Install the R supporting packages ore-supporting-linux-x86-64-1.2.zip, if they are not installed already. For directions, see Install Client on Linux.

8. 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)

   Finally Start the Oracle R Enterprise Client on Microsoft Windows or Start the Oracle R Enterprise Client on Linux, Solaris, or AIX.

9. After you have installed both client and server, 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. Before you start the installation, make sure that these environment variables exist and are defined properly:

   • Add $R_HOME to LD_LIBRARY_PATH

   • Add $R_HOME/bin to PATH

   • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH

   • Add $ORACLE_HOME/bin to PATH

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

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. Before you start the installation, make sure that these environment variables exist and are defined properly:

   • Add $R_HOME to LD_LIBRARY_PATH

   • Add $R_HOME/bin to PATH

   • Add $ORACLE_HOME/lib to LD_LIBRARY_PATH

   • Add $ORACLE_HOME/bin to PATH

   • Define 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. For Oracle Database 12c Release 1 (12.1), Oracle Universal Installer copies the installation files to $ORACLE_HOME/R/ORE_1_2.

   To install the server, navigate to $ORACLE_HOME/R/ORE_1_2, and execute install.sh.

6. Alternatively, you can download the software, as described in Download Oracle R Enterprise Software. If you download the software, follow these steps:

   1. Unzip the download.

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

   3. Execute install.sh.

7. install.sh copies several libraries to $ORACLE_HOME/lib.

   The script executes rqinst.sql with 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. After installation completes, create at least one user, as described in Create Users. It may be necessary to grant Administrative Roles to users who perform certain tasks.

9. Install the R supporting packages ore-supporting-solaris-sparc-64-1.2.zip (or ore-supporting-solaris-x86-64-1.2.zip), if they are not installed already. For directions, see Install Client on Solaris.

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).

    Finally Start the Oracle R Enterprise Client on Microsoft Windows or Start the Oracle R Enterprise Client on Linux, Solaris, or AIX.

11. After you have installed both client and server, Validate Oracle R Enterprise Installation.

Install Server on AIX

These directions describe how to install Oracle R Enterprise on IBM AIX on POWER Systems (64-Bit).

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

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.

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

   • Add $R_HOME to LD_LIBPATH

   • Add $R_HOME/bin to PATH

   • Add $ORACLE_HOME/lib to LIBPATH

   • Add $ORACLE_HOME/bin to PATH

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

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. For Oracle Database 12c Release 1 (12.1), Oracle Universal Installer copies the installation files to $ORACLE_HOME/R/ORE_1_2.

   To install the server, navigate to $ORACLE_HOME/R/ORE_1_2, and execute install.sh.

4. Alternatively, you can download the software, as described in Download Oracle R Enterprise Software. If you download the software, follow these steps:

   1. Unzip the download.

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

   3. Execute install.sh.

5. install.sh copies several libraries to $ORACLE_HOME/lib.

   The script executes rqinst.sql with 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.

6. After installation completes, create at least one user, as described in Create Users. It may be necessary to grant Administrative Roles to users who perform certain tasks.

7. Install the R supporting packages ore-supporting-aix-ppc64-1.2.zip, if they are not installed already. For directions, see Install Client on AIX.

8. 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).

   Finally Start the Oracle R Enterprise Client on Microsoft Windows or Start the Oracle R Enterprise Client on Linux, Solaris, or AIX.

9. After you have installed both client and server, Validate Oracle R Enterprise Installation.

Administrative Roles

The installation creates an administrative role RQADMIN and a user role RQROLE. The roles are used as follows:

• Oracle R Enterprise users who are allowed to create R scripts that execute using the database embedded R engine must be granted the RQADMIN role.

• Oracle R Enterprise users who are allowed to execute R code via SQL queries must be granted the RQROLE role.

Create Users

For an example of how to create an Oracle R Enterprise user, see.

• demo_user.sh (for Linux, Solaris or AIX))

• demo_user.bat (for Windows)

For each Oracle R Enterprise user, these steps are required to fully enable the user on the database as demonstrated in the demo_user.sh script.

Start SQL*Plus as sysdba; then follow these steps:

1. Create a new user with desired quota as described in demo_user.sh or demo_user.bat. If you have already created a user, go to the next step.

2. Suppose that the name of the user is new_user. Execute this command:

   grant create session, rqrole, rqadmin to new_user 
   

   This command grants both Administrative Roles to new_user.

3. Execute this command:

   grant execute on rqsys.rqGroupEvalImpl to new_user
   

4. Create all the synonyms for new_user listed in rquser.sql. Required commands are in rquser.sql.

   (A synonym is an alias for a schema object. You can use synonyms to provide data independence and location transparency.)

5. Repeat these steps for each Oracle R Enterprise user.

Configure Oracle Wallet (Optional)

Oracle Wallet provides secure storage of user passwords and client certificates. An Oracle Wallet provides a secure way for embedded R scripts to avoid storing passwords in the script.

Follow these steps to configure Oracle Wallet with Oracle R Enterprise:

1. Configure Oracle Wallet and store the username and password. The details are in the wallet documentation in the Oracle Database Security Guide.

2. Add the connection string used to create the wallet entry (for example, "mydb12c_test") to map to the DB instance connection string in tnsnames.ora (Change the host name to be your database machine name and SID to be the SID of your database.):

   mydb12c_test =
         (DESCRIPTION =
            (ADDRESS =
               (PROTOCOL = TCP)
               (HOST = <host_name>)
               (PORT = 1521)
            )
            (CONNECT_DATA = (sid=<SID>))
         )
   

   After you complete the steps, you can just use the connect_string to connect to the database:

    ore.connect(conn_string = "mydb12c_test", all = TRUE)