Usually, we copy, paste and modify the block of a TNS entry in tnsnames.ora to create a new net service name for local naming. For… Read More »How NETCA Add Net Service Name
SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »SQLPlus Connect and Disconnect
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
Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string by easy connect like this: SQL> conn… Read More »TNSNAMES, How and Why
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