Perform Cloud Storage Related Prerequisites

You must perform the following tasks to set up the Cloud Storage for data movement.

The Oracle Cloud Infrastructure Object Storage service is a Cloud Storage platform, which acts as an intermediary into which the dump files from the source on-premises Oracle Database are first exported, and then imported into the destination Autonomous Database. For information on Object Storage, see Overview of Object Storage in Oracle Cloud Infrastructure documentation.

• Access Object Storage in the Oracle Cloud Infrastructure Console and create a bucket, which is a logical container for storing the export dump files. When creating the bucket, ensure that you select the STANDARD option under STORAGE TIER. Also, ensure that the visibility of this bucket remains PRIVATE, which is the default option. For information on how to create a bucket, see To create a bucket in Oracle Cloud Infrastructure documentation.

  Important: Make a note of the BUCKET NAME as you'll need it when submitting the Cloud Storage details on the Data Movement page.

• Enable the destination Autonomous Database to connect to the Object Storage by generating an Auth Token, creating a name credential, and setting it as the default. The Auth Token is used by the Autonomous Database to authenticate itself and fetch the dump files from the Object Storage.

  To generate an Auth Token and set a name credential as default:

  1. In the Oracle Cloud Infrastructure Console, click the User Profile icon on the top-right corner and then click User Settings.
  2. On the left side of the page, click Auth Tokens and then click Generate Token.
  3. Enter a description for the Auth Token and click Generate Token.
  4. Copy the Auth Token immediately to a secure location from where you can retrieve it later, because the generated Auth Token will not be displayed again in the Oracle Cloud Infrastructure Console.
  5. Close the Generate Token dialog box.
  6. Connect to the Autonomous Database manually using Oracle Instant Client:

     $ORACLE_HOME/sqlplus 'admin/<password_set_when_creating_Autonomous_Database>@<predefined_service_name_in_tns.ora>'

     For more information on connecting to the Autonomous Database, see Connect with SQL*Plus in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

  7. Execute the following PL/SQL statements to create a credential and set it as the default:

     SET DEFINE OFF
     BEGIN DBMS_CLOUD.CREATE_CREDENTIAL('<credential_name>', '<oci_username>', <auth_token>); END;
     /
     alter database property set default_credential = 'ADMIN.<credential_name>';