User launches Toad for Oracle and connects to the database. They then launch a Database Browser window. The Database Browser is supposed to display all the databases found in the user's TNSNAMES.ORA file; however, the user notices that not every database has been loaded. Why is this and what should be done?
Toad Database Browser is only loading entries that have keywords HOST and PORT capitalized.
WORKAROUND 1:
Capitalize the labels in TNSNAMES.ORA. After you capitalize them, shut down Toad. Browse to the file C:\Program Files\Quest Software\Toad for Oracle\User Files\DatabaseBrowser.tdb. Rename it "DatabaseBrowser.OLD". Launch your Toad, connect to a database, then open the Database Browser. It should load all the valid entries in your TNSNAMES.ORA file.
WORKAROUND 2:
Ensure that there are no invalid characters or lines of invalid data within the tnsnames.ora file
STATUS:
Waiting for fix in a future version of Toad for Oracle.
