This chapter explains how to install and configure Oracle Database to support Oracle R Enterprise Server. This chapter contains these topics:
Oracle R Enterprise requires the 64-bit version of Oracle Database Enterprise Edition. The database can be installed on any of the platforms described in Table 1-1, "Oracle R Enterprise Platform Requirements".
To install Oracle Database, follow the installation instructions for your platform:
Linux
Oracle Database Installation Guide for Linux, Release 12.1, http://www.oracle.com/pls/topic/lookup?ctx=db121&id=LADBI
Oracle Database Installation Guide for Linux, Release 11.2, http://www.oracle.com/pls/topic/lookup?ctx=db112&id=LADBI
Oracle Solaris
Oracle Database Installation Guide for Oracle Solaris, Release 12.1, http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SSDBI
Oracle Database Installation Guide for Oracle Solaris, Release 11.2, http://www.oracle.com/pls/topic/lookup?ctx=db112&id=SSDBI
IBM AIX
Oracle Database Installation Guide for IBM AIX on POWER Systems (64-Bit), Release 12.1, http://www.oracle.com/pls/topic/lookup?ctx=db121&id=AXDBI
Oracle Database Installation Guide for IBM AIX on POWER Systems (64-Bit), Release 11.2, http://www.oracle.com/pls/topic/lookup?ctx=db112&id=AXDBI
Microsoft Windows
Oracle Database Installation Guide for Microsoft Windows, Release 12.1, http://www.oracle.com/pls/topic/lookup?ctx=db121&id=NTDBI
Oracle Database Installation Guide for Microsoft Windows. Release 11.2, http://www.oracle.com/pls/topic/lookup?ctx=db112&id=NTDBI
Note:
You can install Oracle R Enterprise Server in a pluggable database (PDB) within a multitenant container database (CDB). The database may not be the root database.For information about managing a multitenant environment, see Oracle Database Administrator's Guide.
Oracle R Enterprise 1.4.1 requires Oracle Database 11.2.0.3, 11.2.0.4, or 12.1. On Linux, Oracle R Enterprise can also work with an 11.2.0.1 or 11.2.0.2 database if it is properly patched.
If you are running an earlier release of Oracle Database 11g Release 2 on Linux and you are unable to upgrade to 11.2.0.3 or later, then you can follow this procedure to patch the database:
Go to My Oracle Support:
Log in and supply your Customer Support ID (CSI).
Choose the Patches & Updates tab.
In the Patch Search box, type 11678127
and click Search.
Select the patch for your version of Oracle Database, either 11.2.0.1 or 11.2.0.2.
Click Read Me, and read the installation instructions and other details about the patch.
Click Download to download the patch.
Install the patch using OPatch. Ensure that you are using the latest version of OPatch.
See Also:
”Patching Oracle Software With OPatch” in Oracle Universal Installer and OPatch User's Guide for Windows and UNIXfor instructions.An external procedure is a procedure invoked from a program that is written in a different language. Oracle Database uses an external procedure agent named extproc
to support external procedures. Oracle R Enterprise uses extproc
to support embedded R execution.
When an application invokes an external procedure, Oracle Database starts an extproc
agent. The application uses the network connection established by Oracle Database to pass instructions to the agent for executing the procedure. The agent loads a DLL or shared library, runs the external procedure, and passes back to the application any values returned by the external procedure.
Oracle R Enterprise uses the default configuration of extproc
. The extproc
agent is spawned directly by Oracle Database, and no configuration changes are required for either listener.ora
or tnsnames.ora
.
By default, extproc
supports any external procedure call. If you want to only allow external procedure calls for Oracle R Enterprise, you can edit the EXTPROC_DLLS
environment variable in ORACLE_HOME/hs/admin/extproc.ora
.
The following statement on a Linux or UNIX system sets EXTPROC_DLLS
to only execute external procedures for Oracle R Enterprise:
SET EXTPROC_DLLS=ONLY:$ORACLE_HOME/lib/ore.so
To allow extproc
to service any external procedure, set EXTPROC_DLLS
to ANY
or simply leave it blank (the default).
See Also:
”Default Configuration for External Procedures” in Oracle Database Net Services Administrator's Guide for details