Prerequisites to Use the Username Password Token Security Policy

• Associate the database schema with the business event system queue type. This is because Oracle Advanced Queueing (AQ) supports only the business event system queue.

• 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.

Prerequisites to Use the Oracle Wallet Security Policy

• Associate the database schema with the business event system queue type. This is because Oracle Advanced Queueing (AQ) supports only the business event system queue.
• Know the Oracle system service name for the Oracle Advanced Queueing (AQ) server.

• Know the user name and password for the Oracle Advanced Queueing (AQ) server.

• 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.
  • 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 for Administrative Users in the 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:

    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.
• Ensure that you have the Oracle Wallet password.