[R-sig-DB] Intermittent connectivity issues for RJDBC / Oracle
Dirk Eddelbuettel
edd @end|ng |rom deb|@n@org
Fri Oct 5 02:55:46 CEST 2012
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
More information about the R-sig-DB
mailing list