Prerequisites for Creating a Connection
You must satisfy the following prerequisites to create a connection with the Oracle Advanced Queuing (AQ) JMS Adapter. These prerequisites are required for both the Username Password Token and Oracle Wallet security policies.
- Know the Oracle Advanced Queueing (AQ) server host name or IP address and the port number.
- Know the Oracle system identifier (SID) or service name for the Oracle Advanced Queueing (AQ) server.
- Know the user name and password for the Oracle Advanced Queueing (AQ) server.
If you want to use the Oracle Wallet security policy, you need to perform
these additional steps:
- Ensure that you download the Oracle wallet if you need to connect with the Oracle Autonomous Transaction Processing instance and Oracle Autonomous Data Warehouse instance. See Download the Client Credentials Wallet in Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration 3.
- Ensure that you create the Oracle wallet if you need to connect
with the Oracle Database Cloud Service Adapter. You must satisfy the
following requirements to create the Oracle wallet:
- The Oracle Database Classic Cloud Service instance is accessible through a public IP address.
- The 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 User Authentication with Secure Sockets Layer in Oracle Database 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:
- 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
- Create a ZIP file containing
cwallet.sso
,ewallet.p12
,keystore.jks
, andtruststore.jks
, including thetnsnames.ora
file found in the$ORACLE_HOME/network/admin/
directory.
- Generate the truststore and keystore using
- Ensure that you have the Oracle Wallet password.