Prerequisites for Creating a Connection

You must satisfy the following prerequisites for creating a connection with Oracle Integration.

Know Database Details

  1. Ensure that you have write permissions to the database.
  2. Ensure that you have the required permissions to run stored procedures and SQL statements.
  3. Know the database URL, including the hostname or IP address and the port number.
  4. Know the database system ID and service name.
  5. Know the username and password for connecting to the database. Know the agent group if you are connecting to an on-premises application.
  6. Oracle Integration can connect to Oracle Real Application Clusters (RAC) databases with the on-premises connectivity agent using Single Client Access Name (SCAN) as the hostname while configuring the connection. SCAN provides a single name for clients to access any Oracle AI Database running in a cluster.

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.
  • Add both the primary and secondary host addresses to the tnsnames.ora file.
Refer to the following code for details: 
primaryaidbmumdb_low = 
(DESCRIPTION =
     (RETRY_COUNT=5)
      (RETRY_DELAY=3)

              (ADDRESS_LIST =
               (FAILOVER=on)
                (LOAD_BALANCE=off)

                   (ADDRESS=(PROTOCOL=tcps)(PORT=1522)(HOST=host_name-region-1.example.com))
                   (ADDRESS=(PROTOCOL=tcps)(PORT=1522)(HOST=host_name-region-1.example.com))
  )
   (CONNECT_DATA =
    (SERVICE_NAME=service_name)
  )
  (SECURITY =
    (SSL_SERVER_DN_MATCH=yes)
  )
)