Since it is a technical article therefore for the sake of simplicity it is split into four parts. This is the first part of the series which provides the checklist of the items you need to make sure before proceeding the installation. Additionally it provides the details of the environment where the installation is done.

Table of Contents

  1. Environment Detail and Checklist
  2. Installing Oracle R Enterprise on the Server
    1. Install Oracle R Distribution on the Server
    2. Install Oracle R Enterprise Server
  3. Installing Oracle R Enterprise on the Client
    1. Install Oracle R Distribution on the Client
    2. Install Oracle R Enterprise Packages
    3. Install Oracle R Enterprise Supporting Packages
  4. Verification of the installation
    1. Start R Console
    2. Start Oracle R Enterprise (ORE)
    3. Connect to Oracle R Enterprise (ORE) server
    4. Basic Validation
      • Listing the database tables accessible to ruser1
      • Pushing an R Data Frame to a database table
      • Executing an Embedded R Function
      • Listing the Oracle R Enterprise Demo Scripts
      • Executing Oracle R Enterprise Demo Scripts
      • Executing the row_apply demo
      • Executing the cor demo
      • Executing the stepwise Demo

 

Introduction

Given below is a typical process of installing Oracle R Enterprise on IBM AIX Server and Windows Client. Basically, setup consists of two parts (A) Server side installation (B) Client side installation. I have added pre and post checks to this process:

  1. Environment Detail and Checklist
  2. Installing Oracle R Enterprise on the Server (A)
  3. Installing Oracle R Enterprise on the Client (B)
  4. Verification of the installation 

1. Environment Detail and Checklist

Here is the environment detail where the installation is done.

  • Server is running on IBM AIX 7100-04-04-1717.
  • Server has Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit.
  • Environment variables:
    • $ORACLE_SID specifies the identifier (SID) of the database.
    • $ORACLE_HOME specifies the home directory of the database.
    • $LD_LIBRARY_PATH includes $ORACLE_HOME/lib.
    • $PATH includes $ORACLE_HOME/bin.

Login with your AIX user (in my case it is "oracle") and quickly verify the environment variables as shown below:

  • AIX installation user must have sudo rights or root access for installing Oracle R Distribution. For this installation, we are going to do with “oracle” user. Typically, it is the user which you have used to install Oracle Database Software. Also, I do have “root” user access.
  • AIX installation user must be member of the dba group for installing and using Oracle R Enterprise. Here is a quick check
  •  

Login with “oracle” user and execute

$ groups
dba staff kmem

  • AIX installation user must have write access to $ORACLE_HOME/lib
  • To avoid IBM AIX permission related issue, Oracle recommends creating a new group “kmem”. This group allows users virtual memory read and write access such as, /dev/mem, /dev/port, and /dev/kmem. AIX administrator should create kmem group and provide read/write privileges to root and oracle user. [Note that this step is only required in case you encounter kmem group error during installation of ORD]
  • In this installation Client Machine is running on Windows 10 Pro 64-bit Operating System.
  • Make sure Oracle Client 11g 64-bit is already installed.
  • Also make sure client machine is able to make connection to above mentioned database server via sqlplus.
  • Client machine should have access to the internet.

Click here for Part-2