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 at 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 at 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 at ss-dev:/home/R/Downloads# export OCI_LIB=/home/oracle/
| instantclient_11_2
| root at ss-dev:/home/R/Downloads# export LD_LIBRARY_PATH=/home/oracle/
| instantclient_11_2:$LD_LIBRARY_PATH
| root at 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 at 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 at debian.org | http://dirk.eddelbuettel.com