- Administration and Configuration Guide
- Configurations for Connecting OFSAA to Oracle Database using Secure Database Connection (TCPS)
- Configuring OFSAA and various Web Application Servers with Oracle Wallet
- Configuring OFSAA and WebLogic as Web Application Server with Oracle Wallet
Configuring OFSAA and WebLogic as Web Application Server with Oracle Wallet
- 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. - 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. - 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 thesetDomainEnv.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
- 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. - 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
- Modify URL and Properties values as displayed in the figure.
- Similarly, edit the WLS JNDI Data Source connections ATOMIC and SANDBOX Schemas, and perform a Test Connection on each data source.