7.5.1 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