1 Overview of Oracle R Enterprise Installation

This chapter introduces the Oracle R Enterprise installation process. This chapter contains the following topics:

1.1 Oracle R Enterprise Architecture

Oracle R Enterprise has a client/server architecture based on Oracle Database and Oracle Client. R engines run on the server computer and on each client computer.

  • SQL Transparency

    Oracle R Enterprise packages on the client support SQL transparency, which enables Oracle tables to appear "transparently" as native R objects. With SQL transparency, data analysts can use R to explore, cleanse, and transform data without having to know SQL.

  • Embedded R Execution

    Oracle R Enterprise packages, libraries, and R and SQL APIs on the server support the execution of R commands within SQL queries and PL/SQL statements. Embedded R is executed in spawned R engines that can run in parallel. With embedded R, you can execute R algorithms on very large data sets, and you can use database facilities like DBMS_SCHEDULER to schedule the execution of user-defined R functions for lights out processing.

Figure 1-1 illustrates the client/server architecture of Oracle R Enterprise.

Figure 1-1 Client/Server Architecture of Oracle R Enterprise

Description of Figure 1-1 follows
Description of "Figure 1-1 Client/Server Architecture of Oracle R Enterprise"

1.2 Client and Server Components of Oracle R Enterprise

  • Oracle R Enterprise Client Components:

    • Oracle Database Client

    • Oracle R Enterprise packages and supporting packages

  • Oracle R Enterprise Server Components:

    • Oracle Database with schema objects and shared libraries for supporting Oracle R Enterprise clients

    • Oracle R Enterprise packages and supporting packages

1.3 Oracle R Enterprise Installation Steps

The Oracle R Enterprise client and server installation steps are illustrated in Figure 1-2.

Figure 1-2 Oracle R Enterprise Client and Server Installation Steps

Description of Figure 1-2 follows
Description of "Figure 1-2 Oracle R Enterprise Client and Server Installation Steps"

The Oracle R Enterprise Server installation script can install the supporting packages and create a database user along with the installation of Oracle R Enterprise Server. See Installing Oracle R Enterprise Server for details.


If you intend to use both client and server components of Oracle R Enterprise on the computer that is hosting Oracle Database, then you do not need to perform a separate client installation. A local installation of Oracle Database Client is automatically included in the installation of Oracle Database.

1.4 Oracle R Enterprise System Requirements

Oracle R Enterprise runs on 64-bit platforms only.

Both client and server components are supported on each of the platforms described in this topic.

Table 1-1 Oracle R Enterprise Platform Requirements

Operating System Hardware Platform Description

Linux x86-64

Intel and AMD

  • 64-bit Oracle Linux Releases 6 and 7

  • 64-bit Red Hat Enterprise Linux Releases 6 and 7

Oracle Linux may be running on Oracle Exadata Database Machine.

Oracle Solaris on x86-64 (64-Bit)

Oracle Solaris on SPARC-64 (64-Bit)

Intel and SPARC

  • 64-bit Oracle Solaris 10 update 10 through Oracle Solaris 11 for both SPARC and x86-64 (Intel) platforms

  • Oracle SPARC SuperCluster

  • Oracle Solaris Studio (formerly Sun Studio) 12u3 or later

Oracle Solaris may be running on Oracle Exadata Database Machine.

IBM AIX on POWER Systems (64-Bit)


64-bit IBM AIX 5.3 or higher

Microsoft Windows x64 (64-Bit)


64-bit Microsoft Windows

See Verifying 64-Bit Architecture on Microsoft Windows.

The following table shows the supported configurations of Oracle R Enterprise server components. Oracle recommends that you use Oracle R Distribution, Oracle's free distribution of R, with Oracle R Enterprise. You should install Oracle R Distribution before installing Oracle R Enterprise.

Table 1-2 Oracle R Enterprise Server Support Matrix

Oracle R Enterprise Open source R or Oracle R Distribution Oracle Database (see Note)




3.0.1, 3.1.1,,,


3.0.1, 3.1.1,,


2.15.1, 2.15.2, 2.15.3,,










In Oracle Database Release, for some embedded R operations to be successful, both Oracle R Enterprise releases 1.4.1 and 1.5 require the database patch -- 20173897 WRONG RESULT OF GROUP BY FROM A TABLE RETURNED BY EXTPROC (Patch).

See Also:

1.4.1 Verifying 64-Bit Architecture on Microsoft Windows

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:

    1. From Windows Control Panel, choose System.

    2. Verify that System type is 64-bit Operating System.

  • Windows XP:

    1. From the Start menu, choose My Computer.

    2. Click Properties.

    3. On the System tab, verify that the system is x64 Edition.