The Database drop-down list in the connection screen only shows a few database name entries, but much more entries in the tnsnames.ora file. The drop-down list is missing or is not showing all my database names or is not complete.
RESOLUTION 1:
Open TNSNames.ora file in Notepad and maximize the window. Ensure that each database entry in this file is not missing any parenthesis and/or does not have more parenthesis than needed. Make sure that lines are not broken up into two lines. For example, make sure the line that contains the PORT number is not broken up in two lines.
RESOLUTION 2:
Ensure a compatible Oracle client for the Toad for Oracle version and Windows OS version is used. See release notes per the Toad for Oracle version for System Requirements.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center