[R-sig-DB] Intermittent connectivity issues for RJDBC / Oracle

[Denis Mukhin]

David,

�

Thank you for reporting this. I'll make sure to update the INSTALL file that comes with ROracle package to include this information. Unfortunately, this information is not easily available when you download Instant Client. The only place I saw this documented is in the OCI Programmer's Guide at the very bottom of chapter 1 when it talks about SDK for Instant Client.

�

Denis

�

From: David [mailto:david using serendipityscience.com] 
Sent: Thursday, October 04, 2012 9:42 PM
To: Dirk Eddelbuettel
Cc: Denis Mukhin; r-sig-db using r-project.org
Subject: Re: [R-sig-DB] Intermittent connectivity issues for RJDBC / Oracle

�

I noticed that but wasn't sure where to get it. �Ubuntu doesn't have the file I needed - it is in the oracle client and was present in my LD_LIBRARY_PATH. �Why it is looking for libclntsh but erroring out lclntsh I do not know.

�

After some searching I found a similar problem happened in many Oracle client installs.. the fix in my case was to create a soft link as follows in my client directory:

root using ss-dev:/home/oracle/instantclient_11_2# ln -s ./libclntsh.so.11.1 ./libclntsh.so

�

Then the ROracle appears to have installed without issue.

�

Thank you for your help.

�

David�

�

�

On Thu, Oct 4, 2012 at 7:55 PM, Dirk Eddelbuettel <HYPERLINK "mailto:edd using debian.org" \nedd using debian.org> wrote:


On 4 October 2012 at 19:38, David wrote:
| and ran these commands...

You need to pay attention to the errors:

| � � root using ss-dev:/home/R/Downloads# export OCI_LIB=/home/oracle/
| � � instantclient_11_2
| � � root using ss-dev:/home/R/Downloads# export LD_LIBRARY_PATH=/home/oracle/
| � � instantclient_11_2:$LD_LIBRARY_PATH
| � � root using ss-dev:/home/R/Downloads# R CMD INSTALL ROracle_1.1-5.tar.gz
| � � * installing to library �/usr/local/lib/R/site-library�
| � � * installing *source* package �ROracle� ...
| � � ** package �ROracle� successfully unpacked and MD5 sums checked
| � � configure: creating ./config.status
| � � config.status: creating src/Makevars
| � � ** libs
| � � gcc -std=gnu99 -I/usr/share/R/include -I/home/oracle/instantclient_11_2/sdk
| � � /include � � -fpic �-O3 -pipe �-g -c rodbi.c -o rodbi.o
| � � gcc -std=gnu99 -I/usr/share/R/include -I/home/oracle/instantclient_11_2/sdk
| � � /include � � -fpic �-O3 -pipe �-g -c rooci.c -o rooci.o
| � � gcc -std=gnu99 -shared -o ROracle.so rodbi.o rooci.o -L/home/oracle/
| � � instantclient_11_2 -lclntsh -L/usr/lib/R/lib -lR
| � � /usr/bin/ld: cannot find -lclntsh
� � � ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I have no idea what that is and where it comes from, but
http://package.ubuntu.com allows you to search for it.

Dirk

| � � collect2: ld returned 1 exit status
| � � make: *** [ROracle.so] Error 1
| � � ERROR: compilation failed for package �ROracle�
| � � * removing �/usr/local/lib/R/site-library/ROracle�
|
|
| As root (thinking to avoid permission issues..) �The OS is Ubuntu:
|
|
| � � R using ss-dev:/home/oracle/instantclient_11_2$ uname -a
| � � Linux ss-dev 3.2.0-29-generic #46-Ubuntu SMP Fri Jul 27 17:03:23 UTC 2012
| � � x86_64 x86_64 x86_64 GNU/Linux

--
Dirk Eddelbuettel | HYPERLINK "mailto:edd using debian.org"edd using debian.org | http://dirk.eddelbuettel.com

�

	[[alternative HTML version deleted]]