Intermittent connectivity issues for RJDBC / Oracle

| 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