Husnu Sensoy

Before starting to deal with large volumes of data problems on Oracle R Enterprise (ORE) you need to perform a couple of configurations over your Oracle Linux and Oracle Database systems. Here is the recipe:

• Ensure that you have the following lines in your oracle users .bash_profile file

  export R_HOME=/usr/lib64/R
  export PATH=/usr/bin:$PATH
  

• Ensure that you have already installed libpng.x86_64 and libpng-devel.x86_64 packages on your Oracle Linux otherwise issue to install them.

  yum install libpng.x86_64 libpng-devel.x86_64
  

• Switch to root and issue R. Once you are in R session, install two prerequisites of ORE:

  install.packages("DBI")
  install.packages("png")
  

• Ensure that your database is 11.2.0.3 otherwise refer you need to apply several database patches:
• Go to Oracle R Enterprise Download Page and download Oracle R Enterprise Server Install for Oracle Database on Linux 64-bit (91M) and Oracle R Enterprise Client Supporting Packages for Linux 64-bit Platform (1M)  (ore-server-linux-x86-64-1.1.zip and ore-supporting-linux-x86-64-1.1.zip) under Oracle R Enterprise Downloads (v1.1) section
• Unzip the file by issuing

  unzip ore-server-linux-x86-64-1.1.zip ore-supporting-linux-x86-64-1.1.zip
  

• At this point ensure that your database to support Oracle R Enterprise is up and running
• Execute install.sh in order to create ORE libraries and database objects into SYS and RQSYS schemas.

  cd server
  ./install.sh
  

  
Oracle R Enterprise 1.1 Server Installation.

  Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.

  Do you wish to proceed? [yes]

  Checking R ................... Pass
  Checking R libraries ......... Pass
  Checking ORACLE_HOME ......... Pass
  Checking ORACLE_SID .......... Pass
  Checking sqlplus ............. Pass
  Checking ORE ................. Pass

  Choosing RQSYS tablespaces
  PERMANENT tablespace to use for RQSYS [SYSAUX]:
  TEMPORARY tablespace to use for RQSYS [TEMP]:

  Current configuration
  R_HOME = /usr/lib64/R
  R_LIBS_USER = /u01/app/oracle/product/11.2.0/dbhome_1/R/library
  ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
  ORACLE_SID = orcl
  PERMANENT tablespace = SYSAUX
  TEMPORARY tablespace = TEMP

  Installing libraries ......... Pass
  Installing RQSYS ............. Pass
  Installing ORE packages ...... Pass
  Creating ORE script .......... Pass

  NOTE: To use ORE functionality, a database user with RQROLE role,
  a few more grants and synonyms is required. A complete list of
  requirements is available in rquser.sql. There is also a demo
  script demo_user.sh creating a new user RQUSER.

  To use embedded R functionality, an RQADMIN role is required.
  Please, consult the documentation for more information on various
  roles.

  Done


• Finally install some required R libraries/packages by using install.packages command in R. Ensure that user (root will do that) you will start R has a write permission on /usr/lib64/R/library

  install.packages("/home/oracle/Desktop/server/ORE_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/server/OREbase_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/server/OREeda_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/server/OREgraphics_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/server/OREstats_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/server/ORExml_1.1_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  install.packages("/home/oracle/Desktop/supporting/ROracle_1.1-2_R_x86_64-unknown-linux-gnu.tar.gz", repos = NULL)
  

• Finally start a R session (ensure that $ORACLE_HOME/lib is in your LD_LIBRARY_PATH before starting R session) and load ORE library

  library(ORE)
  Loading required package: OREbase
  Loading required package: ROracle
  Loading required package: DBI
  
  Attaching package: 'OREbase'
  
  The following object(s) are masked from 'package:base':
  
      cbind, data.frame, eval, interaction, order, paste, pmax, pmin,
      rbind, table
  
  Loading required package: OREstats
  Loading required package: MASS
  Loading required package: OREgraphics
  Loading required package: OREeda
  Loading required package: ORExml