tns – Tarik Billa

Oracle – What TNS Names file am I using?

March 28, 2023 by Tarik

Oracle provides a utility called tnsping: R:\>tnsping someconnection TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 – Production on 27-AUG-20 08 10:38:07 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:\Oracle92\network\ADMIN\sqlnet.ora C:\Oracle92\network\ADMIN\tnsnames.ora TNS-03505: Failed to resolve name R:\> R:\>tnsping entpr01 TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 – Production on 27-AUG-20 … Read more

Oracle TNS names not showing when adding new connection to SQL Developer

January 7, 2023 by Tarik

SQL Developer will look in the following location in this order for a tnsnames.ora file $HOME/.tnsnames.ora $TNS_ADMIN/tnsnames.ora TNS_ADMIN lookup key in the registry /etc/tnsnames.ora ( non-windows ) $ORACLE_HOME/network/admin/tnsnames.ora LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME_KEY LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME To see which one SQL Developer is using, issue the command show tns in the worksheet If your tnsnames.ora file is not getting recognized, use … Read more