TNS Name

How to Connect Without TNSNAMES

Posted on
Connect No TNSNAMES Yes, sometimes we are not allowable to change tnsnames.ora, even a tiny bit. How can we connect to new or moved databases? In this post, I provided some ways to connect to databases without touching the original tnsnames.ora. Use Full Connect Descriptor Use Your Own tnsnames.ora Use Easy Connect Method 1. Use […]
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 Method Missing tnsnames.ora File Connect Identifier Mismatch Searching for Wrong Domain 1. TNS-03505 due to Absent Local Naming Method There’re several naming methods supported by […]
TNS Name

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

Posted on
Transparent Application Failover (TAF) Besides Connect-Time Failover by local naming, there is a function called 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 […]