InConcert on NT with Oracle DB runs very slow when disconected from the network.

InConcert on NT with Oracle DB runs very slow when disconected from the network.

book

Article ID: KB0091662

calendar_today

Updated On:

Products Versions
TIBCO InConcert -
Not Applicable -

Description

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.

Issue/Introduction

InConcert on NT with Oracle DB runs very slow when disconected from the network.

Environment

Product: TIBCO InConcert Version: All OS: All --------------------