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

[David]

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 <edd 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 | edd using debian.org | http://dirk.eddelbuettel.com
>

	[[alternative HTML version deleted]]