Where is Tnsnames.ora Location
tnsnames.ora Suppose you have known the usage of TNSNAMES, now let's see where we can find it in this post. In fact, the location of… Read More »Where is Tnsnames.ora Location
TNS Name
TNSNAMES, How and Why
Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn username/password@chicago-db-server:1521/ORCL Connected. Or… Read More »TNSNAMES, How and Why
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-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
SQLPlus Connect without Tnsnames
SQLPlus without Tnsnames Sometimes we are not allowable to change or access tnsnames.ora, even worse, we cannot find the location of tnsnames.ora. So how can… Read More »SQLPlus Connect without Tnsnames
How to Resolve TNS-03505: Failed to resolve name
TNS-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)
Transparent 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)