[prev in list] [next in list] [prev in thread] [next in thread] 

List:       r-sig-db
Subject:    Re: [R-sig-DB] Intermittent connectivity issues for RJDBC / Oracle
From:       "MacQueen, Don" <macqueen1 () llnl ! gov>
Date:       2012-10-17 19:52:29
Message-ID: CCA458AF.AF973%macqueen1 () llnl ! gov
[Download RAW message or body]

Regarding the message "cannot find -lclntsh",
and according to my old notes, it may be necesssary to to run

  genclntsh
  genclntst

in ORACLE_HOME/bin.

This creates or fixes the missing lib. Two of them, actually.
Note that it's an Oracle issue, not an ROracle issue.

This information was, at least in the past, in the INSTALL file in the
inst directory in the ROracle source distribution (it was there in
ROracle_0.5-9).

I have no idea if this is still necessary.

-Don


-- 
Don MacQueen

Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062





On 10/4/12 5:55 PM, "Dirk Eddelbuettel" <edd@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@ss-dev:/home/R/Downloads# export OCI_LIB=/home/oracle/
>|     instantclient_11_2
>|     root@ss-dev:/home/R/Downloads# export LD_LIBRARY_PATH=/home/oracle/
>|     instantclient_11_2:$LD_LIBRARY_PATH
>|     root@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@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@debian.org | http://dirk.eddelbuettel.com
>
>_______________________________________________
>R-sig-DB mailing list -- R Special Interest Group
>R-sig-DB@r-project.org
>https://stat.ethz.ch/mailman/listinfo/r-sig-db

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db
[prev in list] [next in list] [prev in thread] [next in thread]