1. Using the Oracle Database Adapter with Oracle Integration Generation 2
  2. Implement Common Patterns Using the Oracle Database Adapter
  3. Migrate an On-Premises Oracle Database Instance to an Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse Database Instance

Migrate an On-Premises Oracle Database Instance to an Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse Database Instance

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

  1. Migrate all the required database objects, stored procedures, wrapper procedures, and tables to the destination Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse 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 Database Adapter connection details to point to an Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse database instance.
    1. Go to the Connection page for the Oracle Database Adapter.
    2. Go to the Connection 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 Database instance to Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse, 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.