2 Installing and Configuring the Database for Oracle R Enterprise

This chapter explains how to install and configure Oracle Database to support Oracle R Enterprise Server. This chapter contains these topics:

• Installing Oracle Database for Oracle R Enterprise

• Configuring EXTPROC for Embedded R Execution

2.1 Installing Oracle Database for Oracle R Enterprise

Lists the publications that have Oracle Database installation instructions for different platforms.

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.

To install Oracle Database, follow the installation instructions for your platform:

• Linux

  • Oracle Database Installation Guide for Linux, Release 12.1, https://docs.oracle.com/database/121/LADBI/chklist.htm#LADBI8045

    Oracle Database Installation Guide for Linux, Release 11.2, https://docs.oracle.com/cd/E11882_01/install.112/e47689/install_overview.htm#LADBI1042

• Oracle Solaris

  • Oracle Database Installation Guide for Oracle Solaris, Release 12.1, https://docs.oracle.com/database/121/SSDBI/chklist.htm#SSDBI8045

  • Oracle Database Installation Guide for Oracle Solaris, Release 11.2, https://docs.oracle.com/cd/E11882_01/install.112/e48357/install_overview.htm#SSDBI1042

• IBM AIX

  • Oracle Database Installation Guide for IBM AIX on POWER Systems (64-Bit), Release 12.1, https://docs.oracle.com/database/121/AXDBI/install_overview.htm#AXDBI7432

  • Oracle Database Installation Guide for IBM AIX on POWER Systems (64-Bit), Release 11.2, https://docs.oracle.com/cd/E11882_01/install.112/e48740/install_overview.htm#AXDBI1044

• Microsoft Windows

  • Oracle Database Installation Guide for Microsoft Windows, Release 12.1, https://docs.oracle.com/database/121/NTDBI/chklist.htm#CIHHGEHC

  • Oracle Database Installation Guide for Microsoft Windows, Release 11.2, https://docs.oracle.com/cd/E11882_01/install.112/e47798/intro.htm#NTDBI2639

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.

2.2 Configuring EXTPROC for Embedded R Execution

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.

2.2.1 About EXTPROC

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.

2.2.2 About EXTPROC Configuration for Oracle R Enterprise

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