I understand that I need to configure database address in the TNSNAMES.ORA file but where should I put this file?
UPDATE
I defined the $TNS_ADMIN
variable, created the TNSNAMES.ORA
file, added new connection and restarted my machine. Unfortunately, the Database list in Oracle Logon remains empty.
However, the following error occurred when I was trying out various options in PL/SQL Developer:
Initialization error
SQL*Net not properly installedOracleHomeKey:
OracleHomeDir:
What is SQL*Net?
Best Answer
You need to have SQL*Net installed in order to connect PL/SQL Dev to Oracle. SQL*Net is installed by default with most Oracle DB products (Oracle client for example). Since PL/SQL dev is a Windows app, you can see what Oracle products you have installed by looking into the registry (HKEY_LOCAL_MACHINE\SOFTWARE\Oracle). Also in PL/SQL dev settings (Tools/Preferences/Connection) you will have a list of all Oracle Homes (which allows you to specify which one you want to use if you have multiple homes).
If you already have an Oracle Home, the
TNSNAMES.ora
file is by default in the directory%ORACLE_HOME%\network\admin
. You can set the registry keyTNS_ADMIN
if you want to specify another directory.