7.4.1 Uninstall OML4R Server from Oracle Database 23ai

Follow the below steps to uninstall OML4R from Oracle Database Release 23ai.

Note:

When uninstalling OML4R server in a multitenant container database, first uninstall from the PDBs, then uninstall from CDB$ROOT. Otherwise, the PDBs may become restricted due to database option mismatch.

The server.sh script supports below command-line arguments to uninstall OML4R server. The script can be run in interactive mode, in batch mode, or in hybrid mode.

Command Description
-u, --uninstall

Uninstall OML4R Server:

  • When used with --keep (the default), the script removes the RQSYS metadata and PL/SQL packages from the database but retains the libraries and R packages under Oracle home (partial uninstall).
  • When used with --full, the script removes the libraries and R packages under Oracle home in addition to the RQSYS metadata and PL/SQL packages in the database. (full uninstall).
--pdb NAME

The name of a pluggable database (PDB) in a multitenant container database (CDB).

Multitenant architecture enables an Oracle database to function as a container database that includes zero, one, or many pluggable databases. For information about multitenant architecture, see Oracle Database Concepts.

To view a full list of supported arguments, see Table 4-*.

Performing a Partial Uninstall

In a partial uninstall, the OML4R server components are removed from the corresponding container database. 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.

In the interactive mode, the script prompts a warning message as follows:

If you uninstall OML4R from CDB$ROOT, PDB may be restricted due to database option mismatch

Also, checks if you want to perform the operation in a root container. If you type no, it prompts you to choose a PDB for the uninstall.

Below is an example to partially uninstall OML4R server from a PDB.

$ ./server.sh -u --keep
 
Oracle R Enterprise 2.0 Server.
 
Copyright (c) 2012, 2022 Oracle and/or its affiliates. All rights reserved.
 
Checking platform .................. Pass
Checking R ......................... Pass
Checking R libraries ............... Pass
Checking ORACLE_HOME ............... Pass
Checking ORACLE_SID ................ Pass
Checking sqlplus ................... Pass
Checking ORACLE instance ........... Pass
Checking CDB/PDB ...................   WARNING: If you uninstall OML4R from CDB$ROOT, PDB may be restricted due to database option mismatch
  Perform operation in a root container? [yes or no]no
  PDB to use for ORE uninstallation [list]: 
ORCLPDB
  PDB to use for ORE uninstallation [list]: ORCLPDB
Checking CDB/PDB ................... Pass
Checking ORE ....................... Pass
 
Current configuration
  R Version ........................ R version 4.4.1 (2024-06-14)
  R_HOME ........................... /usr/lib64/R
  R_LIBS_USER ...................... <ORACLE HOME PATH>/R/library
  ORACLE_HOME ...................... <ORACLE HOME PATH>
  ORACLE_SID ....................... orcl
  PDB .............................. ORCLPDB
 
  Existing R Version ............... R version 4.4.1 (2024-06-14)
  Existing R_HOME .................. /usr/lib64/R
  Existing ORE data ................ 2.0
  Existing ORE code ................ 2.0
  Existing ORE libraries ........... 2.0
 
  RQSYS PERMANENT tablespace ....... SYSAUX
  RQSYS TEMPORARY tablespace ....... TEMP
 
  Operation ........................ Uninstall (PARTIAL)
 
Proceed? [yes] y
 
Removing database configurations ... Pass
 
Done

Performing a Full Uninstall

Below is an example to fully uninstall OML4R server from CDB$ROOT. This removes the OML4R packages and libraries in addition to the server components from the database.

$ ./server.sh -u --full
 
Oracle R Enterprise 2.0 Server.
 
Copyright (c) 2012, 2022 Oracle and/or its affiliates. All rights reserved.
 
Checking platform .................. Pass
Checking R ......................... Pass
Checking R libraries ............... Pass
Checking ORACLE_HOME ............... Pass
Checking ORACLE_SID ................ Pass
Checking sqlplus ................... Pass
Checking ORACLE instance ........... Pass
Checking CDB/PDB ...................   WARNING: If you uninstall OML4R from CDB$ROOT, PDB may be restricted due to database option mismatch
  Perform operation in a root container? [yes or no]yes
Pass
Checking ORE ....................... Pass
 
Current configuration
  R Version ........................ R version 4.4.1 (2024-06-14)
  R_HOME ........................... /usr/lib64/R
  R_LIBS_USER ...................... <ORACLE HOME PATH>/R/library
  ORACLE_HOME ...................... <ORACLE HOME PATH>
  ORACLE_SID ....................... orcl
  CDB .............................. CDB$ROOT
 
  Existing R Version ............... R version 4.4.1 (2024-06-14)
  Existing R_HOME .................. /usr/lib64/R
  Existing ORE data ................ 2.0
  Existing ORE code ................ 2.0
  Existing ORE libraries ........... 2.0
 
  RQSYS PERMANENT tablespace ....... SYSAUX
  RQSYS TEMPORARY tablespace ....... TEMP
 
  Operation ........................ Uninstall (FULL)
 
Proceed? [yes] y
 
Removing R libraries ............... Pass
Removing ORE libraries ............. Pass
Removing database configurations ... Pass
Removing ORE packages .............. Pass
Removing ORE script ................ Pass
Removing migration scripts ......... Pass
 
Done