Connection to Oracle database hangs and connects very slowly. (4346511)

Toad takes hours to connect to an Oracle database even though SQL*Plus takes seconds to connect. The database connection is hanging due to this block being executed when Toad is connecting to the database.

BEGIN IF DBMS_UTILITY.IS_CLUSTER_DATABASE THEN :RetVal := 1; ELSE :RetVal := 0; END IF; END;
RetVal = <NULL>

The DBMS_UTILITY.IS_CLUSTER_DATABASE procedure may be invalid, or may not exist in the Oracle database. This anonymous block is used to determine if the database is a RAC instance or not. Users requests that Toad should have an option that would toggle this query from being executed prior to a database connection.

With Oracle 10g, the Toad developers felt it necessary to query whether the server db was a RAC instance. So older databases may not have the "IS_CLUSTER" procedure inside the "DBMS_UTILITY" package.

WORKAROUND:

Inform your Database Administrator to validate the DBMS_UTILITY.IS_CLUSTER_DATABASE procedure in your database.

STATUS:

This feature has been submitted as an enhancement request.