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 […]

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 […]

TNSPING Errors Collections

Posted on
tnsping tnsping is a utility provided by Oracle to test the listener is available or not from clients. If there’s any problem in the path to the destination, it will fail with different aspects. Here I list several possible error types below for your reference. “tnsping is not recognized as an internal or external command” […]