How to find the Preferences GUI Window in Oracle SQL Developer?

427 views Asked by At

I am trying to solve the ORA-12514 error. The solution is to check if the [tnsnames.ora] the [SERVICE_NAME] is a valid service name in your database.

I can't find this path ($ORACLE_HOME\network\admin) in DB directory.

But we can also check in the preferences window which I can't find in the Oracle SQL Dev. GUI. (as shown in the picture attached)Preferences Window

1

There are 1 answers

0
d r On BEST ANSWER

In SQL Devloper's Connections pane right click on your database name - on a context menu click Properties and then check all the data, including SERVICE_NAME and compare it with your TNSNAMES.ora file.
Regards...