Where is TNSNAMES.ORA Locationby Ed ChenJanuary 19, 2022January 17, 2022What is TNSNAMES? Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn hr/hr@chicago-db-server:1521/ORCL Connected. Or we… Read More »Where is TNSNAMES.ORA Location
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specifiedby Ed ChenJune 8, 2019June 3, 20226 CommentsORA-12154 ORA-12154 means that your connection tools including sqlplus cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
How to Connect SQLPlus without TNSNAMESby Ed ChenMay 30, 2019May 26, 2022Sqlplus Connection String Yes, sometimes we are not allowable to change tnsnames.ora, even a tiny bit. How can we connect to a new or moved… Read More »How to Connect SQLPlus without TNSNAMES
How to Resolve TNS-03505: Failed to resolve nameby Ed ChenFebruary 9, 2019April 27, 20222 CommentsTNS-03505 Failing to resolve TNS names could involve any one of the network configuration files, such as tnsnames.ora or sqlnet.ora. There're several possible causes may… Read More »How to Resolve TNS-03505: Failed to resolve name
How to Set Client-Side Transparent Application Failover (TAF)by Ed ChenOctober 21, 2012February 21, 2021Transparent Application Failover (TAF) Besides connect-time failover to the standby database, there is a function called Transparent Application Failover (TAF) can do run-time failover to… Read More »How to Set Client-Side Transparent Application Failover (TAF)