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

[MacQueen, Don]

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 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
>
>_______________________________________________
>R-sig-DB mailing list -- R Special Interest Group
>R-sig-DB using r-project.org
>https://stat.ethz.ch/mailman/listinfo/r-sig-db