7.3 Downgrade Oracle Machine Learning for R

You can downgrade OML4R to the current release 2.0 from any previous release 1.5.1 by reinstalling the product.

To downgrade OML4R and migrate your data:

1. Ensure that you have the version of R that is required for the OML4R 1.5.1 that you are downgrading to. OML4R 1.5.1 has two versions, one is built on R 3.3.0 and the other is built on R 3.6.1.

   See the table of configuration requirements and server support in Oracle Machine Learning for R System Requirements for On-Premises Database for the R requirement.

   To downgrade R, do the following:

   1. Back up your OML4R user schema, data store objects, R scripts, and the RQSYS schema.

   2. Remove the Oracle R Distribution RPMs or open source R components.

   3. Install the required R version, then proceed to next step.

2. To upgrade OML4R 2.0 Server for Oracle Database Release 19c and 21c, run the server.sh or server.bat script to perform a downgrade.

   Instructions for downgrading from OML4R 2.0 to 1.5.1.

   1. Prepare the downgrade scripts
      1. Go to the Oracle Machine Learning for R Downloads page, accept the license agreement, and download the OML4R 2.0 Server packages to an installation directory, such as /oml4rserver_2.0_install_dir/. Download the OML4R 1.5.1 Server packages to an installation directory, such as /oml4rserver_1.5.1_install_dir/.
      2. Go to the 2.0 installation directory and unzip the downloaded file using the following command:

         $ cd /oml4rserver_2.0_install_dir/

         $ unzip ore-server-platform-arch-2.0.zip

      3. Go to the 1.5.1 installation directory, unzip the server folder from the downloaded file to the 2.0 installation directory.

         $ cd /oml4rserver_1.5.1_install_dir/

         $ unzip -o -d /oml4rserver_2.0_install_dir/ ore-server-platform-arch-1.5.1.zip "server/*"

   2. Run the OML4R 2.0 server.sh or server.bat script with downgrade option -d <downgrade version>.When the script detects your downgrade option and verifies you have a later version of OML4R server installed, it asks if you want to downgrade. Type Yes to start the downgrade. (Type No to abort the process).

      $ cd /oml4rserver_2.0_install_dir/

      $ ./server.sh -d 1.5.1

      Current configuration

      R Version ........................ Oracle Distribution of R version 3.6.1 (--)

      R_HOME ...........................<R_HOME>

      R_LIBS_USER ......................<R_LIBS_USER>

      ORACLE_HOME ......................<ORACLE_HOME>

      ORACLE_SID .......................<ORACLE_SID>

      PDB ..............................<PDB_NAME>

      Existing R Version ...............Oracle Distribution of R version 3.6.1 (--)

      Existing R_HOME ..................<R_HOME>

      Existing ORE data ................ 2.0

      Existing ORE code ................ 2.0

      Existing ORE libraries ........... 2.0

      Downgrading to ORE ............... 1.5.1

      RQSYS PERMANENT tablespace .......<PERM_TABLESPACE>

      RQSYS TEMPORARY tablespace .......<TEMP_TABLESPACE>

      Operation ........................Downgrade Proceed? [yes] yes

      Removing R libraries ............... Pass

      Removing ORE libraries ............. Pass

      Installing R libraries ............. Pass

      Installing ORE libraries ........... Pass

      Downgrading RQSYS 1.5.1 ............ Pass

      Removing ORE packages .............. Pass

      Installing ORE packages ............ Pass

      Removing ORE script ................ Pass

      Creating ORE script ................ Pass

      Installing supporting packages ..... Pass

      Done

3. To downgrade OML4R Client:

   1. Uninstall the OML4R 2.0 packages and supporting packages. To uninstall OML4R 2.0 packages, see Uninstall OML4R Client.
   2. Install the OML4R 1.5.1 packages and supporting packages. See Install the Oracle Machine Learning for R Packages and Install the OML4R Supporting Packages.