Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
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
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