Migrate an On-Premises Oracle AI Database Instance to an Oracle Autonomous AI Transaction Processing or Oracle Autonomous AI Lakehouse Database Instance

Perform the following steps if you want to migrate from an on-premises Oracle AI Database instance to an Oracle Autonomous AI Transaction Processing or Oracle Autonomous AI Lakehouse database instance.

1. Migrate all the required database objects, stored procedures, wrapper procedures, and tables to the destination Oracle Autonomous AI Transaction Processing or Oracle Autonomous AI Lakehouse database instance.

   Note:

   When migrating integrations that include stored procedures with PL/SQL types, you must migrate the wrappers created by the integration along with the database objects before reactivating the integrations. If there are any modifications to the stored procedures performed after the migration, you must re-edit the Adapter Endpoint Configuration Wizard and reselect the stored procedure for the changes to be enabled. This re-edit does not create any wrappers and uses the actual stored procedures instead.
2. Change the Oracle AI Database Adapter connection details to point to an Oracle Autonomous AI Transaction Processing or Oracle Autonomous AI Lakehouse database instance.
   1. Go to the Connection page for the Oracle AI Database Adapter.
   2. Go to the Properties section.
   3. Specify the new host name.
   4. Specify the new service name and click OK.
   5. Go to the Security section.
   6. Select Oracle Wallet from the Security Policy list.
   7. In the Wallet field, click the Upload icon to upload the wallet file.
   8. Specify the wallet password and reconfirm it.
   9. Specify the database service username.
   10. Specify the database service password, reconfirm it, and click OK.
   11. Configure an agent group.

       Note:

       When migrating an on-premises Oracle AI Database instance to Oracle Autonomous AI Transaction Processing or Oracle Autonomous AI Lakehouse, it is mandatory to use the connectivity agent in the connection.
3. Test the connection.
4. Once the test is successful, click Save to save the connection details.
5. Reactivate the integrations.