Oracle® R Enterprise Installation and Administration Guide Release 1.3 for Windows, Linux, Solaris, and AIX E36763-09 |
|
|
PDF · Mobi · ePub |
Typically, you install the server first and then ask your clients (database users) to install client software and connect to the database. The client and server can run on different platforms; for example a client on Windows can connect to a server on Linux.
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:
When you install Oracle R Enterprise client, you install two sets of R 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.
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
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 and 1.3.1, R 2.13.2 for earlier versions of Oracle R Enterprise.
To install the client, you must install two sets of packages:
After you have installed R, as described in Install R on Windows, follow these steps to install the two sets of R packages for Oracle R Enterprise Windows client:
As described in Download Oracle R Enterprise Software, download these two zip archives:
ore-supporting-win-x86_64-1.3.1.zip
, the client supporting packages
ore-client-win-x86_64_1.3.1.zip
, the Oracle R Enterprise packages.
Unzip ore-supporting-win-x86_64-1.3.1.zip
to your local system. This creates the supporting
directory.
Unzip ore-client-win-x86_64-x86_64_1.3.1.zip
to your local system. This creates the client
directory.
Start 64-bit R 2.15.1 (or R 2.13.2) from the All Programs group of the Windows Start menu.
You can install both sets of R packages (supporting and client) from the R Console, from the R GUI, or from the command window.
To install both sets of packages from the R Console, follow these steps:
To install the client supporting packages, 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)
where <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.
To install the client packages, use these commands:
nstall.packages("<dep path>/client/ORE_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREbase_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREdm_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREeda_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREgraphics_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREpredict_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/OREstats_1.3.1.zip", repos=NULL) install.packages("<dep path>/client/ORExml_1.3.1.zip", repos=NULL)
where <dep path>
is the directory where you unzipped ore-client-win-x86_64-1.3.1.zip
.
Each package install produces the message "successfully unpacked and MD5 sums checked" in the R Console.
To install both sets of packages from the R GUI, follow these steps:
From the main menu, select Packages then Install package(s) from local zip files
Navigate to
<DEP_PATH>\supporting
where <DEP_PATH>
is the directory where you unzipped ore-supporting-win-x86_64-1.3.1.zip
.
Select all of the files in the directory, that is, select DBI_0.2-5.zip
, ROracle_1.1-8.zip
, and png_0.1-4.zip
.
Click Open. Each package install produces the message "successfully unpacked and MD5 sums checked" in the R Console.
From the main menu, select Packages then Install package(s) from local zip files.
Navigate to
<ORE_PATH>\client
where <ORE_PATH>
is the directory where you unzipped the ore-client-win-x86_64_1.3.1.zip
.
Select all of the files in the directory, that is, select OREbase_1.3.1.zip
, OREstats_1.3.1.zip
, OREgraphcs_1.3.1.zip
, OREeda_1.3.1.zip
, ORExml_1.3.1.zip
, OREdm_1.3.1.zip
, OREpredict_1.3.1.zip
, and ORE_1.3.1.zip
.
Click Open. Each package install produces the message "successfully unpacked and MD5 sums checked"in the R Console.
To install packages from the command window, follow these steps:
Open a command window.
Go to the supporting
directory, the directory where you unzipped ore-supporting-win-x86_64-1.3.1.zip
, and type these commands:
R CMD INSTALL ROracle_1.1-8.zip R CMD INSTALL DBI_0.2-5.zip R CMD INSTALL png_0.1-4.zip
Each command generates messages indicating that the package is successfully installed. This example illustrates the messages for the package ORE:
* installing to library 'C:/Program Files/R/R-2.13.2/library' package 'ORE' successfully unpacked and MD5 sums checked
Go to the client
directory, the directory where you unzipped ore-client-win-x86_64-x86_64_1.3.1.zip
, and type these commands:
R CMD INSTALL OREbase_1.3.1.zip R CMD INSTALL OREstats_1.3.1.zip R CMD INSTALL OREgraphcs_1.3.1.zip R CMD INSTALL OREeda_1.3.1.zip R CMD INSTALL ORExml_1.3.1.zip R CMD INSTALL OREdm_1.3.1.zip R CMD INSTALL OREpredict_1.3.1.zip R CMD INSTALL ORE_1.3.1.zip
Each command generates messages indicating that the package is successfully installed, as for the supporting packages.
After you install the server, you can Start Oracle R Enterprise Client on Microsoft Windows.
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 and 1.3.1, 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:
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
).
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 Oracle Instant Client libraries to your LD_LIBRARY_PATH.
Download the client supporting R packages ore-supporting-linux-x86-64-1.3.1.zip
from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html
.
Unzip ore-linux-x86-64-1.3.1.zip
to your local system. This creates the directory ore-supporting-linux-x86-64-1.3.1
containing these files:
DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz ROracle_1.1-8_R_x86_64-unknown-linux-gnu.tar.gz png_0.1-4_R_x86_64-unknown-linux-gnu.tar.gz
Download Oracle R Enterprise client packages ore-client-linux-x86-64-1.3.1.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.1.zip
to your local system. This creates the directory ore-client-linux-x86-64-1.3.1
containing these files:
ORE_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREbase_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREeda_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREgraphics_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREstats_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz ORExml_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREdm_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz OREpredict_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz
Go to the directory ore-supporting-linux-x86-64-1.3.1
. 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-8_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.1
. Type the following commands to install the client packages:
R CMD INSTALL ORE_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREbase_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREeda_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREgraphics_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREstats_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL ORExml_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREdm_1.3.1_R_x86_64-unknown-linux-gnu.tar.gz R CMD INSTALL OREpredict_1.3.1_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 Oracle R Enterprise Client on Linux, Solaris, or AIX.
The Oracle R Enterprise client is supported on Oracle Solaris. The client requires R 2.15.1 for Oracle R Enterprise 1.3 and 1.3.1, R 2.13.2 for earlier versions.
This section describes how to install a client on a Solaris system that does not have the server installed on it. It is not necessary to perform these steps on a Solaris system that has the server installed on it.
To install the client you must install two sets of packages:
After you have installed R 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 client:
Download Oracle Instant Client Basic Package for 64-bit for Solaris from Instant Client Downloads for Solaris SPARC-64 at http://www.oracle.com/technetwork/topics/sol64soft-085649.html
or Instant Client Package - Basic for Solaris Operating System (SPARC 64-bit) at
http://www.oracle.com/technetwork/topics/sol64soft-085649.html
.
Oracle Instant Client includes all files required to run OCI, OCCI, and JDBC-OCI applications. The ROracle R package is an OCI application.
Download the appropriate Instant Client zip file.
Add the path where you unzipped or installed Oracle Instant Client libraries to your LD_LIBRARY_PATH.
Download the client R packages ore-supporting-solaris-sparc-64-1.3.1.zip
for SPARC or ore-supporting-solaris-x86-64-1.3.1.zip
from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html
.
Unzip ore-solaris-sparc-64-1.3.1.zip
or ore-solaris-x86-64-1.3.1.zip
to your local system. This creates the directory ore-supporting-solaris-sparc-64-1
.3 containing these files for SPARC:
DBI_0.2-5_R_sparc_64-unknown-solaris-sun.tar.gz ROracle_1.1-8_R_sparc_64-unknown-solaris-sun.tar.gz png_0.1-4_R_sparc_64-unknown-solaris-sun.tar.gz
or the directory ore-supporting-solaris-x86-64-1.3.1
containing these files for x86:
DBI_0.2-5_R_x86_64-unknown-solaris-sun.tar.gzROracle_1.1-8_R_x86_64-unknown-solaris-sun.tar.gzpng_0.1-4_R_x86_64-unknown-solaris-sun.tar.gz
Download Oracle R Enterprise client packages ore-client-solaris-sparc-64-1.3.1.zip
or ore-client-solaris-x86-64-1.3.1.zip from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html
.
Unzip ore-client-solaris-sparc-64-1.3.1.zip
or ore-client-solaris-x86-64-1.3.1.zip
to your local system. This creates the directory ore-client-solaris-x86-64-1.3.1
containing these files for x86-64:
ORE_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREbase_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREdm_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREeda_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREgraphics_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREpredict_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz OREstats_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz ORExml_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz
or the directory ore-client-solaris-sparc-64-1.3.1
containing these files for SPARC:
ORE_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREbase_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREdm_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREeda_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREgraphics_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREpredict_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz OREstats_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz ORExml_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz
Go to the directory ore-supporting-solaris-x86-64-1.3.1
. Type the following commands to install the client supporting R packages:
R CMD INSTALL DBI_0.2-5_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALLROracle_1.1-8_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL png_0.1-4_R_x86_64-unknown-solaris-sun.tar.gz
For SPARC, go to the directory ore-supporting-solaris-sparc-64-1.3.1
. Type the following commands to install the client supporting R packages:
R CMD INSTALL DBI_0.2-5_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL ROracle_1.1-8_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL png_0.1-4_R_sparc_64-unknown-solaris-sun.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-client-solaris-x86-64-1.3.1
. Type the following commands to install the client packages:
R CMD INSTALL ORE_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREbase_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREdm_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREeda_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREgraphics_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREpredict_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREstats_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz R CMD INSTALL ORExml_1.3.1_R_x86_64-unknown-solaris-sun.tar.gz
For SPARC, go to the directory ore-client-solaris-sparc-64-1.3.1
. Type the following commands to install the client supporting R packages:
R CMD INSTALL ORE_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREbase_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREdm_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREeda_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREgraphics_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREpredict_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL OREstats_1.3.1_R_sparc_64-unknown-solaris-sun.tar.gz R CMD INSTALL ORExml_1.3.1_R_sparc_64-unknown-solaris-sun.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 Oracle R Enterprise Client on Linux, Solaris, or AIX.
The Oracle R Enterprise client is supported on IBM AIX. The client requires R 2.15.1 for Oracle R Enterprise 1.3 and 1.3.1, R 2.13.2 for earlier versions.
This section describes how to install a client on an AIX system that does not have the server installed on it. It is not necessary to perform these steps on an AIX system that has the server installed on it.
To install the client you must install two sets of packages:
After you have installed R on Solaris as described in Install R on AIX, follow these steps to install the two sets of R packages for the Oracle R Enterprise AIX client:
Download Oracle Instant Client Basic Package for AIX5L (64-bit) from Instant Client Downloads for AIX5L (64-bit) at http://www.oracle.com/technetwork/topics/aix5lsoft-098883.html
Oracle Instant Client includes all files required to run OCI, OCCI, and JDBC-OCI applications. The ROracle R package is an OCI application.
Download the Instant Client zip file.
Add the path where you unzipped or installed Oracle Instant Client libraries to your LIBPATH.
Download the supporting R package from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html
.
Unzip ore-supporting-aix-ppc64-1.3.1.zip
to your local system. This creates the directory ore-supporting-aix-ppc64-1
.3 containing these files:
DBI_0.2-5_R_ppc64-unknown-aix.tar.gz ROracle_1.1-8_R_ppc64-unknown-aix.tar.gz png_0.1-4_R_ppc64-unknown-aix.tar.gz
Download Oracle R Enterprise client packages ore-client-aix-ppc64-1.3.1.zip
from http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html
.
Unzip ore-client-aix-ppc64-1.3.1.zip
to your local system. This creates the directory ore-client-aix-ppc64-1.3.1
containing these files:
ORE_1.3.1_R_ppc64-unknown-aix.tar.gz OREbase_1.3.1_R_ppc64-unknown-aix.tar.gz OREdm_1.3.1_R_ppc64-unknown-aix.tar.gz OREeda_1.3.1_R_ppc64-unknown-aix.tar.gz OREgraphics_1.3.1_R_ppc64-unknown-aix.tar.gz OREpredict_1.3.1_R_ppc64-unknown-aix.tar.gz OREstats_1.3.1_R_ppc64-unknown-aix.tar.gz ORExml_1.3.1_R_ppc64-unknown-aix.tar.gz
Go to the directory ore-supporting-aix-x86-64-1.3.1
. Type the following commands to install the client supporting R packages:
R CMD INSTALL DBI_0.2-5_R_ppc64-unknown-aix.tar.gz R CMD INSTALL ROracle_1.1-8_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)
Go to the directory ore-client-aix-ppc64-1.3.1
. Type the following commands to install the client packages:
R CMD INSTALL ORE_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREbase_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREdm_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREeda_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREgraphics_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREpredict_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL OREstats_1.3.1_R_ppc64-unknown-aix.tar.gz R CMD INSTALL ORExml_1.3.1_R_ppc64-unknown-aix.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 Oracle R Enterprise Client on Linux, Solaris, or AIX.