Skip to content

Instantly share code, notes, and snippets.

@HanjoStudy

HanjoStudy/roracle.sh

Last active April 4, 2022 13:03
Show Gist options
  • Save HanjoStudy/82fb92e1bc6b0e5adeaafe2364d761d0 to your computer and use it in GitHub Desktop.
Save HanjoStudy/82fb92e1bc6b0e5adeaafe2364d761d0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. HanjoStudy revised this gist Sep 6, 2020. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions roracle.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -29,4 +29,5 @@ echo $PATH
    sqlplus # should give you the command prompt
    #
    # https://cran.r-project.org/web/packages/ROracle/index.html
    wget https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz
    sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/19.8/client64/lib --with-oci-inc=/usr/include/oracle/19.8/client64' ROracle_1.3-1.tar.gz
  2. HanjoStudy revised this gist Sep 6, 2020. 1 changed file with 4 additions and 5 deletions.
    9 changes: 4 additions & 5 deletions roracle.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -3,10 +3,10 @@ https://thraxys.wordpress.com/2016/10/25/install-roracle-on-linux/
    # Downloads -------------------------------------------------------------

    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm
    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm

    # Installs ---------------------------------------------------------------
    sudo alien -i oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
    @@ -29,5 +29,4 @@ echo $PATH
    sqlplus # should give you the command prompt
    #
    # https://cran.r-project.org/web/packages/ROracle/index.html
    wget https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz
    sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/19.8/client64/lib --with-oci-inc=/usr/include/oracle/19.8/client64' ROracle_1.3-1.tar.gz
  3. HanjoStudy revised this gist Sep 6, 2020. 1 changed file with 10 additions and 0 deletions.
    10 changes: 10 additions & 0 deletions roracle.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,13 @@
    https://thraxys.wordpress.com/2016/10/25/install-roracle-on-linux/

    # Downloads -------------------------------------------------------------

    wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
    wget oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm

    # Installs ---------------------------------------------------------------
    sudo alien -i oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
    sudo alien -i oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
    @@ -20,4 +29,5 @@ echo $PATH
    sqlplus # should give you the command prompt
    #
    # https://cran.r-project.org/web/packages/ROracle/index.html
    wget https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz
    sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/19.8/client64/lib --with-oci-inc=/usr/include/oracle/19.8/client64' ROracle_1.3-1.tar.gz
  4. HanjoStudy created this gist Aug 25, 2020.
    23 changes: 23 additions & 0 deletions roracle.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,23 @@
    https://thraxys.wordpress.com/2016/10/25/install-roracle-on-linux/
    # Installs ---------------------------------------------------------------
    sudo alien -i oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
    sudo alien -i oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
    sudo alien -i oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
    sudo alien -i oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
    sudo alien -i oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm
    #
    export LD_LIBRARY_PATH=/usr/lib/oracle/19.8/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}
    export ORACLE_HOME=/usr/lib/oracle/19.8/client64
    export PATH=$PATH:$ORACLE_HOME/bin
    #
    echo "/usr/lib/oracle/19.8/client64/lib" | sudo tee /etc/ld.so.conf.d/oracle.conf
    sudo ldconfig -v

    #
    echo $LD_LIBRARY_PATH
    echo $ORACLE_HOME
    echo $PATH
    sqlplus # should give you the command prompt
    #
    # https://cran.r-project.org/web/packages/ROracle/index.html
    sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/19.8/client64/lib --with-oci-inc=/usr/include/oracle/19.8/client64' ROracle_1.3-1.tar.gz