SQLNET

How to Resolve TNS-03505: Failed to resolve name

Posted on
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 throw TNS-03505: Absent Local Naming Connect Identifier Mismatch Search for Wrong Domain 1. Absent Local Naming There’re several naming methods supported by Oracle in sqlnet.ora. Only local naming can be […]
TNS Name

How to Implement Transparent Application Failover (TAF) by Local Naming

Posted on
General backgroundBesides Connect-Time Failover by local naming, there is a function Transparent Application Failover (TAF) can do Run-Time Failover to enable user to continue his work transparently when connection failed over to other database (listener).There are two types of Run-Time Failover method, both methods are suitable for RAC architecture, but not for Data Guard, because […]