This chapter explains how to install Oracle R Enterprise Server. This chapter includes these topics:
Note:
Instructions for installing Oracle R Enterprise Server on Exadata are in Chapter 5.Oracle R Enterprise Server enables an Oracle database to support an Oracle R Enterprise client.
Oracle R Enterprise Server includes the following:
The RQSYS
schema
Libraries used by Oracle Database
Oracle R Enterprise packages, which support embedded R execution
Oracle R Enterprise includes several components that must be installed separately on the server computer.
These Oracle R Enterprise Server components must be installed in this order:
Oracle Database Enterprise Edition
Oracle R Distribution or open source R
Oracle R Enterprise Server, which includes the Oracle R Enterprise packages
Oracle R Enterprise supporting packages
An illustration of the client and server components of Oracle R Enterprise is shown in Figure 1-2.
The Oracle R Enterprise Server installation script performs the following:
Verifies the environment:
Verifies the presence of an R installation
Verifies the presence of the libR.so
, libRblas.so
, and libRlapack.so
libraries in $R_HOME/lib
, where $R_HOME
is /usr/lib64/R
Verifies that $ORACLE_HOME
and $ORACLE_SID
are set
Starts SQL*Plus as sysdba and connects to the database specified in ORACLE_SID
In the database:
Determines if Oracle R Enterprise Server is already installed by querying DBA_USERS
for the user RQSYS
.
If RQSYS
is found, the installer checks the version of Oracle R Enterprise in the sys.rq_config
file. The Installer uses the version information later to install the correct PL/SQL packages.
Prompts for the location of permanent and temporary tablespaces for RQSYS
. By default, the tablespaces are created in SYSAUX
and TEMP
.
Copies Oracle R Enterprise Server libraries to $ORACLE_HOME/lib
.
Creates the RQSYS
schema, if it does not already exist.
Prompts for the RQSYS
password.
Creates objects in RQSYS
and installs the Oracle R Enterprise PL/SQL packages.
Installs the Oracle R Enterprise client packages in $ORACLE_HOME/R/library
.
The Oracle R Enterprise Server installer can run in configuration mode. When the configonly
switch is specified, the Installer configures the database for Oracle R Enterprise, but does not install the Oracle R Enterprise client packages and does not copy the Oracle R Enterprise libraries to $ORACLE_HOME/lib
.
./install.sh -configonly
If you have already performed a full installation of Oracle Enterprise Server, you can perform additional installations in configuration mode to enable other databases in the same Oracle Home for Oracle R Enterprise.
See Also:
Section 4.3 or Section 4.4 for detailed installation instructions for Oracle R Enterprise Server.Before installing Oracle R Enterprise Server, verify the following requirements:
The operating system must conform to the requirements specified in Section 1.7.
Oracle Database must be installed and configured as described in Chapter 2.
R must be installed as described in Chapter 3.
Oracle R Enterprise only runs on 64-bit operating systems. You can determine if your Windows system is 64-bit by following these steps:
Windows 7 or Windows Vista:
From Windows Control Panel, choose System.
Verify that System type is 64-bit Operating System.
Windows XP:
From the Start menu, choose My Computer.
Click Properties.
On the System tab, verify that the system is x64 Edition.
Before installing Oracle R Enterprise Server, ensure that environment variables are set as shown in Table 4-1.
Table 4-1 Environment Variable Requirements for Oracle R Enterprise Server
Platform | Environment Variable Requirement |
---|---|
all |
|
Linux |
|
Oracle Solaris |
|
IBM AIX |
|
Microsoft Windows |
|
If the PATH
, ORACLE_SID
, and ORACLE_HOME
environment variables do not exist, you must create them and assign the values specified in Table 4-1. On Windows systems, you must be an administrator to create or modify environment variables.
Follow these steps to create or modify environment variables on Windows:
Windows 7 and Windows Vista:
Right-click the Computer icon and choose Properties.
Choose Advanced system settings.
Figure 4-1 Advanced System Settings in Windows
On the Advanced tab, click Environment Variables.
Figure 4-2 Environment Variables Dialog in Windows
Click New to create a new environment variable. Click Edit to modify an existing environment variable.
Windows XP:
Right-click the My Computer icon and choose Properties.
On the Advanced tab, choose Environment Variables.
Create or modify the environment variables.
The operating system user that installs Oracle R Enterprise Server must meet the requirements described in Table 4-2.
Table 4-2 User Requirements for Oracle R Enterprise Server Installer
Platform | User Requirement |
---|---|
Linux and UNIX |
|
Microsoft Windows |
|
The Oracle R Enterprise Server installation script uses system authentication to connect to the database identified by ORACLE_HOME
and ORACLE_SID
. System authentication is based on the operating system credentials of the user instead of the database credentials.
For example, on a Linux system, the Oracle R Enterprise installation script uses this statement to start SQL*Plus without a password:
$ORACLE_HOME/bin/sqlplus / as sysdba
Membership in a special operating system group enables system authentication for Oracle Database. The operating system group is created during installation of the database, and the identity of the installer is automatically assigned to the group. The generic name for the group is OSDBA. On Linux and UNIX, the name for OSDBA is dba
. On Windows, the name for OSDBA is ora_dba
.
The user that installs Oracle R Enterprise Server must belong to OSDBA.
See Also:
"Using Operating System Authentication" in Oracle Database Administrator's Guide
"Overview of Operating System Authentication Enabled at Installation" in Oracle Database Platform Guide for Microsoft Windows
As described in "About Operating System Authentication", the Linux or UNIX user ID that runs the Oracle R Enterprise Server installation script must belong to the dba
group. Membership in the dba
group is also required for running other Oracle R Enterprise scripts on the server. On Windows, the dba
group is called ora_dba
.
To determine the group membership of your Linux or UNIX user ID, type this command:
% groups
dba othergroup
To determine the group membership of your Windows user ID:
Open Windows Control Panel.
Select Users Accounts.
Select Manage User Accounts.
On the Users tab of the User Accounts dialog, the name, domain, and group of each user account are listed. Verify that your user ID belongs to the group ora_dba
.
These installation instructions apply to the Linux and UNIX platforms described in Section 1.7.
To install Oracle R Enterprise Server on Linux or UNIX:
Ensure that your system satisfies the requirements specified in Section 4.2, "Oracle R Enterprise Server Requirements".
Ensure that your user ID has the permissions described in Section 4.2.3, "User Requirements"
Create an installation directory for the Oracle R Enterprise server components. The directory can have any name. For example:
/oreserver_install_dir
Go to the Oracle R Enterprise Downloads page on the Oracle Technology Network:
Accept the license agreement and select Oracle R Enterprise Downloads (v1.4).
Select Oracle R Enterprise Server Install for Oracle Database for your platform. Save the file in the installation directory that you created in Step 3.
/oreserver_install_dir/ore-server-platform-arch-1.4.zip
Unzip the file as follows:
unzip ore-server-platform-arch-1.4.zip
The files are unzipped into the server
subdirectory:
/oreserver_install_dir/server/
Run the installation script in the server
subdirectory.
cd server/ ./install.sh
To install Oracle R Enterprise Server in configuration mode, run the installer as follows:
./install.sh -configonly
When prompted, provide a password and specify the tablespaces for the RQSYS
schema. SYSAUX
is the default permanent tablespace. TEMP
is the default temporary tablespace.
Tip:
Refer to Section 4.1.3 for a description of the actions performed by the Oracle R Enterprise Server installation script.When the Oracle R Enterprise Server installation script is finished, complete the installation by installing the supporting packages.
To install the supporting packages, follow these steps:
Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).
Accept the license agreement and select Oracle R Enterprise supporting Packages for your platform. Save the file in the installation directory.
/oreserver_install_dir/ore-supporting-platform-arch-1.4.zip
Unzip the file as follows:
unzip ore-supporting-platform-arch-1.4.zip
The files are unzipped into the supporting
subdirectory:
/oreserver_install_dir/supporting/
Install the packages in this order:
cd supporting ORE CMD INSTALL ROracle_1.1-11_R_x86_64-unknown-linux-gnu.tar.gz ORE CMD INSTALL DBI_0.2-7_R_x86_64-unknown-linux-gnu.tar.gz ORE CMD INSTALL png_0.1-7_R_x86_64-unknown-linux-gnu.tar.gz ORE CMD INSTALL cairo_1.5-2_R_x86_64-unknown-linux-gnu.tar.gz
The packages are installed in $ORACLE_HOME/R/library
.
Follow the procedures in Section 7.1 to create and configure a database user account for Oracle R Enterprise.
See Also:
Appendix A for the steps in a typical installation of Oracle R Enterprise on a Linux server and Windows clientOn Linux and UNIX platforms, the Oracle R Enterprise Server installation provides the ORE
script, which you can run from the operating system prompt to install additional R packages. The ORE
script is a wrapper for the R installation command: R CMD INSTALL
.
By default, R packages are installed in /usr/lib64/R/library
. The ORE
script, however, installs R packages in a subdirectory under $ORACLE_HOME/R/library
.
To execute the script:
ORE CMD INSTALL R_package_name
These installation instructions apply to Microsoft Windows 64-bit platforms, as described in Table 1-1.
To install Oracle R Enterprise Server on Windows:
Ensure that your system satisfies the requirements specified in Table 4-2.
Ensure that your user ID has the permissions described in Section 4.2.3, "User Requirements"
Create an installation directory for the Oracle R Enterprise server components. The directory can have any name. For example:
c:\oreserver_install_dir
Go to the Oracle R Enterprise Downloads page on the Oracle Technology Network:
Accept the license agreement and select Oracle R Enterprise Server Install for Oracle Database on Windows 64 bit platform. Save the file in the installation directory that you created in Step 3.
c:\oreserver_install_dir\ore-server-win-x86_64-1.4.zip
Unzip the file. The files are unzipped in the server
subdirectory:
c:\oreserver_install_dir\server
In a command window, change to the server
subdirectory and execute the installation batch file:
cd c:\oreserver_install_dir\server
install.bat
To install Oracle R Enterprise Server in configuration mode, run the installer as follows:
install.bat -configonly
When prompted, provide a password and the locations of permanent and temporary tablespaces for the RQSYS
schema. SYSAUX
and TEMP
are used by default.
Tip:
Refer to Section 4.1.3 for a description of the actions performed by the Oracle R Enterprise Server installation script.When the Oracle R Enterprise Server installation script is finished, complete the installation by installing the supporting packages.
To install the supporting packages, follow these steps:
Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).
Accept the license agreement and select Oracle R Enterprise supporting Packages for Windows Platform. Save the file in the installation directory.
c:\oreserver_install_dir\ore-supporting-win-x86_64-1.4.zip
Unzip the file. The files are unzipped in the supporting
subdirectory.
c:\oreserver_install_dir\supporting\
Start R from the Windows Start menu. If you have installed both 32- and 64-bit R, be sure to choose 64-bit R.
The R Console window is displayed.
Install the packages as follows:
install.packages("c:/oreserver_install_dir/supporting/ ROracle_1.1-11.zip", repos=NULL) install.packages("c:/oreserver_install_dir/supporting/ DBI_0.2-7.zip", repos=NULL) install.packages("c:/oreserver_install_dir/supporting/ png_0.1-7.zip", repos=NULL) install.packages("c:/oreserver_install_dir/supporting/ cairo_1.5-2.zip", repos=NULL)
The packages are installed in $ORACLE_HOME/R/library
.
Follow the procedures in Section 7.1 to create and configure a user account for Oracle R Enterprise.
The Oracle R Enterprise server installation script creates log files in the server subdirectory of the installation directory. Examine the log files to verify the success of the installation process.
The following commands on a Linux or UNIX system list the log files:
cd ./oreserver_install_dir/server
ls *.log
rqinst.log rqproc.log
If there are problems with the installation and you are unable to resolve them, you can request help from My Oracle Support or from the Oracle R Enterprise discussion forum.
My Oracle Support — https://support.oracle.com
Oracle R Enterprise Forum — https://forums.oracle.com/community/developer/english/business_intelligence/data_warehousing/r