How to Check 32-bit or 64-bit Oracle Client
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 32-bit or 64-bit Oracle Client
tnsping
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
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 in… 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 descriptor
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 a… Read More »How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
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
sqlplus, tnsping or lsnrctl Hangs
sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases that can share with you. Those hanging… Read More »sqlplus, tnsping or lsnrctl Hangs
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
What Oracle Command-line Utilities Need Authentication - Oracle
Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »What Oracle Command-line Utilities Need Authentication - Oracle