When I try to connect with TOAD this appears:
TNSADMIN environment variable is not defined
EZCONNECT is not the first naming method in NAMES.DIRECTORYPATH which may conflict with other naming methods specified.
Plus I do not know what to put on the service name section
Hi @javierruiz
You’re probably better off asking in a Oracle forum, but when I searched a bit, it seems like you’re probably missing the Oracle path from $PATH:
https://dba.stackexchange.com/questions/22739/oracle-11g-r2-standard-edition-installation-set-environment-variable-path-and
The TNSADMIN environment variable is used to specify the directory location for the tnsnames.ora file. The TNSADMIN environment variable can be defined in the following ways:
For UNIX users, the order in which Oracle searches locations for Oracle Net files like sqlnet.ora and tnsnames.ora are in this order:
$HOME for hidden files only (i.e., .sqlnet.ora and .tnsnames.ora)$TNS_ADMIN$HOME/etc or /var/opt/oracle (depends on platform)$ORACLE_HOME/network/adminDon’t hesitate to contact me if you have any trouble !