Unable to load library(ROracle) in Rshiny Server

87 views

Skip to first unread message

unread,

Jun 16, 2016, 3:30:06 AM6/16/16

to Shiny - Web Framework for R

Installed the Oracle DB Instant Client 11.2 in Red hat server but fail to load ROracle

Library(ROracle)

Loading required package: DBI

Error in dyn.load(file, DLLpath = DLLpath, ...) :

unable to load shared object '/usr/lib64/R/library/ROracle/libs/ROracle.so':

libclntsh.so.11.1: cannot open shared object file: No such file or directory

Error: package or namespace load failed for ‘ROracle’

Execution halted

What i need to do resolve this issue?

unread,

Jun 16, 2016, 3:59:15 PM6/16/16

to Shiny - Web Framework for R

Hi,

I think you need to set the library paths that should fix the problem and also set the R environment with

LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64/lib:/home/nguiller/Downloads/instantclient_11_2"

ORACLE_HOME="/usr/lib/oracle/11.2/client64/:/home/nguiller/Downloads/instantclient_11_2"