4.3.1 Prepare to Use OML4R Server with R-4.4.1 or Later

Instructions for downloading and installing the OML4R Server packages built under R-4.4.1.

In Oracle Database 23.7, the OML4R Server packages are shipped in the $ORACLE_HOME/R/library/ directory. If you are using R-4.4.1, you can either rename or delete the existing OML4R packages in that directory. Afterward, download and install the OML4R Server packages that are compatible with your R version.

These instructions rename the original OML4R Server packages and replace them with versions built using R-4.4.1.

1. Rename the OML4R packages in the $ORACLE_HOME/R/library/ directory:

   cd $ORACLE_HOME/R/library
   
   mv ORE ORE.orig
   mv OREbase OREbase.orig
   mv OREcommon OREcommon.orig
   mv OREdm OREdm.orig
   mv OREdplyr OREdplyr.orig
   mv OREeda OREeda.orig
   mv OREembed OREembed.orig
   mv OREgraphics OREgraphics.orig
   mv OREmodels OREmodels.orig
   mv OREpredict OREpredict.orig
   mv OREserver OREserver.orig
   mv OREstats OREstats.orig
   mv ORExml ORExml.orig
   

2. Go to the Oracle Machine Learning for R Downloads page, accept the license agreement, and download the R-4.4.1 compatible OML4R Server and Supporting packages to an installation directory, such as /oml4rserver_install_dir/.

   Note:

   Use the same installation directory for all OML4R components.
3. Go to the installation directory and unzip the downloaded file.

   $ cd /oml4rserver_install_dir/
   $ unzip oml4r-server-r4.4.1-linux8-x86-64-2.0.zip
   $ unzip oml4r-supporting-r4.4.1-linux8-x86-64-2.0.zip

   When you unzip the file, the /server directory is created, and the following files are extracted into it:

   $ ls server
   librqe.so                                          rqd0706000.sql
   migration                                          rqd0807000.sql
   omlrdbmig.sql                                      rqd0908000.sql
   omlrdwgrd.sql                                      rqdrp.sql
   omlre21.sql                                        rqgrant.sql
   omlrrelod.sql                                      rqpdrp00.sql
   omlru21.sql                                        rqpdrp01.sql
   ORE_2.0_R_x86_64-unknown-linux-gnu.tar.gz          rqpdrp02.sql
   OREbase_2.0_R_x86_64-unknown-linux-gnu.tar.gz      rqpdrp03.sql
   OREcommon_2.0_R_x86_64-unknown-linux-gnu.tar.gz    rqpdrp04.sql
   OREdm_2.0_R_x86_64-unknown-linux-gnu.tar.gz        rqpdrp05.sql
   OREdplyr_2.0_R_x86_64-unknown-linux-gnu.tar.gz     rqpdrp06.sql
   OREeda_2.0_R_x86_64-unknown-linux-gnu.tar.gz       rqpdrp07.sql
   OREembed_2.0_R_x86_64-unknown-linux-gnu.tar.gz     rqpdrp08.sql
   OREgraphics_2.0_R_x86_64-unknown-linux-gnu.tar.gz  rqpdrp09.sql
   OREmodels_2.0_R_x86_64-unknown-linux-gnu.tar.gz    rqproc.sql
   OREpredict_2.0_R_x86_64-unknown-linux-gnu.tar.gz   rqsys.sql
   OREserver_2.0_R_x86_64-unknown-linux-gnu.tar.gz    rqu0001000.sql
   ore.so                                             rqu0102000.sql
   OREstats_2.0_R_x86_64-unknown-linux-gnu.tar.gz     rqu0203000.sql
   ORExml_2.0_R_x86_64-unknown-linux-gnu.tar.gz       rqu0304000.sql
   rqadmin.sql                                        rqu0405000.sql
   rqcfg.sql                                          rqu0506000.sql
   rqcrt.sql                                          rqu0607000.sql
   rqd0100000.sql                                     rqu0708000.sql
   rqd0201000.sql                                     rqu0809000.sql
   rqd0302000.sql                                     rquncfg.sql
   rqd0403000.sql                                     rquser.sql
   rqd0504000.sql                                     rqviw.sql
   rqd0605000.sql
   

The content for supporting directories file appears as follows:

$ ls supporting/
arules_1.7-3_R_x86_64-unknown-linux-gnu.tar.gz
assertthat_0.2.1_R_x86_64-unknown-linux-gnu.tar.gz
Cairo_1.6-2_R_x86_64-unknown-linux-gnu.tar.gz
cli_3.3.0_R_x86_64-unknown-linux-gnu.tar.gz
crayon_1.5.1_R_x86_64-unknown-linux-gnu.tar.gz
DBI_1.1.2_R_x86_64-unknown-linux-gnu.tar.gz
dplyr_1.0.9_R_x86_64-unknown-linux-gnu.tar.gz
ellipsis_0.3.2_R_x86_64-unknown-linux-gnu.tar.gz
fansi_1.0.3_R_x86_64-unknown-linux-gnu.tar.gz
generics_0.1.2_R_x86_64-unknown-linux-gnu.tar.gz
glue_1.6.2_R_x86_64-unknown-linux-gnu.tar.gz
lazyeval_0.2.2_R_x86_64-unknown-linux-gnu.tar.gz
lifecycle_1.0.1_R_x86_64-unknown-linux-gnu.tar.gz
magrittr_2.0.3_R_x86_64-unknown-linux-gnu.tar.gz
pillar_1.8.1_R_x86_64-unknown-linux-gnu.tar.gz
pkgconfig_2.0.3_R_x86_64-unknown-linux-gnu.tar.gz
png_0.1-8_R_x86_64-unknown-linux-gnu.tar.gz
purrr_0.3.4_R_x86_64-unknown-linux-gnu.tar.gz
R6_2.5.1_R_x86_64-unknown-linux-gnu.tar.gz
rlang_1.0.2_R_x86_64-unknown-linux-gnu.tar.gz
ROracle_1.5-0_R_x86_64-unknown-linux-gnu.tar.gz
statmod_1.4.36_R_x86_64-unknown-linux-gnu.tar.gz
tibble_3.2.1_R_x86_64-unknown-linux-gnu.tar.gz
tidyselect_1.1.2_R_x86_64-unknown-linux-gnu.tar.gz
utf8_1.2.2_R_x86_64-unknown-linux-gnu.tar.gz
vctrs_0.4.2_R_x86_64-unknown-linux-gnu.tar.gz

Note:

If you have not installed OML4R 2.0 before, follow the steps in the section Install OML4R Server Using server.sh.

If you already have the OML4R 2.0 server (based on R 4.0.5) installed and want to upgrade to use R 4.4.1, you only need to install the OML4R 2.0 packages, libraries and supporting packages compatible with R 4.4.1, follow the steps in the section, Install OML4R 2.0 Packages and Supporting Packages on the OML4R Server.