Oracle® R Enterprise

Release Notes

Release 1.4 for Windows, Linux, Solaris, and AIX

E40696-06

March 2014

This document contains important information that was not included in the documentation for Oracle R Enterprise Release 1.4.

This document contains these topics:

Known Issues

The following known issue exists in Oracle R Enterprise 1.4:

BUG 18373587 - Oracle R Enterprise 1.4 upgrade fails to update R_HOME for embedded R

The Oracle R Enterprise 1.4 upgrade process does not update the value of R_HOME in sys.rq_config.

Problem Description

Embedded R uses the value of R_HOME specified in sys.rq_config to determine the location of R. When you upgrade to Oracle R Enterprise 1.4, the value of R_HOME is not updated. This only presents a problem if R home is not the same as it was for the earlier release of Oracle R Enterprise.

In most cases, you will not encounter this problem on Linux systems since R is installed in /usr/lib64/R/library by default on Linux..

Workaround

Update the value of R_HOME in the sys.rq_config table as follows:

sqlplus / as sysdba
EXEC sys.rqconfigset('R_HOME', 'new_path')

About Oracle R Distribution 3.0.1

R 3.0.1 is required for Oracle R Enterprise 1.4. Oracle recommends that you use Oracle R Distribution whenever possible. Oracle R Distribution 3.0.1 is supported on all platforms including 64-bit Windows.

If you intend to use open source R, refer to "Open Source R for Oracle R Enterprise" in Oracle R Enterprise Installation and Administration Guide for instructions.

About Oracle R Enterprise 1.4 and Oracle Database

Oracle R Enterprise 1.4 supports Oracle Database 11.2 and 12.1. However, Oracle Database 11.2 ships with Oracle R Enterprise 1.3.1, and Oracle Database 12.1 ships with Oracle R Enterprise 1.2. If you are using an earlier release of Oracle R Enterprise, you should upgrade to release 1.4.

Refer to:

"Upgrading Oracle R Enterpise" in Oracle R Enterprise Installation and Administration Guide for upgrade instructions.

Note:

Oracle R Enterprise does not currently support the multitenant container database (CDB) feature of Oracle Database 12c.

Oracle R Enterprise Supporting Packages

Oracle R Enterprise requires several open source R packages. In earlier releases of Oracle R Enterprise, these packages were called "client supporting" packages. In Oracle R Enterprise 1.4, these packages are simply called "supporting packages."

In Oracle R Enterprise 1.4, the supporting packages are:

ROracle 1.1-11
DBI 0.2-7
png 0.1-7
cairo 1.5-2

Oracle R Enterprise 1.4 System Requirements

Oracle R Enterprise runs on 64-bit platforms only. Both client and server components are supported on each of the platforms described in Table 1.

Table 1 Oracle R Enterprise Platform Requirements

Operating System Hardware Platform Description

Linux x86-64

Intel and AMD

  • 64-bit Oracle Linux Release 5 update 6 through Oracle Linux 6

  • 64-bit Red Hat Enterprise Linux Release 5 update 6 through Red Hat Enterprise Linux 6

Oracle Linux may be running on Oracle Exadata Database Machine.

Oracle Solaris

Intel and SPARC

  • 64-bit Oracle Solaris 10 update 10 through Oracle Solaris 11 for both SPARC and x86-64 (Intel) platforms

  • Oracle SPARC SuperCluster

  • Oracle Solaris Studio (formerly Sun Studio) 12u3 or later

Oracle Solaris may be running on Oracle Exadata Database Machine.

IBM AIX

IBM

64-bit IBM AIX 5.3 or higher

Microsoft Windows

Intel

64-bit Microsoft Windows XP, Vista, or Windows 7


The supported configurations of Oracle R Enterprise, Oracle R Distribution, and Oracle Database are shown in Table 2.

Table 2 Oracle R Enterprise Configuration and Support Matrix

Oracle R Enterprise Version R/Oracle R Distribution Version Oracle Database Version (See Note)

1.0

2.13.2

11.2.0.3, 11.2.0.4, 12.1

1.1

2.13.2

11.2.0.3, 11.2.0.4, 12.1

1.2

2.15.1

11.2.0.3, 11.2.0.4, 12.1

1.3

2.15.1

11.2.0.3, 11.2.0.4, 12.1

1.3.1

2.15.1, 2.15.2, 2.15.3

11.2.0.3, 11.2.0.4, 12.1

1.4

3.0.1

11.2.0.3, 11.2.0.4, 12.1


Note:

Oracle Database versions 11.2.0.1 and 11.2.0.2 are supported on Linux if patched. See "Patching Oracle Software With OPatch" in Oracle Universal Installer and OPatch User's Guide for Windows and UNIX.

Bugs Fixed in Oracle R Enterprise 1.4

Oracle R Enterprise Release 1.4 fixes the problems listed in Table 3.

Table 3 Bugs Fixed in Oracle R Enterprise Release 1.4

Bug Number Bug Description

15974756

MISSING AS.ORE.MATRIX METHODS FOR ORE.FRAME AND ORE.VECTOR

16018980

ADD ORE.LM/ORE.STEPWISE SUPPORT FOR MORE THAN 1000 COLUMNS

16060161

HARDCODED PASSWORD FOR RQSYS SCHEMA DOES NOT PASS SECURITY TEST ON SOME SYSTEMS

16093910

NAN VALUES ARE NOT PROPERLY HANDLED IN EMBEDDED R RELATIONAL OUTPUT

16118483

EMBEDDED R DOES NOT DELETE INSTANCE TEMPDIR() WHEN ENGINE IS SHUT DOWN

16167325

ADD ABILITY TO ADD PARALLEL HINT TO SQL QUERIES

16193682

DERIVED ORE.FRAMES ERROR OUT WITH ORE.*APPLY FUNCTIONS

16238165

ADD ARGUMENT "LIST" TO ORE.DELETE FUNCTION

16273403

ORE.LOAD DOES NOT RESTORE ORE.ODMGLM MODEL OBJECTS FULLY

16284222

ENSURE ORE INSTALLER WORKS WITH MULTIPLE DB INSTANCES ON A SINGLE NODE

16312948

ENV R_HOME COULD INTERFERE WITH ORE INSTALL.SH

16347902

ORE.SAVE FAILS TO PRESERVE TEMP DEPENDENT TABLE USED BY ORE.LM

16426951

ADD SUPPORT FOR FACTOR ANALYSIS

16465253

ADDRESS THE SCORES ARGUMENT TO THE ORESTATS::PRINCOMP METHOD

16465257

ORESTATS::PRINCOMP ADD SUPPORT FOR SUBSET ARGUMENT WHEN NO FORMULA IS SUPPLIED

16501402

THE SEP ARGUMENT ISN'T WORKING FOR THE INTERACTION METHOD

16503775

RELATIONAL OUTPUT IN EMBEDDED R DOES NOT GRACEFULLY HANDLE LONG COLUMN NAMES

16596151

EMBEDDED R REQUIRES ENVIRONMENT SETTING OF LD_LIBRARY_PATH TO FIND SUNPEF LIB

16622884

TRANSFORM AND WITHIN FUNCTIONS REQUIRE A ROW ORDERING FOR IFELSE TRANSFORMS

16635436

R:ORE: ORE 1.3.1 LIBRARY SHOULD CHECK FOR R >= 2.15.1 BEFORE LOADING

16679892

ORE.PULL ACCEPTS R DATA.FRAME AS INPUT AND RETURNS LIST

16687310

REDUCE THE FREQUENCY OF EMBEDDED R AUTO CONNECTION SETUP

16710184

ORE SCRIPT "RQ$INSTALLED.PACKAGES" ERRORS WHEN PKGS INSTALLED IN MULTIPLE LIBS

16724485

ADD A COMPLETE.CASES METHOD FOR ORE.FRAME OBJECTS

16724597

NA.OMIT METHOD FOR ORE.FRAME DOES NOT RECOGNIZE NAN AS MISSING

16724640

S.NAN METHOD FOR ORE.NUMBER DOES NOT RECOGNIZE NAN

16731768

ORE.SAVE FAILS TO SAVE ORE.ODMGLM OBJECT

16758080

MODEL.MATRIX METHOD DOES NOT HANDLE LONG TRANSFORMATIONS IN DERIVED COLUMNS

16782921

R:ORE: ADD OPTION TO DEMO_USER.SH TO CONVERT EXISTING DATABASE USER TO ORE USER

16977729

LIST AND MATRIX [<- OPERATION NOT SUPPORTED FOR ORE.FRAME

17017475

SUMMARY METHOD FOR ORE.NUMBER DOES NOT PRODUCE THE CORRECT S3 CLASS OUTPUT

17033235

ORE.SAVE FAILS FOR SOME DERIVED ORE.VECTOR OBJECTS

17033469

XML OUTPUT FROM EMBEDDED R DOES NOT PROPERLY HANDLE SPECIAL CHARACTERS

17172803

ADD SUPPORT TO WEIGHTS ARGUMENT TO ORE.LM

17199305

HIST.ORE DOES NOT SUPPORT BREAKS = NUMERIC VECTOR ARGUMENT OPTION

17249446

DBETA FUNCTION FOR ORE.NUMBER INCORRECT WHEN VALUES AT BOUNDARIES [0, 1

17277987

ORE.LM FAILS TO DETECT PROPER RANK FOR COLLINEAR MODEL WHERE # COEF > # OBS

17609337

ORE INSTALL SCRIPT: PROMPT FOR RQSYS PASSWORD AS DONE FOR RQUSER

17609402

ENABLE FULL EXPORT/IMPORT OF ORE OBJECTS BETWEEN DATABASES

17628995

ORE.ODMSVM MISSING EXTREF ON FIT.VALUES

17655037

DATASTORE - PROVIDE ABILITY TO DELETE INDIVIDUAL OBJECTS FROM DATASTORE

17655108

DATASTORE - ENABLE EASY EXPORT/IMPORT OF DATASTORE BETWEEN DB INSTANCES

17884100

R:ORE: ORE.ODMDT COST.MATRIX ARGUMENT REQUIRES DATA FRAME INSTEAD OF MATRIX

18133488

PRINCOMP THROWS ERROR WHEN SYMBOL USED IN DATA ARG EXISTS IN ORESTATS PACKAGE

18155267

ADD "PARALLEL_ENABLE" TO ALL PL/SQL SINGLE-ROW MATH FUNCTIONS


Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle R Enterprise Release Notes, Release 1.4 for Windows, Linux, Solaris, and AIX

E40696-06

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.