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 TNS-12541: TNS:no listener
TNS-12541 Let’s see how we reproduce TNS-12541. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 22-JUL-2014 19:20:06 Copyright (c) 1997,… Read More »How to Resolve TNS-12541: TNS:no listener
How to Resolve TNS-12547: TNS:lost contact
TNS-12547 Let’s see how we reproduce TNS-12547. C:\Users\ed>tnsping compdb 100 TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 22-JUL-2014 19:26:03 Copyright (c)… Read More »How to Resolve TNS-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 Errors Collections
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… Read More »TNSPING Errors Collections
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