Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORE 1.5 installation: ROracle looking for 11.1 client while 12.1 is installed

Christos Iraklis TsatsoulisFeb 16 2016 — edited Apr 26 2016

Hi all,

We are in the process of installing the new ORE 1.5 client packages in a Linux server. Following the documentation, we have successfully installed Oracle DB Instant Client v. 12.1 in the directory /usr/lib/oracle/12.1/client64/lib.

Problem is, ORE fails to load, in fact due to ROracle failure:

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 ‘OREdm’ could not be loaded


It's true that the file libclntsh.so.11.1 does not exist, simply because the client installed is 12.1, and not 11.1:

[ctsats@dev-hd-01 ~]$ cd /usr/lib/oracle/12.1/client64/lib

[ctsats@dev-hd-01 lib]$ ll

total 190276

-rwxrwxr-x 1 root root   6990875 Jul  7  2014 libclntshcore.so.12.1

-rwxrwxr-x 1 root root  58793741 Jul  7  2014 libclntsh.so.12.1

[...]

Checking the respective situation in the latest Oracle Big Data Lite VM 4.3.0.1 (which includes ORE 1.5), I saw that there are several soft/symbolic links, eventually all pointing to the 12.1 client:

[oracle@bigdatalite ~]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/lib

[oracle@bigdatalite lib]$ ll

total 1717944

[...]

lrwxrwxrwx. 1 oracle oinstall        21 2015-12-23 21:49 libclntshcore.so -> libclntshcore.so.12.1

-rwxr-xr-x. 1 oracle oinstall    6994203 2015-12-23 21:49 libclntshcore.so.12.1

lrwxrwxrwx. 1 oracle oinstall    
    17 2015-12-23 21:49 libclntsh.so -> libclntsh.so.12.1
lrwxrwxrwx. 1 oracle oinstall        12 2015-12-23 21:49 libclntsh.so.10.1 -> libclntsh.so
lrwxrwxrwx. 1 oracle oinstall        12 2015-12-23 21:49 libclntsh.so.11.1 -> libclntsh.so

-rwxr-xr-x. 1 oracle oinstall  59492708 2015-12-23 21:49 libclntsh.so.12.1

[...]

Inspired from that, we created a new soft link  libclntsh.so.11.1 -> libclntsh.so.12.1, which resolved the issue.

It seems that ROracle, despite being up to date (version 1.2-1), looks only for the 11.1 client...

My question is: is this behavior expected (after all, what we did feels like a workaround)? If no, what have we missed in the installation procedure?

Many thanks in advance

This post has been answered by Sherry Lamonica-Oracle on Feb 18 2016
Jump to Answer

Comments

Rehan Zahoor

Title "Migrating to cloud native web application" is a bit confusing. It should be "Migrating to cloud native Java SE application with a web client". Web application corresponds to Java EE application in my view.

Thomas O.

Title "Migrating to cloud native web application" is a bit confusing. It should be "Migrating to cloud native Java SE application with a web client". Web application corresponds to Java EE application in my view.

The idea is exactly to show a migration path by re-developing the desktop application as a web application. Instead of a big-bang rewrite of the full application, parts are developed and integrated in the (old) swing application using the webview as integration layer.

User_1XFWY

Have you ever tried Webswing / webswing.org / for this?

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 24 2016
Added on Feb 16 2016
7 comments
3,669 views