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 <e...@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 | 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
