Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Installing and loading ROracle with R4.3 on Windows 10: LoadLibrary failure

user-b9n84Jul 5 2023

Hi,

When installing (compiling) and loading the ROracle package (ROracle_1.3-2.tar.gz) with R4.3 I obviously run into permission issues when loading the library. (In general, I was following the instructions documented in this post https://forums.oracle.com/ords/apexds/post/roracle-for-r-4-0-0-or-newer-3791)..) As suggested there I used the command remotes::install_local("C:/projects/_Rpackages_custom/ROracle_1.3-2.tar.gz", repos = NULL, type = "source") and tried different approaches:

  • Default: Compiling ROracle stops very late when testing library loading where an LoadLibrary error is thrown ("unable to load shared object ‘C:/Users/<…>/AppData/Local/R/win-library/4.3/00LOCK-ROracle/00new/ROracle/libs/x64/ROracle.dll’: LoadLibrary failure")
  • Compiling without testing library loading, i.e., add the option INSTALL_opts = “--no-test-load” to the install_local() command above: Now, compilation runs smoothly to the end without errors. Loading the library, however, throws an error ("unable to load shared object 'C:/Users/<…>/AppData/Local/R/win-library/4.3/ROracle/libs/x64/ROracle.dll': LoadLibrary failure: Zugriff verweigert" [Access denied]). I checked the file permissions of the ROracle.dll but couldn't see any difference compared to other libraries in my local user library of R packages.
  • Running RStudio with admin rights: Package compilation incl. testing of library loading runs smoothly but then I cannot load the library when running RStudio as a normal user

To sum up, installation basically works fine but during this procedure a permission seems to be set which then prevents from library loading as a normal user.

Any idea how to resolve this? Either avoid that these permissions are set during installation or appropriately modifying permissions afterwards in the library?

Thanks in advance,

Tobi

Comments
Post Details
Added on Jul 5 2023
1 comment
542 views