在r中对oracle,关于r：在Mac中安装ROracle

转载于 2021-04-04 21:46:16 发布 · 192 阅读

本文解决在MacOS Sierra上安装ROracle遇到的动态库加载失败问题，提供详细的步骤指导，包括配置Makevars文件及正确指定库路径。

我在Mac OS Sierra上。

我已经尝试过-在OS X Mavericks上安装RODBC / ROracle软件包，但没有帮助。

这是我所做的：

从http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html-基本，Sql plus，odbc下载

解压缩到Instantclient_12_1中的主文件夹中

ln -s libclntsh.dylib.12.1 libclntsh.dylib

导出DYLD_LIBRARY_PATH = /用户/ dhananjaygoel / instantclient_12_1：$ DYLD_LIBRARY_PATH

R CMD安装--configure-args ='-with-oci-lib = / Users / dhananjaygoel / instantclient_12_1'ROracle_1.3-1.tar.gz

它给了我以下错误：

* installing to library ‘/Library/Frameworks/R.framework/Versions/3.3/Resources/library’

* installing *source* package ‘ROracle’ ...

** package ‘ROracle’ successfully unpacked and MD5 sums checked

configure: creating ./config.status

config.status: creating src/Makevars

** libs

clang -I/Library/Frameworks/R.framework/Resources/include -DNDEBUG -I/Users/dhananjaygoel/instantclient_12_1/sdk/include -I/usr/local/include -I/usr/local/include/freetype2 -I/opt/X11/include -fPIC -Wall -mtune=core2 -g -O2 -I/opt/local/include -c rodbi.c -o rodbi.o

rodbi.c:2432:53: warning: format specifies type 'long long' but the argument has

type 'sb8' (aka 'long') [-Wformat]

sprintf(err_buf, RODBI_ERR_BIND_VAL_TOOBIG, bndsz);

^~~~~

/usr/include/secure/_stdio.h:47:56: note: expanded from macro 'sprintf'

__builtin___sprintf_chk (str, 0, __darwin_obsz(str), __VA_ARGS__)

^~~~~~~~~~~

rodbi.c:2469:53: warning: format specifies type 'long long' but the argument has

type 'sb8' (aka 'long') [-Wformat]

sprintf(err_buf, RODBI_ERR_BIND_VAL_TOOBIG, bndsz);

^~~~~

/usr/include/secure/_stdio.h:47:56: note: expanded from macro 'sprintf'

__builtin___sprintf_chk (str, 0, __darwin_obsz(str), __VA_ARGS__)

^~~~~~~~~~~

rodbi.c:2816:55: warning: format specifies type 'long long' but the argument has

type 'sb8' (aka 'long') [-Wformat]

sprintf(err_buf, RODBI_ERR_BIND_VAL_TOOBIG, bndsz);

^~~~~

/usr/include/secure/_stdio.h:47:56: note: expanded from macro 'sprintf'

__builtin___sprintf_chk (str, 0, __darwin_obsz(str), __VA_ARGS__)

^~~~~~~~~~~

rodbi.c:2861:55: warning: format specifies type 'long long' but the argument has

type 'sb8' (aka 'long') [-Wformat]

sprintf(err_buf, RODBI_ERR_BIND_VAL_TOOBIG, bndsz);

^~~~~

/usr/include/secure/_stdio.h:47:56: note: expanded from macro 'sprintf'

__builtin___sprintf_chk (str, 0, __darwin_obsz(str), __VA_ARGS__)

^~~~~~~~~~~

4 warnings generated.

clang -dynamiclib -Wl,-headerpad_max_install_names -undefined dynamic_lookup -single_module -multiply_defined suppress -L/Library/Frameworks/R.framework/Resources/lib -L/usr/local/lib -o ROracle.so rodbi.o rooci.o -L/Users/dhananjaygoel/instantclient_12_1 -lclntsh -F/Library/Frameworks/R.framework/.. -framework R -Wl,-framework -Wl,CoreFoundation

installing to /Library/Frameworks/R.framework/Versions/3.3/Resources/library/ROracle/libs

** R

** inst

** preparing package for lazy loading

** help

*** installing help indices

** building package indices

** testing if installed package can be loaded

Error in dyn.load(file, DLLpath = DLLpath, ...) :

unable to load shared object '/Library/Frameworks/R.framework/Versions/3.3/Resources/library/ROracle/libs/ROracle.so':

dlopen(/Library/Frameworks/R.framework/Versions/3.3/Resources/library/ROracle/libs/ROracle.so, 6): Library not loaded: @rpath/libclntsh.dylib.12.1

Referenced from: /Library/Frameworks/R.framework/Versions/3.3/Resources/library/ROracle/libs/ROracle.so