This chapter introduces the Oracle R Enterprise installation process. This chapter contains the following topics:
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
Oracle R Enterprise Client Components:
Oracle Database Client
Oracle R Enterprise packages and supporting packages
Oracle R Enterprise Server Components:
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
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.
Note:
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.
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
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) |
---|---|---|
1.5 |
3.2.x |
11.2.0.4, 12.1.0.1, 12.1.0.2 |
1.4.1 |
3.0.1, 3.1.1 |
11.2.0.3, 11.2.0.4, 12.1.0.1, 12.1.0.2 |
1.4 |
3.0.1, 3.1.1 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
1.3.1 |
2.15.1, 2.15.2, 2.15.3 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
1.3 |
2.15.1 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
1.2 |
2.15.1 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
1.1 |
2.13.2 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
1.0 |
2.13.2 |
11.2.0.3, 11.2.0.4, 12.1.0.1 |
Note:
In Oracle Database Release 12.1.0.2, 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:
Oracle R Enterprise Release Notes for the latest platform requirements and the latest versions of R that are supported with Oracle R Enterprise.
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.