7 Administrative Tasks for Oracle R Enterprise

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:

   • For Oracle Database 11.2, see: "Using Oracle Wallet Manager" in Oracle Database Advanced Security Administrator's Guide

   • For Oracle Database 12.1, see: "Using Oracle Wallet Manager" in Oracle Database Enterprise User Security Administrator's Guide.

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)
   

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.

-- 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);

7.3 Upgrading Oracle R Enterprise

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

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:

• Uninstalling Oracle R Enterprise Server

• Uninstalling Oracle R Enterprise Client

• Uninstalling R

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

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:

• Uninstalling R on Windows

• Uninstalling Oracle R Distribution on Linux

• Uninstalling Oracle R Distribution on Oracle Solaris

• Uninstalling Oracle R Distribution on IBM AIX

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

# ./uninstall.sh

# installp -u ORD    

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