Prerequisites for Creating a Connection

Know Oracle Database Classic Cloud Service Instance Details

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

Obtain Wallet and Database Details

You must download the credentials wallet and obtain database details.

Download the client credentials wallet from the Oracle Database Cloud Service instance. See Download Client Credentials (Wallets) in Using Oracle Autonomous AI Database Serverless.
Ensure that the target database is accessible.
Ensure that you have write permissions to the database.
Ensure that you have the required permissions to run stored procedures and SQL statements.
Know the database service name.
Know the database service user name and password for connecting to the database.

Configure Wallet to Support Multiple Hosts

Once you download the wallet credentials and obtain the database details, you can add primary and secondary host addresses to the tnsnames.ora file.

The secondary host can be used as a disaster recovery (DR) site if the connection to the primary host is lost or unavailable.

Before modifying the tnsnames.ora file to support multiple hosts, ensure that the following conditions are met:

Enable failover.
Disable load balancing.
Ensure that the service names and wallet certificates for both hosts are valid. See Obtain Wallet and Database Details.
Add both the primary and secondary host addresses to the tnsnames.ora file.

Refer to the following code for details:

DB26AI_APP =
(DESCRIPTION_LIST =
  (FAILOVER=on)
  (DESCRIPTION =
    (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xx.xxx)(PORT=1521))
    (CONNECT_DATA =
      (SERVICE_NAME=service_name)
    )
  )
  (DESCRIPTION =
    (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xx)(PORT=1521))
    (CONNECT_DATA =
      (SERVICE_NAME=service_name)
    )
  )
)

Complete Connectivity with SSL Prerequisites

If using connectivity with SSL with the Oracle Database Cloud Service Adapter, note the following requirements.

Note:

Connectivity agent installation and agent group creation are not required when using direct connectivity.

The Oracle Database Classic Cloud Service instance is accessible through a public IP address.
Oracle Database Classic 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.

Complete Username Password Token Security Policy Prerequisites

If using the Username Password Token security policy with the Oracle Database Cloud Service Adapter, note the following requirements.

Create an agent group. See Creating an Agent Group of Using Integrations in Oracle Integration 3. 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 Classic Cloud Service or a compute node from which the database is accessible. Understand the implications of installing on the same host. See Connectivity Agent Fails Frequently If Competing with Oracle Database Classic Cloud Service for Resources.

See Install the Connectivity Agent of Using Integrations in Oracle Integration 3.

Complete Oracle Cloud Infrastructure Database version 18c Prerequisites

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 Classic Cloud Service Database Instance to an Oracle Autonomous AI Transaction Processing or Oracle Autonomous Data Warehouse Database Instance

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

Migrate all the required database objects, stored procedures, wrapper procedures, and tables to the destination Oracle Autonomous AI Transaction Processing or Oracle Autonomous Data Warehouse database instance.
Change the Oracle Database Cloud Service Adapter connection details to point to an Oracle Autonomous AI Transaction Processing or Oracle Autonomous Data Warehouse 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.
Test the connection.
Once the test is successful, click Save to save the connection details.
Reactivate the integrations.