Products | Versions |
---|---|
TIBCO InConcert | - |
Not Applicable | - |
Resolution:
Description: This is a problem with how the Oracle listner and what protocals are defined for it. Trying to open the Process Manager and get a list of running instances (which takes in excess of 1 minute), and even worse trying to open an active flow for display (same time interval or worse).
Removing all entries from tnsnames.ora for the SID being used by InConcert that mentioned a protocol other then TCP fixed the problem. Apparently, Oracle would try some of the other protocols first before getting to the TCP one. This case involved Oracle 8.0.5 but the solution should apply to other versions of Oracle.
DO NOT EDIT tnsnames.ora directly but use the SQL Easy Net config program to do it.