book
Article ID: KB0073257
calendar_today
Updated On:
Description
Oracle wallet connects only through SSL and requires the TLS 1.2 support. If the product is running on TDV 7.0.6, refer to the following article to upgrade JRE to 1.8 for TLS 1.2 support:
https://support.tibco.com/s/article/Unsupported-client-TLS-error-message-when-connecting-to-Salesforce-com-through-Spotfire-Advanced-Data-Services-ADS
Resolution
Steps to connect to Oracle wallet database:
1. Obtain the wallet folder/directory from Oracle.
2. Place the wallet directory in any path where TDV is installed. The wallet will include the ewallet.p12 file with certificate.
3. Extract the certificate from it and import it in TDV cis_server_truststore_strong.jks file under <Root>conf/server/security.
4. Restart TDV services.
5. Upgrade OJDBC6.jar file to version 8 which includes additional osdt_core.jar and osdt_cert.jar files required for Oracle SSL connection.
6. Add the oracle.net.wallet_location="(SOURCE=(METHOD=file)(METHOD_DATA=(DIRECTORY=/home/test/path))) parameter to the data source URL pointing to the wallet files placed in TDV installation directory.
7. Connect to Oracle database and introspect it.
Issue/Introduction
This article contains the steps to connect to Oracle database using Oracle wallet with SSL in TIBCO Data Virtualization.