Oracle® R Enterprise Installation and Administration Guide Release 1.3.1 for Windows, Linux, Solaris, and AIX E36763-17 |
|
|
PDF · Mobi · ePub |
This chapter explains how to install Oracle R Enterprise Server. This chapter includes these topics:
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 client 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.
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
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.
On the Advanced tab, choose Environment Variables.
Create or modify the environment variables.
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:
"About Operating System Authentication" in Oracle Database Administrator's Guide
"Operating System Authentication Enabled at Installation" in Oracle Database Platform Guide for Microsoft Windows
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.3.1).
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.3.1.zip
Unzip the file as follows:
% unzip ore-server-platform-arch-1.3.1.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
When prompted, provide 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 client supporting packages.
Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).
Accept the license agreement and select Oracle R Enterprise Client Supporting Packages for your platform. Save the file in the installation directory.
~/oreserver_install_dir/ore-supporting-platform-arch-1.3.1.zip
Unzip the file as follows:
% unzip ore-supporting-platform-arch-1.3.1.zip
The files are unzipped into the supporting
subdirectory:
~/oreserver_install_dir/supporting/
Install the packages:
% cd supporting % ORE CMD INSTALL ROracle_1.1-9_R_x86_64-unknown-linux-gnu.tar.gz % ORE CMD INSTALL DBI_0.2-5_R_x86_64-unknown-linux-gnu.tar.gz % ORE CMD INSTALL png_0.1-4_R_x86_64-unknown-linux-gnu.tar.gz
The packages are installed in $ORACLE_HOME/R/library
.
Follow the procedures in Section 6.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.3.1.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
When prompted, provide 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 client supporting packages.
Return to the Oracle R Enterprise Downloads page on the Oracle Technology Network (Step 4).
Accept the license agreement and select Oracle R Enterprise Client Supporting Packages for Windows Platform. Save the file in the installation directory.
c:\oreserver_install_dir\ore-supporting-win-x86_64-1.3.1.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:
R> install.packages("c:/oreserver_install_dir/supporting/ ROracle_1.1-9.zip", repos=NULL) R> install.packages("c:/oreserver_install_dir/supporting/ DBI_0.2-5.zip", repos=NULL) R> install.packages("c:/oreserver_install_dir/supporting/ png_0.1-4.zip", repos=NULL)
The packages are installed in $ORACLE_HOME/R/library
.
Follow the procedures in Section 6.1 to create and configure a user account for Oracle R Enterprise.
Oracle Exadata Database Machine consists of several compute nodes, along with storage and other facilities. Each node hosts an Oracle database.
To install Oracle R Enterprise Server on Oracle Exadata Database Machine:
On each node:
Install Oracle R Distribution as described in Section 3.5.
Ensure that the environment is configured as described in Section 4.2. Environment variables must be set on each node.
Install Oracle R Enterprise Server, as described in Section 4.3.
Install Oracle R Enterprise client supporting packages, as described in Section 5.2.
On the first node only, create a user, as described in Section 6.1.
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