How to Check Oracle Client Version 32-bit or 64-bit
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 Check Oracle Client Version 32-bit or 64-bit
tnsping
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154 ORA-12154 means that your connection tools including sqlplus cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
Oracle Client vs Instant Client
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 »Oracle Client vs Instant Client
How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect
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-12514: TNS:listener does not currently know of service requested in connect
How to Resolve ORA-12541: TNS:no listener
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-12541: TNS:no listener
How to Resolve ORA-12547: TNS:lost contact
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 ORA-12547: TNS:lost contact
How to Resolve "tnsping command not found" or "tnsping is not recognized as an internal or external command"
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 »How to Resolve "tnsping command not found" or "tnsping is not recognized as an internal or external command"
Why Tnsping Hang
sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases to share with you. Those hanging all… Read More »Why Tnsping Hang
TNSPING, How and Why
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 »TNSPING, How and Why
How to Resolve Message 3511 not found
Message 3511 not found Recently, I upgraded my PC from Windows XP to Windows 7 at my working place. For reusing installed Oracle Client 9.2.0,… Read More »How to Resolve Message 3511 not found