2 Installation

Linux, Windows, Solaris, and/or AIX

Verify that one or more of these operating systems is installed. Oracle R Enterprise server and client are supported on

• Linux x86-64

  • Oracle Linux Release 5 Update 6 or higher

  • Red Hat Linux 5 Update 6 or higher

  To download Oracle Linux Release 5 Update 6 Media Pack for x86_64 (64 bit), go to http://www.oracle.com/us/technologies/linux/index.html).

• Microsoft Windows XP, Vista, or Windows 7, 32-bit or 64-bit

• 64-bit Solaris 10 or higher for both SPARC and x386 (Intel) platforms

• IBM AIX 5.3 or higher (64-Bit)

Oracle R Enterprise is also supported on

• Oracle Exadata running Oracle Linux or Solaris

• SPARC SuperCluster

R

On your client system, download and install R 2.13.2. You can download R from http://www.r-project.org or any source that provides R.

You must install R on both the client and the server.

The Oracle R Distribution supports Oracle Linux, Oracle Exadata, Solaris, and AIX see Oracle R Distribution.

Installation of R depends on the platform:

• Install R on Windows

• Install the Oracle R Distribution on Linux

• Install the Oracle R Distribution on Oracle Exadata

• Install R on Solaris

• Install R on AIX

Install the Oracle R Distribution on Linux

You can install R from CRAN at http://www.r-project.org or you can install the Oracle R Distribution from http://oss.oracle.com/ORD/.

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

The Oracle R Distribution is described at http://www.oracle.com/technetwork/indexes/downloads/r-distribution-1532464.html.

This section describes how to install Oracle's distribution of Open Source R on Oracle Linux or Red Hat Linux. To install the Oracle distribution on Oracle Exadata Machine, see Install the 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.1 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:

These graphics show a typical install. First dependencies are resolved:

Next the required packages are downloaded. Note that you must answer the question "Is this OK [y/n]:" with "y".

Finally, the downloads are tested and installed.

Oracle Database

Oracle R Enterprise requires Oracle 11.2 Enterprise Edition; the Oracle Database can be installed on Oracle Linux, Red Hat Linux, Solaris on SPARC or x386, SPARC SuperCluster, IBM AIX 64-bit, or Oracle Exadata running Oracle Linux or Solaris.

The 64-bit version of the database must be installed for Linux or Red Hat Linux. You can check that the proper database is installed by examining $ORACLE_HOME/bin/oracle.

In order for certain Oracle R Enterprise functionality to work properly, the Oracle Database must include the patch that fixes bug number 11678127.

You can use Oracle 11.2.0.1 or 11.2.0.2 if you install the patch that fixes bug number 11678127. For basic information about patching an Oracle Database, see Patching Oracle Databases.

Use one of these solutions to install the required patch on the system where you install the Oracle R Enterprise server:

• Download the 11.2.0.3 patch set for Enterprise Edition from My Oracle Support.

• If you do not want to install the 11.2.0.3 patch set, install one of these patches:

  • For Oracle 11.2.0.1.0: on Linux: Patch number 12598677 fixes bug number 11678127

  • For Oracle 11.2.0.2.0 on Linux: Patch number 12976544 fixes bug number 11678127

  • For Oracle 11.2.0.2 on Windows, Patch 11 fixes Bug Number 11678127

Download Oracle R Enterprise Software

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 (version 1.1), 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 on Windows 32-bit

  • Oracle R Enterprise Server Install for Oracle Database 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 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 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 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 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 (64-bit or 32-bit) of the Server software for your system.

When you download Solaris software be sure to download the correct version (SPARC or x386) for your system.

You download a zip archive for all platforms. Save the archive on your local system and unzip it.

Install Client on Microsoft Windows

The Oracle R Enterprise client is supported on Microsoft Windows XP or later for 32-bit and 64-bit architectures. The client requires R 2.13.2.

To install the client, you must install two sets of packages:

• The supporting R packages DBI, ROracle, and png

• The suite of Oracle R Enterprise packages: OREbase, OREstats, OREgraphics, OREeda, ORExml, and ORE

The downloads for Windows support both 32-bit and 64-bit architectures.

After you have installed R 2.13.2 as described in Install R on Windows, follow these steps to install the two sets of R packages for the Oracle R Enterprise Windows client:

1. As described in Download Oracle R Enterprise Software, download these two zip archives:

   • ore-supporting-windows-1.1.zip, the supporting R packages

   • ore-client-windows-1.1.zip, the Oracle R Enterprise packages.

2. Unzip ore-supporting-windows-1.1.zip to your local system. This creates a top level ore-supporting-windows-1.1 directory whose subdirectory structure mimics a CRAN-like repository.

3. Unzip ore-client-windows-1.1.zip to your local system. This creates a top level ore-windows-1.1 directory whose subdirectory structure mimics a CRAN-like repository.

4. Start either 32-bit or 64-bit R 2.13.2 from the All Programs group of the Windows Start menu. (Since the R Windows binary packages contain bundles for both 32-bit and 64-bit architectures, either architecture of R 2.13.2 can be used during the installation.)

5. You can install both sets of R packages (CRAN and ORE) from either the R Console or from the R GUI.

   • To install both sets of packages from the R Console, type

     install.packages(c("ROracle", "png"),
                      repos = "file:///<DEP_PATH>/ore-supporting-windows-1.1",
                      type = "win.binary")
     install.packages("ORE", repos = "file:///<ORE_PATH>/ore-client-windows-1.1",
                      type = "win.binary")
     

     where <DEP_PATH> and <ORE_PATH> are the unzip directory locations of ore-supporting-windows-1.1.zip and ore-windows-1.1.zip files respectively. The install.packages function calls produce the message "successfully unpacked and MD5 sums checked" for each installed package.

   • To install both sets of packages from the R GUI, follow these steps:

     1. From the main menu, select Packages then Install package(s) from local zip files

     2. Navigate to

        <DEP_PATH>\ore-supporting-windows-1.1\bin\windows\contrib\2.13
        

        where <DEP_PATH> is the unzip directory you used for the ore-supporting-windows-1.1.zip file.

     3. Select DBI_0.2-5.zip, ROracle_1.1.zip, and png_0.1-4.zip.

     4. Click Open. Each package will produce the message "successfully unpacked and MD5 sums checked" message in the R Console.

     5. From the main menu, select Packages then Install package(s) from local zip files.

     6. Navigate to

        <ORE_PATH>\ore-client-windows-1.1\bin\windows\contrib\2.13
        

        where <ORE_PATH> is the unzip directory you used for the ore-windows-1.1.zip file.

     7. Select OREbase_1.1.zip, OREstats_1.1.zip, OREgraphcs_1.1.zip, OREeda_1.1.zip, ORExml_1.1.zip, and ORE_1.1.zip.

     8. Click Open. Each package will produce the message "successfully unpacked and MD5 sums checked" message in the R Console.

After the installation completes.Install the server; then you can Start the Oracle R Enterprise Client on Microsoft Windows.

Install Client on Linux

The Oracle R Enterprise client is supported on Oracle Linux or Red Hat Linux. The client requires R-2.13.2.

To install the client you must install two sets of packages:

• The supporting R packages DBI, ROracle, and png

• The suite of Oracle R Enterprise packages: OREbase, OREstats, OREgraphics, OREeda, ORExml, and ORE

After you have installed R-2.13.2 on Linux as described in Install the Oracle R Distribution on Linux, follow these steps to install the two sets of R packages for the Oracle R Enterprise Linux 64-bit client:

1. Download Oracle Instant Client Basic Package for 64-bit from Linux from Instant Client Downloads for Linux x86-64 (http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html).

   The Oracle Instant Client includes all files required to run OCI, OCCI, and JDBC-OCI applications. The ROracle R package is an OCI application.

   Either download the zip file Instantclient-basic-linux.x64-11.2.0.3.0.zip or install from oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm.

   Install the instant client as root or oracle. If you install using the rpm, you can use this command:

   rpm -ivh <rpm_file>
   

   If you are not sure if some version of the software s already installed, use this command:

   rpm -Uvh <rpm_file>
   

2. Add the path where you unzipped or installed the Oracle Instant Client libraries to your LD_LIBRARY_PATH. Add this path to your.bashrc or .cshrc file so that the library gets loaded automatically. The library is normally $ORACLE_HOME/lib.

   Check for location of libclntsh.so for LD_LIBRARY_PATH using locate libclntsh.so.

3. Download the supporting R packages ore-supporting-linux-x86-64-1.1.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

4. Unzip ore-linux-x86-64-1.1.zip to your local system. This creates the directory ore-linux-x86-64-1.1/supporting containing these three files:

   DBI_0.2-5_R_x86_64-unknown-linux-gnu.zip
   ROracle_1.1-1_R_x86_64-unknown-linux-gnu.zip
   png_0.1-4_R_x86_64-unknown-linux-gnu.zip
   

5. Download the Oracle R Enterprise client packages ore-client-linux-x86-64-1.1.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

6. Unzip ore-client-linux-x86-64-1.1.zip to your local system. This creates the directory ore-client-linux-x86-64-1.1/client, containing these files:

   ORE_1.1_R_x86_64-unknown-linux-gnu.zip
   OREbase_1.1_R_x86_64-unknown-linux-gnu.zip
   OREeda_1.1_R_x86_64-unknown-linux-gnu.zip
   OREgraphics_1.1_R_x86_64-unknown-linux-gnu.zip
   OREstats_1.1_R_x86_64-unknown-linux-gnu.zip
   ORExml_1.1_R_x86_64-unknown-linux-gnu.zip
   

7. Go to the directory ore-supporting-linux-x86-64-1.1. Type the following commands to install the supporting R packages:

   R CMD INSTALL DBI_0.2-5_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL ROracle_1.1-1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL png_0.1-4_R_x86_64-unknown-linux-gnu.zip
   

   These commands generate the following messages to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'DBI' ...
   * DONE (DBI)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'ROracle' ...
   * DONE (ROracle)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'png' ...
   * DONE (png)
   

8. Go to the directory ore-linux-x86-64-1.1. Type the following commands to install the ORE packages:

   R CMD INSTALL ORE_1.1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL OREbase_1.1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL OREeda_1.1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL OREgraphics_1.1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL OREstats_1.1_R_x86_64-unknown-linux-gnu.zip
   R CMD INSTALL ORExml_1.1_R_x86_64-unknown-linux-gnu.zip
   

   Each command generates messages like the following to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package '<>' ...
   * DONE (<>)
   

After the installation completes. Install the server; then you can Start the Oracle R Enterprise Client on Linux. Solaris, or AIX.

Install Client on Solaris

The Oracle R Enterprise client is supported on Oracle Solaris (both SPARC and x86). The client requires R-2.13.2.

To install the client you must install two sets of packages:

• The supporting R packages DBI, ROracle, and png

• Oracle R Enterprise packages: OREbase, OREstats, OREgraphics, OREeda, ORExml, and ORE

After you have installed R-2.13.2 on Solaris as described in Install R on Solaris, follow these steps to install the two sets of R packages for the Oracle R Enterprise Solaris 64-bit client:

1. Download Oracle Instant Client Basic Package for 64-bit for Solaris from Instant Client Downloads for Solaris SPARC-64 http://www.oracle.com/technetwork/topics/sol64soft-085649.html

   or Instant Client Package - Basic for Solaris Operating System (SPARC 64-bit)

   http://www.oracle.com/technetwork/topics/sol64soft-085649.html.

   The Oracle Instant Client includes all files required to run OCI, OCCI, and JDBC-OCI applications. The ROracle R package is an OCI application.

   Either download the appropriate Instant Client zip file.

2. Add the path where you unzipped or installed the Oracle Instant Client libraries to your LD_LIBRARY_PATH.

3. Download the supporting R packages ore-supporting-solaris-sparc-64-1.1.zip (or ore-supporting-solaris-x86-64-1.1.zip) from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html

4. Unzip ore-solaris-sparc-64-1.1.zip (or ore-solaris-x86-64-1.1.zip) to your local system. This creates the directory ore-supporting-solaris-x86-64-1.1/supporting (or ore-supporting-solaris-x86-64-1.1/supporting) containing these three files:

   • DBI_0.2-5_R_sparc_64-unknown-solaris-sun.zip (or DBI_0.2-5_R_x86_64-unknown-solaris-sun.zip)

   • ROracle_1.1-1_R_sparc_64-unknown-solaris-sun.zip (or ROracle_1.1-1_R_x86_64-unknown-solaris-sun.zip)

   • png_0.1-4_R_sparc_64-unknown-solaris-sun.zip (or png_0.1-4_R_x86_64-unknown-solaris-sun.zip)

5. Download the Oracle R Enterprise client packages ore-client-solaris-sparc-64-1.1.zip (or ore-client-solaris-x86-64-1.1.zip) from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

6. Unzip ore-client-solaris-sparc-64-1.1.zip (or ore-client-solaris-x86-64-1.1.zip) to your local system. This creates the directory ore-client-solaris-sparc-64-1.1/client (or ore-client-solaris-x86-64-1.1/client) containing these six files:

   • ORE_1.1_R_sparc_64-unknown-solaris-sun.zip (or ORE_1.1_R_x86_64-unknown-solaris-sun.zip)

   • OREbase_1.1_R_sparc_64-unknown-solaris-sun.zip (or OREbase_1.1_R_x86_64-unknown-solaris-sun.zip)

   • OREeda_1.1_R_sparc_64-unknown-solaris-sun.zip (or OREeda_1.1_R_x86_64-unknown-solaris-sun.zip)

   • OREgraphics_1.1_R_sparc_64-unknown-solaris-sun.zip (or OREgraphics_1.1_R_sparc_64-unknown-solaris-sun.zip)

   • OREstats_1.1_R_sparc_64-unknown-solaris-sun.zip (or OREstats_1.1_R_x86_64-unknown-solaris-sun.zip)

   • ORExml_1.1_R_sparc_64-unknown-solaris-sun.zip (or ORExml_1.1_R_x86_64-unknown-solaris-sun.zip)

7. Go to the directory ore-supporting-solaris-sparc-64-1.1/client (or ore-supporting-solaris-x86-64-1.1/client). Type the following commands to install the supporting R packages:

   R CMD INSTALL DBI_0.2-5_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL ROracle_1.1-1_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL png_0.1-4_R_sparc_64-unknown-solaris-sun.zip
   

   or

   R CMD INSTALL DBI_0.2-5_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL ROracle_1.1-1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL png_0.1-4_R_x86_64-unknown-solaris-sun.zip
   

   These commands generate the following messages to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'DBI' ...
   * DONE (DBI)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'ROracle' ...
   * DONE (ROracle)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'png' ...
   * DONE (png)
   

8. Go to the directory ore-solaris-sparc-64-1.1/client (or ore-solaris-x86-64-1.1/client). Type the following commands to install the ORE packages:

   R CMD INSTALL ORE_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL OREbase_1.1_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL OREeda_1.1_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL OREgraphics_1.1_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL OREstats_1.1_R_sparc_64-unknown-solaris-sun.zip
   R CMD INSTALL ORExml_1.1_R_sparc_64-unknown-solaris-sun.zip
   

   or

   R CMD INSTALL ORE_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL OREbase_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL OREeda_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL OREgraphics_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL OREstats_1.1_R_x86_64-unknown-solaris-sun.zip
   R CMD INSTALL ORExml_1.1_R_x86_64-unknown-solaris-sun.zip
   

   Each command generates messages like the following ones to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package '<>' ...
   * DONE (<>)
   

After the client installation completes, install the server; then you can Start the Oracle R Enterprise Client on Linux. Solaris, or AIX.

Install Client on AIX

The Oracle R Enterprise client is supported on IBM AIX 5.3 or higher on POWER Systems (64-Bit). The client requires R-2.13.2.

To install the client you must install two sets of packages:

• The supporting R packages DBI, ROracle, and png

• Oracle R Enterprise packages: OREbase, OREstats, OREgraphics, OREeda, ORExml, and ORE

After you have installed R-2.13.2 on AIX as described in Install R on AIX, follow these steps to install the two sets of R packages for the Oracle R Enterprise AIX 64-bit client:

1. Download Oracle Instant Client Basic Package for 64-bit AIX from Instant Client Downloads for AIX http://www.oracle.com/technetwork/topics/aix5lsoft-098883.html

   The Oracle Instant Client includes all files required to run OCI, OCCI, and JDBC-OCI applications. The ROracle R package is an OCI application.

2. Add the path where you unzipped or installed the Oracle Instant Client libraries to your LIBPATH.

3. Download the supporting R packages ore-supporting-aix-ppc64-1.1.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html

4. Unzip ore-supporting-aix-ppc64-1.1.zip to your local system. This creates the directory supporting containing these three files:

   • DBI_0.2-5_R_ppc64-unknown-aix.tar.gz

   • ROracle_1.1-2_R_ppc64-unknown-aix.tar.gz

   • RUnit_0.4.26_R_ppc64-unknown-aix.tar.gz

   • png_0.1-4_R_ppc64-unknown-aix.tar.gz

5. Download the Oracle R Enterprise client packages ore-client-aix-ppc64-1.1.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

6. Unzip ore-client-aix-ppc64-1.1.zip to your local system. This creates the directory client containing these six files:

   • ORE_1.1_R_ppc64-unknown-aix.tar.gz

   • OREbase_1.1_R_ppc64-unknown-aix.tar.gz

   • OREeda_1.1_R_ppc64-unknown-aix.tar.gz

   • OREgraphics_1.1_R_ppc64-unknown-aix.tar.gz

   • OREstats_1.1_R_ppc64-unknown-aix.tar.gz

   • ORExml_1.1_R_ppc64-unknown-aix.tar.gz

7. Go to the directory supporting. Type the following commands to install the supporting R packages:

   R CMD INSTALL DBI_0.2-5_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL RUnit_0.4.26_R_ppc64-unknown-aix.tar.gz 
   R CMD INSTALL ROracle_1.1-2_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL png_0.1-4_R_ppc64-unknown-aix.tar.gz
   

   These commands generate the following messages to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'DBI' ...
   * DONE (DBI)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'ROracle' ...
   * DONE (ROracle)
   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package 'png' ...
   * DONE (png)
   

8. Go to the directory client. Type the following commands to install the ORE packages:

   R CMD INSTALL ORE_1.1_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL OREbase_1.1_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL OREeda_1.1_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL OREgraphics_1.1_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL OREstats_1.1_R_ppc64-unknown-aix.tar.gz
   R CMD INSTALL ORExml_1.1_R_ppc64-unknown-aix.tar.gz
   

   Each command generates messages like the following ones to confirm successful installation of the packages:

   * installing to library '<Your $R_HOME directory> /library'
   * installing *binary* package '<>' ...
   * DONE (<>)
   

After the client installation completes, install the server; then you can Start the Oracle R Enterprise Client on Linux. Solaris, or AIX.

Install the Server

This section describes how to install the Oracle R Enterprise server on Windows, Linux, Solaris, and AIX.

Install the server as follows:

1. Make sure that the Prerequisites for Windows, Linux, Solaris, or AIX are satisfied.

2. You must install the client before you can run Oracle R Enterprise. You can Install Client on Microsoft Windows, Install Client on Linux, or Install Client on AIX.

3. Make sure that Oracle Database is installed on the system where you plan to install the server. Make sure that any required patches are installed properly. Oracle R Enterprise server is installed in an Oracle Database, so an appropriate version of the Database must be installed before you install Oracle R Enterprise server.

4. Make sure that all of the requirements in Before You Install the Server are satisfied.

5. Follow the directions in Install Server on Microsoft Windows, Install Server on Linux, Install Server on Solaris or Install Server on AIX to install the server.

The install script creates Administrative Roles that you may need to grant to users who perform certain tasks.

After the install completes, you can Create Users.

After the server installation successfully completes, you can Start the Oracle R Enterprise Client on Microsoft Windows or Start the Oracle R Enterprise Client on Linux. Solaris, or AIX. Once the client has started, you can start Using Oracle R Enterprise.

Start the Oracle R Enterprise Client on Microsoft Windows

After the server is installed, you can launch the client.

To launch the Oracle R Enterprise client in a running session of R 2.13.2, execute the following R code from the R Console. Before you execute the code, modify the connection information (user, sid, host, password, and port) for the database where the R Sever is installed:

# Load ORE packages and dependencies
# DBI, ROracle, OREbase, MASS, OREstats,
# OREgraphics, OREeda, ORExml, ORE
library(ORE)
 
# Connect to Oracle RDBMS
# Change the connection information below
ore.connect(user = "<USERNAME>",
            sid = "<SID>",
            host = "<HOST>",
            password = "<PASSWORD>",
            port = PORTNUMBER
            all = TRUE)

ore.connect can now use Oracle Wallet.

After you set up Oracle Wallet, as described in Configure Oracle Wallet (Optional), you can connect as follows:

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

ore_wallet is a connect string that has been registered with the Wallet.

As with all R commands, this code can be used during the initialization of an R session.

For more information on the initialization sequence of R on startup, type help(Startup) in the R Console.

Specify ore.connect in an embedded R function, otherwise all embedded R scripts automatically go to the same schema.

For more information about database connectivity, see Connect to an Oracle Database.

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

After the server is installed, you can launch the client.

Before you launch Oracle R Enterprise client, add these paths to the LD_LIBRARY_PATH environment variable:

1. The path where Oracle Instant Client libraries are installed. Otherwise loading of ROracle package will fail.

2. The path for the shared libraries libR.so, libRblas.so, and libRlapack.so from the installation of R-2.13.2

Start R-2.13.2 from your favorite Linux shell. Next use ore.connect to connect to the Oracle Database where the server resides.

Launch the Oracle R Enterprise client by executing, after modifying the connection information (user, sid, host, password, and port), the following R code from the R Console:

# Load ORE packages and dependencies
# DBI, ROracle, OREbase, MASS, OREstats,
# OREgraphics, OREeda, ORExml, ORE
library(ORE)
 
# Connect to Oracle RDBMS
# Change the connection information below
ore.connect(user = "<USERNAME>",
            sid = "<SID>",
            host = "<HOST>",
            password = "<PASSWORD>",
            port = PORTNUMBER
            all = TRUE)
 

Your Oracle Database Administrator can provide you with suitable values for USERNAME, SID, HOST, PASSWORD, and PORT. These values provide connection information for the database.

ore.connect can now use Oracle Wallet.

After you set up Oracle Wallet, as described in Configure Oracle Wallet (Optional), you can connect as follows:

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

ore_wallet is a connect string that has been registered with the Wallet.

As with all R commands, this code can be used during the initialization of an R session. For example, you can add the following lines of code, with modified connection information, to the Rprofile.site file located below the top-level R-2.13.2 installation directory <R_HOME>\etc\Rprofile.site:

library(ORE)
 
# Change the following connection settings:
user     <- "scott"
password <- "tiger"
sid      <- "mysid"
host     <- "myhost"
port     <- 1521
all      <- TRUE
 
cat("Connecting to ORE\n")
cat("    User:", user, "\n")
cat("    SID: ", sid, "\n")
cat("    Host:", host, "\n")
ore.connect(user, sid, host, password, port, all)

For more information on the initialization sequence of R on startup, type help(Startup) in the R Console.

For more information about database connectivity, see Connect to an Oracle Database.

Connect to an Oracle Database

Oracle R Enterprise includes the following R functions that enable transparent access to Oracle Database tables and views:

• ore.attach(USER, SID, host, password) establishes a database connection using the schema or user name, the database SID, machine hostname, and password, and creates an environment that maps database table names to R objects (ore.frame) from the schema referenced in the database connection.

  At this time, views are not mapped.

  If you use the all parameter of ore.connect when you attach to a database, ore.attach is executed automatically.

• ore.sync() synchronizes with your schema (account) in the Oracle Database. ore.connect can perform this command.

  If you use the all parameter of ore.connect when you attach to a database, ore.sync is executed automatically.

• ore.detach("SCHEMA_NAME") detaches from the schema.

• ore.ls() lists all objects in the schema you are currently connected to.

Objects created by Oracle R Enterprise are identified with the ore prefix. Pick any object returned by ore.ls() and type either class(OBJECTNAME) or class(OBJECTNAME$COLUMN_NAME).

For example,

R> class(NARROW)
[1] "ore.frame"
attr(,"package")
[1] "OREbase"

The prefix ore is applied to the class names. This indicates that the object is an Oracle R Enterprise created object that holds metadata (instead of contents) of the corresponding object in Oracle Database.

Oracle R Enterprise Samples

Oracle R Enterprise is shipped with a collection of examples that illustrate how to use Oracle R Enterprise. The examples are shipped as demos included in the ORE package. For more information about the examples, see List of Examples.

Troubleshoot the Installation

The installation script creates a log file in each folder (client, data and server). Make sure that you look at each of the log files even if the installation reports success. Search the log file for ERROR.

If you cannot resolve the problems, request help from Oracle Support or from the Oracle R Enterprise discussion forum.