Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Oracle Database Cloud Service Adapter.

  • Note details such as Public IP, SID, SQL*Net Port, PDB Name, and Connect String from the instance details page for the Oracle Database Cloud Service instance in the My Services Console. This information is required when configuring an Oracle Database Cloud Service Adapter connection on the Connections page.

  • If using connectivity with SSL, note the following requirements:

    Note:

    Connectivity agent installation and agent group creation are not required when using direct connectivity.
    • The Oracle Database Cloud Service instance is accessible through a public IP address.
    • Oracle Database Cloud Service should be SSL-enabled along with the necessary wallet configuration. See the Oracle Database documentation for configuring secure sockets layer authentication for your respective database version. For example, for Release 18, see Configuring Secure Sockets Layer Authentication of the Security Guide.
    • Once SSL is configured, the following files are available under the wallet directory:
      • cwallet.sso
      • ewallet.p12
      Follow these steps to create a wallet archive file:
      1. Generate the truststore and keystore using orapki:
        orapki wallet pkcs12_to_jks -wallet wallet_directory/ewallet.p12 
        -pwd password_provided_during_wallet_creation 
        -jksKeyStoreLoc wallet_directory/keystore.jks 
        -jksKeyStorepwd password 
        -jksTrustStoreLoc wallet_directory/truststore.jks 
        -jksTrustStorepwd password
      2. Create a ZIP file containing cwallet.sso, ewallet.p12, keystore.jks, and truststore.jks, including the tnsnames.ora file found in the $ORACLE_HOME/network/admin/ directory.
  • If using the Username Password Token security policy, note the following requirements:
    • Create an agent group. See Creating an Agent Group of Using Integrations in Oracle Integration. Note the agent group name and agent group identifier that you specify. The agent group name is required when creating an Oracle Database Cloud Service Adapter connection. The agent group identifier is required when installing the connectivity agent.

    • Download and install the connectivity agent on the same host as the Oracle Database Cloud Service or a compute node from which the database is accessible. See Downloading and Running the On-Premises Agent Installer of Using Integrations in Oracle Integration.

  • If using Oracle Cloud Infrastructure Database version 18c, you must perform the following steps before using stored procedures in Oracle Cloud Infrastructure (that is, before generating wrapper packages). Some changes to the 18c database must be bypassed to get table/record type metadata information.

    Run the first command to enable events to capture metadata:

    alter session set events '10946 trace name context forever, level 65536';
    

    Run the second command to recompile and populate that metadata:

    alter package package_name compile;

Migrate from an Oracle Database Cloud Service Database Instance to an Oracle Autonomous Transaction Processing Database Instance

Perform the following steps if you want to migrate from an Oracle Database Cloud Service database instance to an Oracle Autonomous Transaction Processing database instance.

  1. Migrate all the required database objects, stored procedures, wrapper procedures, and tables to the destination Oracle Autonomous Transaction Processing database instance.
  2. Change the Oracle Database Cloud Service Adapter connection details to point to an Oracle Autonomous Transaction Processing database instance.
    1. Go to the Connection page for the Oracle Database Cloud Service Adapter.
    2. Click Configure Connectivity.
    3. Specify the new host name.
    4. Specify the new service name and click OK.
    5. Click Configure Security.
    6. Select the Oracle Wallet security policy.
    7. Upload the wallet.
    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. Delete the agent from the connection.
  3. Test the connection.
  4. Once the test is successful, click Save to save the connection details.
  5. Reactivate the integrations.