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
Follow these steps to create a wallet archive file:
- Generate the truststore and keystore using
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
- Create a ZIP file containing
truststore.jks, including the
tnsnames.orafile found in the
- 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. Understand the implications of installing on the same host. See Connectivity Agent Fails Frequently If Competing with Oracle Database Cloud Service for Resources.
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 or Oracle Autonomous Data Warehouse 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 or Oracle Autonomous Data Warehouse database instance.
- 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.
- Change the Oracle Database Cloud Service
Adapter connection details to point to an Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse database instance.
- Go to the Connection page for the Oracle Database Cloud Service Adapter.
- Click Configure Connectivity.
- Specify the new host name.
- Specify the new service name and click OK.
- Click Configure Security.
- Select the Oracle Wallet security policy.
- Upload the wallet.
- Specify the wallet password and reconfirm it.
- Specify the database service username.
- Specify the database service password, reconfirm it, and click OK.
- Delete the agent from the connection.
- Test the connection.
- Once the test is successful, click Save to save the connection details.
- Reactivate the integrations.