David,
Thank you for reporting this. I'll make sure to update the INSTALL file that comes with ROracle package to include this information. Unfortunately, this information is not easily available when you download Instant Client. The only place I saw this documented is in the OCI Programmer's Guide at the very bottom of chapter 1 when it talks about SDK for Instant Client. Denis From: David [mailto:da...@serendipityscience.com] Sent: Thursday, October 04, 2012 9:42 PM To: Dirk Eddelbuettel Cc: Denis Mukhin; r-sig-db@r-project.org Subject: Re: [R-sig-DB] Intermittent connectivity issues for RJDBC / Oracle I noticed that but wasn't sure where to get it. Ubuntu doesn't have the file I needed - it is in the oracle client and was present in my LD_LIBRARY_PATH. Why it is looking for libclntsh but erroring out lclntsh I do not know. After some searching I found a similar problem happened in many Oracle client installs.. the fix in my case was to create a soft link as follows in my client directory: root@ss-dev:/home/oracle/instantclient_11_2# ln -s ./libclntsh.so.11.1 ./libclntsh.so Then the ROracle appears to have installed without issue. Thank you for your help. David On Thu, Oct 4, 2012 at 7:55 PM, Dirk Eddelbuettel <HYPERLINK "mailto:e...@debian.org"; \n...@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 | HYPERLINK "mailto:e...@debian.org"e...@debian.org | http://dirk.eddelbuettel.com [[alternative HTML version deleted]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
