Cannot select a database from the database drop down field in the new connection window.
A tnsnames file exists, the Environmental Path is correct, and there are green checks next to the "SQLNET Editor" and "TNSNames Editor" buttons on the connection window.
The tnsnames files is saved as a different extension.
Ex: tnsnames.txt instead of the required tnsnames.ora
Go to the file location noted by the Environmental Path that leads to the tnsnames file. Check the file extension.
May need to verify that the Folder Options are set to show extensions. In the browser, go to Tools | Folder Options | View and check the "Hide extensions" setting. This should be toggled off to show true file extensions.
Please also review SOL7712 for other trouble-shooting tips for common Oracle connection issues.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center