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

[Dirk Eddelbuettel]

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