The order of precedence for resolving TNS names in ODP.NET, Managed Driver is this (see here): data source alias in the ‘dataSources’ section under section in the .NET config file. data source alias in the tnsnames.ora file at the location specified by ‘TNS_ADMIN’ in the .NET config file. data source alias in the tnsnames.ora file … Read more
You need to add the SID entry for XE in order to register the instance with the listener. After installation of Oracle XE, everything looks good, but when you issue C:\>sqlplus / as sysdba SQL>shutdown immediate SQL>startup TNS-12505: TNS:listener does not currently know of SID given in connect descriptor the instance will not register with … Read more
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
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
In SQLDeveloper browse Tools –> Preferences, as shown in below image. In the Preferences options expand Database –> select Advanced –> under “Tnsnames Directory” –> Browse the directory where tnsnames.ora present. Then click on Ok, as shown in below diagram. tnsnames.ora available at Drive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN Now you can connect via the TNSnames options.