5 Install Client

Typically, you install the server first and then ask your clients (database-users) to install client software and connect to the database.

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

Installation of Oracle R Enterprise consists of installing two sets of Client Packages

Installation steps depend on the platform:

Install Client on Microsoft Windows
Install Client on Linux

Client Packages

When you install Oracle R Enterprise client, you install two sets of R packages

Oracle R Enterprise Client Supporting Packages
Oracle R Enterprise Client Packages

Oracle R Enterprise Client Supporting Packages

These Open-Source R packages are installed when you install the client supporting packages for Oracle R Enterprise:

Both Oracle R Enterprise client and server require the client supporting packages. If client and server are installed on different systems, the supporting packages must be installed on both systems.

DBI provides the database interface (DBI) definition for communication between R and relational database management systems.
png is used to read and write PNG images.
ROracle provides the Oracle database interface (DBI) driver for R.

Oracle R Enterprise Client Packages

These packages are part of Oracle R Enterprise; they are installed when you install the client packages:

OREbase is the base package for Oracle R Enterprise. It provides basic functionality such as ore.attach().
OREstats provides the model framework for Oracle R Enterprise
OREgraphics provides graphics support for Oracle R Enterprise
OREeda provides linear and stepwise linear egression for Oracle R Enterprise (ore.lm() and ore.stepwise())
ORExml provides XML support for Oracle R Enterprise
OREdm build mining models using Oracle Data Mining algorithms
OREpredict make predictions using R models and database tables
ORE provides base support for Oracle R Enterprise

Load the ORE Packages

Use this command to load the ORE packages into R:

library(ORE)

Install Client on Microsoft Windows

The Oracle R Enterprise client is supported on Microsoft Windows XP or later for 64-bit architectures. The client requires R 2.15.1 for Oracle R Enterprise 1.3, R 2.13.2 for earlier versions.

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

Oracle R Enterprise Client Supporting Packages
Oracle R Enterprise Client Packages

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

After you have installed R, 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:

As described in Download Oracle R Enterprise Software, download these two zip archives:
- ore-supporting-windows-1.3.zip, the client supporting packages
- ore-client-windows-1.3.zip, the Oracle R Enterprise packages.
Unzip ore-supporting-windows-1.3.zip to your local system. This creates a top level ore-supporting-windows-1.3 directory whose subdirectory structure mimics a CRAN-like repository.
Unzip ore-client-windows-1.3.zip to your local system. This creates a top level ore-windows-1.3 directory whose subdirectory structure mimics a CRAN-like repository.
Start either 32-bit or 64-bit R 2.15.1 (or 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 can be used during the installation.
You can install both sets of R packages (supporting and client) 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.3",
                 type = "win.binary")
install.packages("ORE", repos = "file:///<ORE_PATH>/ore-client-windows-1.3",
                 type = "win.binary")
```
  where <DEP_PATH> and <ORE_PATH> are the unzip directory locations of ore-supporting-windows-1.3.zip and ore-windows-1.3.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.3\bin\windows\contrib\2.15
```
    where <DEP_PATH> is the unzip directory you used for the ore-supporting-windows-1.3.zip file.
  3. Select DBI_0.2-5.zip, ROracle_1.1-7.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.3\bin\windows\contrib\2.15
```
    where <ORE_PATH> is the directory where you unzipped the ore-windows-1.3.zip file.
  7. Select OREbase_1.3.zip, OREstats_1.3.zip, OREgraphcs_1.3.zip, OREeda_1.3.zip, ORExml_1.3.zip, OREdm_1.3.zip, OREpredict_1.3.zip, and ORE_1.3.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.15.1 for Oracle R Enterprise 1.3, R 2.13.2 for earlier versions.

This section describes how to install a client on a Linux system that does not have the server installed on it. It is not necessary to perform these steps on a Linux system that has the server installed on it.

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

Oracle R Enterprise Client Supporting Packages
Oracle R Enterprise Client Packages

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

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.

Go to Oracle Database Instant Client (http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html) for installation instructions.

Note:
You must have either Oracle Database or Oracle Instant Client installed on any Linux system where you install Oracle R Enterprise Client.
Add the path where you unzipped or installed the Oracle Instant Client libraries to your LD_LIBRARY_PATH.
Download the client supporting R packages ore-supporting-linux-x86-64-1.3.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html.

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

DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz
ROracle_1.1-7_R_x86_64-unknown-linux-gnu.tar.gz
png_0.1-4_R_x86_64-unknown-linux-gnu.tar.gz

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

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

ORE_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREbase_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREeda_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREgraphics_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREstats_1.3_R_x86_64-unknown-linux-gnu.tar.gz
ORExml_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREdm_1.3_R_x86_64-unknown-linux-gnu.tar.gz
OREpredict_1.3_R_x86_64-unknown-linux-gnu.tar.gz

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

R CMD INSTALL DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL ROracle_1.1-7_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL png_0.1-4_R_x86_64-unknown-linux-gnu.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)

Go to the directory ore-linux-x86-64-1.3. Type the following commands to install the client packages:

R CMD INSTALL ORE_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREbase_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREeda_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREgraphics_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREstats_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL ORExml_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREdm_1.3_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREpredict_1.3_R_x86_64-unknown-linux-gnu.tar.gz

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 you have completed the client install, verify the install by connecting to a database that has been enabled for Oracle R Enterprise as discussed in Start the Oracle R Enterprise Client on Linux.