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
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