Skip Headers
Oracle® R Enterprise Installation and Administration Guide
Release 1.3.1 for Windows, Linux, Solaris, and AIX

E36763-17
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

7 Administrative Tasks for Oracle R Enterprise

This chapter describes administrative tasks for maintaining and optimizing Oracle R Enterprise. This chapter contains these topics:

7.1 Creating an Oracle Wallet for an Oracle R Enterprise Connection

An Oracle wallet is a password-protected container for storing security credentials in Oracle Database. Wallets provide a secure mechanism for specifying connection details in embedded R scripts.

To create a wallet for an Oracle R Enterprise connection: 

  1. Start Oracle Wallet Manager:

    • (Linux and UNIX) At the command line, enter owm.

    • (Windows) Select Start, Programs, Oracle-HOME_NAME, Integrated Management Tools, Wallet Manager.

  2. Follow the instructions in your Oracle Database documentation to create the wallet:

  3. Locate the connection string for the Oracle R Enterprise database in tnsnames.ora. For example:

    mydb_test =
          (DESCRIPTION =
             (ADDRESS =
                (PROTOCOL = TCP)
                (HOST = server23)
                (PORT = 1521)
             )
             (CONNECT_DATA = (sid=ORCL))
          )
    
  4. Specify the connection information in the wallet. Follow the instructions in the Oracle Database security documentation referenced in step 2.

  5. After you configure the wallet, you can connect to the Oracle R Enterprise server database by simply specifying the connection identifier. For example:

     ore.connect(conn_string = "mydb_test", all = TRUE)
    

See Also:

R help for ore.connect

7.2 Controlling Memory Used by Embedded R

You can control the memory used by embedded R execution by limiting the heap memory (vector and cons in R terminology) that is automatically managed by the R gc mechanism. To limit the size of heap memory in the database, use the sys.rqconfigset utility. The keyword arguments for sys.rqconfigset are described in Table 7-1.

Table 7-1 SYS.RQCONFIGSET Keyword Arguments

Keyword Default Description

MIN_VSIZE

32MB

Minimum R vector heap memory

MAX_VSIZE

4GB

Maximum R vector heap memory

MIN_NSIZE

1M

Minimum number of R cons cells

MAX_NSIZE

20M

Maximum number of R cons cells


Example 7-1 Using SYS.RQCONFIGSET to Control Memory Used by Embedded R

-- Set the minimum R vector heap memory to 20MB
SQL> EXEC sys.rqconfigset('MIN_VSIZE', '20MB');

-- Set the maximum R vector heap memory to 100MB
SQL> EXEC sys.rqconfigset('MAX_VSIZE', '100MB')

-- Set the minimum number of R cons cells to 500x1024
SQL> EXEC sys.rqconfigset('MIN_NSIZE', '500K');

-- Set the maximum number of R cons cells to 10x10x1024
SQL> EXEC sys.rqconfigset('MAX_NSIZE', '10MB');

-- Set maximum vector heap memory and maximum cons cells to unlimited
SQL> EXEC sys.rqconfigset('MAX_VSIZE', NULL); 
SQL> EXEC sys.rqconfigset('MAX_NSIZE', NULL);

Note:

The sys.rqconfigset procedure does not control the C type memory that may be allocated by Calloc, Realloc, calloc, or malloc. Such C type memory is mainly created to hold temporary values used by R functions that are implemented in C. Under normal circumstances, C type memory is limited in size and does not significantly affect the memory usage of R.

7.3 Upgrading Oracle R Enterprise

You can upgrade Oracle R Enterprise to the current release from any previous release by reinstalling the product.

Note on IBM AIX:

Upgrade from Oracle R Enterprise 1.1 is not supported on IBM AIX. To upgrade Oracle R Enterprise 1.1 on IBM AIX, first uninstall Oracle R Enterprise 1.1 (including R) and then download and install the later version.

To upgrade Oracle R Enterprise: 

  1. Ensure that you have the version of R that is required for the new version of Oracle R Enterprise. See Oracle R Enterprise Release Notes for the latest requirements.

    To install R, follow the instructions in Chapter 3, "Installing R".

  2. To upgrade Oracle R Enterprise Server, follow the installation procedures. When the installation script detects an earlier version of Oracle R Enterprise, it asks if you want to upgrade. Answering No aborts the process; answering Yes starts the upgrade.

    See Chapter 4 for the Oracle R Enterprise Server installation instructions.

  3. To upgrade Oracle R Enterprise Client, re-install the client packages and client supporting Packages. You do not have to uninstall the current packages before installing the new packages.

    See Chapter 5 for the Oracle R Enterprise Client installation instructions.

7.4 Uninstalling Oracle R Enterprise

To uninstall Oracle R Enterprise, follow the instructions in the following topics:

7.4.1 Uninstalling Oracle R Enterprise Server

An uninstall script is included with the Oracle R Enterprise Server files in the server directory. The script removes the libraries that were installed in $ORACLE_HOME/lib and drops all the database objects that were created by the Oracle R Enterprise Server installation.

The user that runs the uninstall script must satisfy the requirements specified in Section 4.2.3, "User Requirements".

On a Linux system, you could uninstall Oracle R Enterprise Server as follows:

% cd download_path/server/
% ./uninstall.sh

7.4.2 Uninstalling Oracle R Enterprise Client

To uninstall the Oracle R Enterprise Client Packages and Client Supporting Packages, start R and type these commands:

R> remove.packages("ORE")
R> remove.packages("ORExml")
R> remove.packages("OREeda")
R> remove.packages("OREgraphics")
R> remove.packages("OREstats")
R> remove.packages("OREbase")
R> remove.packages("ROracle")
R> remove.packages("DBI")
R> remove.packages("png")
R> remove.packages("OREdm")
R> remove.packages("OREpredict")

7.5 Uninstalling R

To uninstall R, follow the instructions in the following topics:

7.5.1 Uninstalling R on Windows

Uninstall Open Source R just as you would uninstall any other Windows program. using Add or Remove Programs from the Windows Control Panel.

7.5.2 Uninstalling Oracle R Distribution on Linux

To uninstall Oracle R Distribution on Linux, log in as root and execute these commands in this order. To uninstall a different version of R, replace 2.15.3 with the version number.

# rpm -e R-2.15.3
# rpm -e R-devel
# rpm -e R-core
# rpm -e libRmath-devel
# rpm -e libRmath

7.5.3 Uninstalling Oracle R Distribution on Oracle Solaris

To uninstall Oracle R Distribution on Oracle Solaris, follow the instructions in the readme on the Oracle R Distribution download page on the Oracle Technology Network:

https://oss.oracle.com/ORD/

The Oracle R Distribution installation directory on Oracle Solaris includes an uninstall script. Log in as root and run the script as follows:

# ./uninstall.sh

7.5.4 Uninstalling Oracle R Distribution on IBM AIX

To uninstall Oracle R Distribution on IBM AIX, follow the instructions in the readme on the Oracle R Distribution download page on the Oracle Technology Network:

https://oss.oracle.com/ORD/

To uninstall all filesets execute the following command as root:

# installp -u ORD    

You can also uninstall independent filesets. For example, the following commands uninstall only ORD.dev and ORD.core:

# installp -u ORD.devel
# installp -u ORD.core