Installation of Oracle R Enterprise Client 1.5 for Oracle Database 11G on OEL6

This presentation shows how to install and configure Oracle R Enterprise Client 1.5 for Oracle Database 11G Linux OEL6.


Following picture shows general architecture of Oracle R. This article will focus only on installation of Client parts.


Installation steps for Client parts

NOTE – following article shows installation of Oracle Enterprise Linux 6:

Install Oracle Linux 6 (OEL6)

Installation consists of three steps:

  • Install Oracle Database Client
  • Install Oracle R Distribution (presented in this article) or Open Source R
  • Install Oracle R Enterprise Client


Install Oracle Database Client

This part is done as user Oracle

1. Create an installation directory for the Oracle Database Client components

cd /home/oracle
mkdir oreclient_dir

2. Download to the directory Instant Client Package – Basic or Instant Client Package – Basic Lite zip for Oracle Database version on platform Linux x86-64

ls /home/oracle/oreclient_dir

3. Unzip the file

cd /home/oracle/oreclient_dir
  inflating: instantclient_11_2/BASIC_README  
  inflating: instantclient_11_2/adrci  
  inflating: instantclient_11_2/genezi  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/ojdbc5.jar  
  inflating: instantclient_11_2/ojdbc6.jar  
  inflating: instantclient_11_2/uidrvci  
  inflating: instantclient_11_2/xstreams.jar

it should look like this after unzip

ls /home/oracle/oreclient_dir

4. Download another zip Instant Client Package – SDK for Oracle Database version on platform Linux x86-64

ls /home/oracle/oreclient_dir/

5. Unzip the file

cd /home/oracle/oreclient_dir

   creating: instantclient_11_2/sdk/
   creating: instantclient_11_2/sdk/include/
  inflating: instantclient_11_2/sdk/include/occi.h  
  inflating: instantclient_11_2/sdk/include/nzt.h  
  inflating: instantclient_11_2/sdk/include/nzerror.h  
  inflating: instantclient_11_2/sdk/include/ldap.h  
   creating: instantclient_11_2/sdk/demo/
  inflating: instantclient_11_2/sdk/SDK_README  
 extracting: instantclient_11_2/sdk/  
  inflating: instantclient_11_2/sdk/ott

6. Download another zip Instant Client Package – SQL*Plus for Oracle Database version on platform Linux x86-64

ls /home/oracle/oreclient_dir/

7. Unzip the file

cd /home/oracle/oreclient_dir


  inflating: instantclient_11_2/SQLPLUS_README  
  inflating: instantclient_11_2/glogin.sql  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/  
  inflating: instantclient_11_2/sqlplus

8. Change bash profile for user Oracle

Add following lines to .bash_profile

cd /home/oracle
vi .bash_profile
# Oracle Settings
export TMP=/tmp

export ORACLE_HOME=/home/oracle/oreclient_dir/instantclient_11_2


export LD_LIBRARY_PATH=$ORACLE_HOME:/lib:/usr/lib;

alias cdoh='cd $ORACLE_HOME'
alias tns='cd $ORACLE_HOME'
alias envo='env | grep ORACLE'


Installation Matrix

Following table shows software certification matrix 64-bit Red Hat Enterprise Linux Release 5 update 6 through Red Hat Enterprise Linux 6

Oracle R Enterprise Open source R or Oracle R Distribution Oracle Database (see Note)

Oracle R Enterprise Open source R or Oracle R Distribution Oracle Database (see Note)
1.5 3.2.x,,
1.4.1 3.0.1, 3.1.1,,
1.4 3.0.1, 3.1.1,,
1.3.1 2.15.1, 2.15.2, 2.15.3,,
1.3 2.15.1,,
1.2 2.15.1,,
1.1 2.13.2,,
1.0 2.13.2,,

So following software will be used:

  • Oracle R Distribution version 3.2.X
  • Oracle R Enterprise Client  version 1.5

Install Oracle R Distribution

Based on installation matrix Oracle R Distribution 3.2.x version will be installed.

As user root modify file public-yum-ol6.repo and set enable=1:

cd /etc/yum.repos.d/
vi public-yum-ol6.repo
 name=Oracle Linux $releasever Add ons ($basearch)

Once it’s done install following package

yum install R-3.2.0

Install Oracle R Enterprise Client

Based on installation matrix Oracle R Enterprise Client ORE 1.5 version will be installed. It’s available in here:

Download following packages ORE 1.5 “Client” and “Supporting” for platform Linux 64-bit.:

Copy them as user root to directory /home/oracle/oreclient_dir) and change owner and group(oracle:oinstall)

cp ore* /home/oracle/oreclient_dir
cd /home/oracle/oreclient_dir
chown oracle:oinstall ore*

Install Oracle R Enterprise Client packages

As user root unizp software

cd /home/oracle/oreclient_dir


  inflating: client/ORE_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREbase_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
 extracting: client/OREcommon_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREdm_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREeda_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREembed_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREgraphics_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREmodels_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREpredict_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
  inflating: client/OREstats_1.5_R_x86_64-unknown-linux-gnu.tar.gz  
 extracting: client/ORExml_1.5_R_x86_64-unknown-linux-gnu.tar.gz  

Install client packages

cd /home/oracle/oreclient_dir/client
R CMD INSTALL ORE_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREbase_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREcommon_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREdm_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREeda_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREembed_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREgraphics_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREmodels_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREpredict_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL OREstats_1.5_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL ORExml_1.5_R_x86_64-unknown-linux-gnu.tar.gz

Install Oracle R Enterprise Supporting packages

As user root unizp software

cd /home/oracle/oreclient_dir


Install supporting packages

cd /home/oracle/oreclient_dir/supporting
R CMD INSTALL arules_1.1-9_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL Cairo_1.5-8_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL DBI_0.3.1_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL png_0.1-7_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL randomForest_4.6-10_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL ROracle_1.2-1_R_x86_64-unknown-linux-gnu.tar.gz
R CMD INSTALL statmod_1.4.21_R_x86_64-unknown-linux-gnu.tar.gz


As user Oracle just type R to start console

[oracle@oel6 client]$ R

Oracle Distribution of R version 3.2.0  (--) -- "Full of Ingredients"
Copyright (C)  The R Foundation for Statistical Computing
Platform: x86_64-unknown-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

  Natural language support but running in an English locale

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

You are using Oracle's distribution of R. Please contact
Oracle Support for any problems you encounter with this


Type this command in console


to start Oracle R Enterprise

> library(ORE)
Loading required package: OREbase
Loading required package: OREcommon

Attaching package: ‘OREbase’

The following objects are masked from ‘package:base’:

    cbind, data.frame, eval, interaction, order, paste, pmax, pmin,
    rbind, table

Loading required package: OREembed
Loading required package: OREstats
Loading required package: MASS
Loading required package: OREgraphics
Loading required package: OREeda
Loading required package: OREmodels
Loading required package: OREdm
Loading required package: lattice
Loading required package: OREpredict
Loading required package: ORExml

to connect to a database run following command. It’s just sample.

> ore.connect(user="test_user", sid="", 
              port=1521, all=TRUE)
Loading required package: ROracle
Loading required package: DBI

Have a fun 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *