NAMES.DIRECTORY_PATH

How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified

by Ed Chen
June 8, 2019December 29, 2022
8 Comments

ORA-12154 ORA-12154 means that your connection tools (e.g. sqlplus) cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »

SQLPlus Connect without Tnsnames

by Ed Chen
May 30, 2019December 17, 2022

SQLPlus without Tnsnames We usually connect a database by sqlplus through tnsnames.ora, but sometimes we are not allowable to change or access tnsnames.ora, even worse,… Read More »

How to Resolve TNS-03505: Failed to resolve name

by Ed Chen
February 9, 2019December 10, 2022
2 Comments

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 »

TNSPING, How and Why

by Ed Chen
July 22, 2014December 11, 2022

TNSPING Utility tnsping is a network testing utility provides by Oracle to test the availability of listener through the substrate of Oracle Net. Somebody may… Read More »