Installing ROracle Library

Prerequisites

DBI is one of the dependencies for using this library.

• Installing DBI
  1. curl- O https://cran.r-project.org/src/contrib/DBI_1.1.1.tar.gz
  2. R CMD INSTALL DBI_1.1.1.tar.gz

Procedure

To install ROracle Library, follow these steps:

• For ORD 3.6.1/R 4.1.2
  1. curl- O https://cran.r-project.org/src/contrib/ROracle_1.3-1.1.tar.gz
  2. Install Oracle Instant Client Sdk Package. This is required for additional header files and an example makefile for developing Oracle Applications with Instant Client.
  3. Oracle client lib must be present in PATH. In the .profile file, set PATH to include the appropriate $ORACLE_HOME/bin path.

     For example:

     PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin

  4. R CMD INSTALL --configure-args='--with-oci-lib=<absolute-path-to-oracle-client-lib> --with-oci-inc=<absolute path to instantclient_21_5>/include' ROracle_1.3-1.1.tar.gz

     For example:

     R CMD INSTALL --configure-args='--with-oci-lib=/scratch/users/oracle/app/oracle/product/19.3.0/client_1/lib --with-oci-inc=/scratch/users/oracle/instantclient-sdk/instantclient_21_5/sdk/include' ROracle_1.3-1.1.tar.gz