tnsnames.ora in SQL Developer
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »tnsnames.ora in SQL Developer
TNS_ADMIN
Where is Tnsnames.ora Location
tnsnames.ora Suppose you have known the usage of TNSNAMES, now let's see where we can find it in this post. In fact, the location of… Read More »Where is Tnsnames.ora Location
SQLPlus Connect without Tnsnames
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 »SQLPlus Connect without Tnsnames
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
TNS_ADMIN, How and Why
There're 4 sections we'll talk about TNS_ADMIN in this post. TNS_ADMIN in Oracle Software Registry Basics of TNS_ADMIN How to Define TNS_ADMIN What About %PATH%… Read More »TNS_ADMIN, How and Why
How to Install Oracle Instant Client 19c on Windows
The term "install" may be a little improper for Oracle Instant Client, because the packages are all zipped and portable, there's no need to actually… Read More »How to Install Oracle Instant Client 19c on Windows