Upgrade or Downgrade Oracle Machine Learning for SQL
Upgrade and downgrade Oracle Machine Learning for SQL by following the steps listed.
Upgrade Oracle Machine Learning for SQL
You can upgrade your database by using the Database Upgrade Assistant (DBUA) or you can perform a manual upgrade using export/import utilities.
All models and machine learning metadata are fully integrated with the Oracle Database upgrade process whether you are upgrading from 19c or from earlier releases.
Upgraded models continue to work as they did in prior releases. Both upgraded models and new models that you create in the upgraded environment can make use of the new machine learning functionality introduced in the new release.
Related Topics
Use Database Upgrade Assistant to Upgrade Oracle Machine Learning for SQL
Oracle Database Upgrade Assistant provides a graphical user interface that guides you interactively through the upgrade process.
On Windows platforms, follow these steps to start the Upgrade Assistant:
-
Go to the Windows Start menu and choose the Oracle home directory.
-
Choose the Configuration and Migration Tools menu.
-
Launch the Upgrade Assistant.
On Linux platforms, run the DBUA
utility to upgrade Oracle Database.
Related Topics
Export/Import Oracle Machine Learning for SQL Models
Use the export and import functions of the Oracle Database to export the previously created models and import the models in an instance of Oracle Database version.
If required, you can use a less automated approach to upgrading machine learning models. You can export the models created in a previous version of Oracle Database and import them into an instance of the Oracle Database version.
To export models from an instance of a previous release of Oracle Database to a dump file, follow the instructions in Export and Import Oracle Machine Learning for SQL Models.
Post Upgrade Steps
Perform steps to view the upgraded database.
After
upgrading the database, check the DBA_MINING_MODELS
view in the
upgraded database. The newly upgraded machine learning models
must be listed in this view.
After you have verified the upgrade and confirmed that
there is no need to downgrade, you must set the initialization parameter
COMPATIBLE
to 23.0.0
. In Oracle Database 23ai,
when the COMPATIBLE
initialization parameter is not set in your
parameter file, the COMPATIBLE
parameter value defaults to
23.0.0
.