Uninstall Oracle Machine Learning for R

Instructions for uninstalling OML4R

This topic contains these sections:

Uninstall OML4R Server from Oracle Database 18c or Later

How to uninstall OML4R from Oracle Database Release 18c or later.

The rquncfg.sql script uninstalls the database functions and procedures that are associated with OML4R. It does not remove the OML4R libraries in $ORACLE_HOME/lib because these are shipped with Oracle Database. Also, it does not remove the OML4R packages in $ORACLE_HOME/R/library.

To uninstall OML4R Server components, run the rquncfg.sql script.

1. Change directories to $ORACLE_HOME/R/server.

   $ cd $ORACLE_HOME/R/server

2. If you are using a PDB, connect to it.

   $ ALTER SESSION SET CONTAINER = pdbname;

3. In SQL, run the uninstall script. The script takes a single input, which is the $ORACLE_HOME location. In the following example, the value of the ORACLE_HOME environment variable is /u01/app/oracle/product/18.0.0/dbhome_1.

   SQL> @rquncfg.sql
   Session altered.
   Enter value for 1: /u01/app/oracle/product/18.0.0/dbhome_1

Uninstall OML4R Server from Oracle Database 12c and Earlier

To uninstall OML4R Server, run the server script with the --uninstall option.

You can perform either a full or a partial uninstall. A partial uninstall is performed by default.

WARNING:

Do not use the server.sh script to uninstall Oracle Machine Learning for R components from Oracle Database Release 18c or Release 19c. Doing so results in important files being deleted from the database. Instead, for an 18c or later database, use the rquncfg.sql script.

This topic has the following sections:

Performing a Partial Uninstall

A partial uninstall removes the RQSYS metadata and PL/SQL packages from the database but leaves the libraries and R packages that support OML4R Server in Oracle home.

If OML4R Server support is installed in more than one database instance in the same Oracle home, or if it is installed in a pluggable database (PDB), then a partial uninstall removes OML4R Server support from the specified database without affecting the other databases. The server script performs a partial uninstall by default.

Note:

If you accidentally perform a full uninstall for one of the instances or PDBs that share support for OML4R Server, then the other shared instances or PDBs will no longer support OML4R Server. You can easily restore OML4R Server support in Oracle home by rerunning the server script to perform an installation in one of the shared instances or PDBs.

If you run the server script with the -u option, then a partial uninstall is performed. You can specify the --keep option to explicitly request a partial uninstall. The following commands all perform a partial uninstall of OML4R Server:

./server.sh  --uninstall  
./server.sh  -u
./server.sh  -u --keep
./server.sh  --uninstall  --keep

Performing a Full Uninstall

A full uninstall removes the RQSYS schema metadata and PL/SQL code from the database and removes all OML4R Server libraries and R packages from Oracle home.

The following commands each perform a full uninstall of OML4R Server:

./server.sh --uninstall --full  
./server.sh -u  -full

Note:

If you accidentally perform a full uninstall in a shared Oracle home, then rerun the server script to reinstall OML4R Server support. See Performing a Partial Uninstall for details.

Uninstall OML4R Client

Instructions for uninstalling OML4R Client.

To uninstall the OML4R packages and supporting packages, start R and type the commands listed in the following example.

Example 7-1 R Commands for Uninstalling OML4R Packages

remove.packages("arules")
remove.packages("DBI")
remove.packages("Cairo")
remove.packages("ORE")
remove.packages("OREbase")
remove.packages("OREcommon")
remove.packages("OREdm")
remove.packages("OREdplyr")
remove.packages("OREeda")
remove.packages("OREembed")
remove.packages("OREgraphics")
remove.packages("OREmodels")
remove.packages("OREpredict")
remove.packages("OREstats")
remove.packages("ORExml")
remove.packages("png")
remove.packages("randomForest")
remove.packages("ROracle")
remove.packages("statmod")