tnsping

How to Resolve ORA-00132: syntax error or unresolved network name

by Ed Chen
March 31, 2023March 27, 2023

ORA-00132 Found error ORA-00132 in the alert log, when we're starting up a database. 2023-03-01T22:41:54.802021-05:00 WARNING: Invalid value for listener related parameter MIXED LISTENER 2023-03-01T22:41:54.803545-05:00… Read More »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

How Srvctl Relocate VIP

by Ed Chen
November 16, 2022November 21, 2022

srvctl relocate vip We have talked about how virtual IP (VIP) failover to another node. In this post, let's see how we manually relocate a… Read More »

How to Check Oracle Client Version 32-bit or 64-bit on Windows

by Ed Chen
November 20, 2019December 10, 2022

32-bit or 64-bit In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool… Read More »

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 »

Oracle Client vs Instant Client

by Ed Chen
March 1, 2019March 1, 2023

Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019December 10, 2022
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »

How to Resolve ORA-12541: TNS:no listener

by Ed Chen
February 13, 2019December 10, 2022
8 Comments

ORA-12541 and TNS-12541 ORA-12541 is the same as TNS-12541, they all indicate that the listener is not running according to your specified destination. Let’s see… Read More »

How to Resolve ORA-12547: TNS:lost contact

by Ed Chen
February 12, 2019December 10, 2022

ORA-12547 and TNS-12547 ORA-12547 is the same as TNS-12547, they all indicate that the ability of communication between the client and the listener is interrupted… Read More »

How to Resolve "tnsping command not found" or "tnsping is not recognized as an internal or external command"

by Ed Chen
February 8, 2019November 11, 2021
2 Comments

tnsping command not found This type of error message tnsping command not found in Linux or tnsping is not recognized as an internal or external… Read More »