The following database adapter and plugin support establishing the connection to the Oracle databse through the tnsnames.ora file:

- TIBCO ActiveMatrix Adapter for Database 7.2.1 to 7.2.x and 7.3.2 or above
- TIBCO ActiveMatrix BusinessWorks Plug-in for Database 8.6.0 or above

How to establish the connection to the Oracle databse through the tnsnames.ora file

Product: TIBCO ActiveMatrix Adapter for Database Version: 7.2.1 to 7.2.x, 7.3.2 or above Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version: 8.6.0 or above OS: All Supported Operating Systems

1 Place a valid tnsnames.ora file in the local file system (For example: C:\temp\tnsnames.ora)

2 For TIBCO ActiveMatrix Adapter for Database:
   In design time, add the Java property "java.property.oracle.net.tns_admin=C:/temp" to designer.tra.
   In run time, add the Java property "java.property.oracle.net.tns_admin=C:/temp" to the adapter tra file.

3 For TIBCO ActiveMatrix BusinessWorks Plug-in for Database:
   In design time, add the Java property "-Doracle.net.tns_admin=C:/temp" to TIBCOBusinessStudio.ini.
   In run time, add the Java property "-Doracle.net.tns_admin=C:/temp" to the appnode tra file or appspace tra file.

4 Change the Oracle JDBC URL from "jdbc:oracle:thin:@<machine_name>:<port>:<instance_name>" to "jdbc:oracle:thin:@<tns_entry>".
   Replace <tns_entry> with a valid entry in tnsnames.ora.