Steps of Using Oracle 19C Autonomous Database with ADB Adapter 7.2.0 HF10 and ADB Adapter 7.3.1
Article ID: KB0071126
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.2.0 hotfix 10 & 7.3.1 |
Description
To use Oracle 19C Autonomous Database with ADB Adapter 7.2.0 HF10 and ADB Adapter 7.3.1., some steps need to be performed as prerequisites.
Environment
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 7.2.0 hotfix 10 & 7.3.1
OS: All Supported Operating Systems
Resolution
Please note that TIBCO ActiveMatrix Adapter for Database supports only native drivers for Oracle 19C autonomous database.
1. Copy the encryption wallet from the oracle database.
The default encryption wallet location is $ORACLE_BASE/admin/<global_db_name>/wallet.
If you do not find the wallet at the default location, please check the value set for ENCRYPTION_WALLET_LOCATION parameter in sqlnet.ora. The wallet will be available at the above location.
2. Paste the wallet on the client machine, where Adapter for Database is to be used.
3. Extract the wallet in case it is in zipped format.
4. Copy the above path of the wallet directory.
5. Open the Adapter for Database configuration resource in TIBCO Designer.
6. Provide the following value in the JDBC Driver field.
oracle.jdbc.OracleDriver
7. Provide the following value in the JDBC URL field.
jdbc:oracle:thin:@<database_name>?TNS_ADMIN=<location_of_wallet>
8. Provide User Name and Password as usual. Connection should be successful.
1. Copy the encryption wallet from the oracle database.
The default encryption wallet location is $ORACLE_BASE/admin/<global_db_name>/wallet.
If you do not find the wallet at the default location, please check the value set for ENCRYPTION_WALLET_LOCATION parameter in sqlnet.ora. The wallet will be available at the above location.
2. Paste the wallet on the client machine, where Adapter for Database is to be used.
3. Extract the wallet in case it is in zipped format.
4. Copy the above path of the wallet directory.
5. Open the Adapter for Database configuration resource in TIBCO Designer.
6. Provide the following value in the JDBC Driver field.
oracle.jdbc.OracleDriver
7. Provide the following value in the JDBC URL field.
jdbc:oracle:thin:@<database_name>?TNS_ADMIN=<location_of_wallet>
8. Provide User Name and Password as usual. Connection should be successful.
Issue/Introduction
Steps of Using Oracle 19C Autonomous Database with ADB Adapter 7.2.0 HF10 and ADB Adapter 7.3.1
Feedback
Yes
No
Powered by
