default.nix

# https://nixos.org/nixpkgs/manual/#r-packages

let
  pkgs = import <nixpkgs> {};
  stdenv = pkgs.stdenv;
in with pkgs; {
  grouseDev = stdenv.mkDerivation {
    name = "grouseDev";
    version = "1";
    src = if pkgs.lib.inNixShell then null else nix;

    buildInputs = with rPackages; [
      R
      DBI
      ROracle
      rmarkdown
      magrittr
      dplyr
      tidyr
      stringr
      knitr
      kableExtra
      ggplot2
      ggrepel
      openxlsx
    ];
  };
}

shell-log.txt

ORACLE_HOME=/opt/instantclient_12_1 nix-shell . --run 'R'
ERROR: ld.so: object 'libgtk3-nocsd.so.0' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
these derivations will be built:
  /nix/store/2pb67c8vwpvyr5pvrzkkbkbp70diizgv-r-highr-0.7.drv
  /nix/store/61s7w815kgzkl9jnmyvzn3kka2kxi4zl-r-selectr-0.4-1.drv
  /nix/store/hiyxfkd859sm0xwcx3gh5xvmsqxq1nld-r-curl-3.2.drv
  /nix/store/qkjw2h6kn677gnsff5ch19b67m5klclw-r-openssl-1.1.drv
  /nix/store/r8yfvd32xgcv5jjiqshqn7xzkqq88a6n-r-mime-0.6.drv
  /nix/store/ry5645gh38zih0nlijjjgr3b5acz37jw-r-jsonlite-1.6.drv
  /nix/store/6pfjwsg0br8jzajywk49gj6dflw8z56c-r-httr-1.4.0.drv
  /nix/store/djnb9c5ciwjfk965g9mwxmc0mb1xsqda-r-xml2-1.2.0.drv
  /nix/store/4rjnqrzbrpnm6s641yvhsb61bgf14l3b-r-rvest-0.3.2.drv
  /nix/store/ifcl7yw0gmgqclzflp623d9m0ah67kyh-r-xfun-0.4.drv
  /nix/store/5a85w9ynb5f6rc9xpk0dlgfwi0jyfjjv-r-tinytex-0.9.drv
  /nix/store/zmm34iqc2xpzr7wl1mr5pjqlpmd0phjs-r-clipr-0.4.1.drv
  /nix/store/zrdxlzq2972dcsww0qxxyb8kibm6pm8m-r-hms-0.4.2.drv
  /nix/store/5ay7bxrhc2schpfxfqqhl1cnjxkjrvx5-r-readr-1.3.1.drv
  /nix/store/7lbrmdwll39g61fcab1s29yii8vsxjl2-r-rstudioapi-0.8.drv
  /nix/store/7niv57gbjw2p1rizw5gaack4qfcvmhm0-r-ROracle-1.3-1.drv
  /nix/store/8r84y517prj2vghhz9g495i6wwbcvmky-r-yaml-2.2.0.drv
  /nix/store/97l6xjz7mayyx5mdlirv8fa92jzcd774-r-ggrepel-0.8.0.drv
  /nix/store/lmsv2ry9sx3wcs1mr0yr5qq0dwy0zhqq-r-evaluate-0.12.drv
  /nix/store/ms3w6aa157zx7b8230y1gabh48blqjci-r-markdown-0.9.drv
  /nix/store/c0hc3x5wsp4nw8kcj7c3vcbvw5c0vjdk-r-knitr-1.21.drv
  /nix/store/jcgq9r29kl8yi7q3qxdgsmfsjfy4vrxi-r-base64enc-0.1-3.drv
  /nix/store/llpx02a47gkpdhps0689wxixcfakvdxv-r-htmltools-0.3.6.drv
  /nix/store/b2jzmgqlxp9j9fab4af6pzn5ls07cy6q-r-rmarkdown-1.11.drv
  /nix/store/cm24vjd76y7gv46aig35n2qkwsq3x0dm-r-kableExtra-0.9.0.drv
  /nix/store/xvgqxyxynfiqinksxhzj113jnjzdkf0q-r-zip-1.0.0.drv
  /nix/store/fm4w05c1mid35v72c5zhdza0j7njspjr-r-openxlsx-4.1.0.drv
these paths will be fetched (11.73 MiB download, 41.09 MiB unpacked):
  /nix/store/41hyf5ax5507qlhmqy9114f43c3grm3m-r-tidyselect-0.2.5
  /nix/store/k0fchz97ig5wrxjl38iy963csv9y8n92-r-ggplot2-3.1.0
  /nix/store/q8a6q4mlz5mn28v6j2q0pkvn6hhablwb-r-purrr-0.2.5
  /nix/store/skmmcx1x1ddzi8iv289x29wcbvkdkw21-r-tidyr-0.8.2
  /nix/store/y3j2nd1agc9ajrzrlzbbnyzhld7r6gaq-r-dplyr-0.7.8
copying path '/nix/store/k0fchz97ig5wrxjl38iy963csv9y8n92-r-ggplot2-3.1.0' from 'https://cache.nixos.org'...
ERROR: ld.so: object 'libgtk3-nocsd.so.0' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
copying path '/nix/store/q8a6q4mlz5mn28v6j2q0pkvn6hhablwb-r-purrr-0.2.5' from 'https://cache.nixos.org'...
building '/nix/store/7niv57gbjw2p1rizw5gaack4qfcvmhm0-r-ROracle-1.3-1.drv'...
unpacking sources
unpacking source archive /nix/store/yb5kn20p8cwp4vxh2kbgaagxs8svxsff-ROracle_1.3-1.tar.gz
source root is ROracle
setting SOURCE_DATE_EPOCH to timestamp 1477471062 of file ROracle/MD5
patching sources
configuring
building
running tests
installing
* installing *source* package 'ROracle' ...
** package 'ROracle' successfully unpacked and MD5 sums checked
configure: error: OCI libraries not found
ERROR: configuration failed for package 'ROracle'
* removing '/nix/store/d65mmv45cczwkjfqwp3vl18nbrac1jdm-r-ROracle-1.3-1/library/ROracle'
builder for '/nix/store/7niv57gbjw2p1rizw5gaack4qfcvmhm0-r-ROracle-1.3-1.drv' failed with exit code 1
error: build of '/nix/store/7niv57gbjw2p1rizw5gaack4qfcvmhm0-r-ROracle-1.3-1.drv', '/nix/store/97l6xjz7mayyx5mdlirv8fa92jzcd774-r-ggrepel-0.8.0.drv', '/nix/store/aqadjczhl5qbp4kqllkw4qrjj4l3zwii-r-dplyr-0.7.8.drv', '/nix/store/b2jzmgqlxp9j9fab4af6pzn5ls07cy6q-r-rmarkdown-1.11.drv', '/nix/store/c0hc3x5wsp4nw8kcj7c3vcbvw5c0vjdk-r-knitr-1.21.drv', '/nix/store/cm24vjd76y7gv46aig35n2qkwsq3x0dm-r-kableExtra-0.9.0.drv', '/nix/store/fm4w05c1mid35v72c5zhdza0j7njspjr-r-openxlsx-4.1.0.drv', '/nix/store/kh9rafxkaaplkmfqf8j9ilj8av6v4ddl-r-tidyr-0.8.2.drv' failed