Configuring OFSAA and WebLogic as Web Application Server with Oracle Wallet

  1. On Primary WebLogic Server instance, since there is no Oracle Client on the WebLogic Server instance, manually create a directory called "network" and copy tnsnames.ora, sqlnet.ora files into the "network" folder. Copy complete wallet directory "clientwallet" configured from OFSAA layer.
  2. Modify sqlnet.ora with new WALLET_LOCATION path.

    Note:

    Make sure the TNS_ADMIN and WALLET LOCATION are under Domain directory so that after Cluster configuration it is being copied to secondary Weblogic Server instances manually. For more information on clustered setup configuration, see the Configuring OFSAA in Clustered Environment Guide.
  3. Add parameters and its values (-Doracle.net.tns_admin, - Doracle.net.ssl_server_dn_match, -Djavax.net.ssl.trustStoreType, - Djavax.net.ssl.trustStore, -Doracle.net.ssl_version and - Doracle.net.wallet_location) in the setDomainEnv.sh file as given:
    JAVA_PROPERTIES="${JAVA_PROPERTIES} ${EXTRA_JAVA_PROPERTIES}
    -Doracle.net.tns_admin= /scratch/ssldbtest/Oracle/Middleware/Oracle_Home/user_projects/domains/DBAAAIB/network
    -Doracle.net.wallet_location=
    (SOURCE=(METHOD=file)
    (METHOD_DATA=(DIRECTORY=
    /scratch/ssldbtest/Oracle/Middleware/Oracle_Home/user_projects/domains/DBAAAIB/clientwallet) )
    -Djavax.net.ssl.trustStoreType=SSO
    -Djavax.net.ssl.trustStore=/scratch/ssldbtest/Oracle/Middleware/Oracle_Home/user_projects/domains/DBAAAIB/clientwallet/cwallet.sso
    -Doracle.net.ssl_version=1.2
    -Doracle.net.ssl_server_dn_match=true
    "
    export JAVA_PROPERTIES
  4. Copy the ojdbc8.jar file from the $FIC_HOME/ficapp/common/FICServer/lib directory into the <WL_HOME>/common/lib/oracle.jdbc located jdbc drivers directory.
  5. Login to the WLS Admin console and edit the WLS JNDI Data Source connection pool details.

    Figure 13-2 OFSAA and WebLogic as Web Application Server Configuration window


    This image displays the OFSAA and WebLogic as Web Application Server Configuration window.

  6. Modify URL and Properties values as displayed in the figure.
  7. Similarly, edit the WLS JNDI Data Source connections ATOMIC and SANDBOX Schemas, and perform a Test Connection on each data source.