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:
|
--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
Parent topic: Uninstall Oracle Machine Learning for R