SP2-0618 and SP2-0611 An user reported errors SP2-0618 and SP2-0611 when he tried to enable AUTOTRACE at his session-time. SQL> show user USER is "HR"… Read More »How to Resolve SP2-0618 and SP2-0611
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
SQL*Plus Network Issues At times, we see that some logins and connections are not responding and indefinitely hang in tools like SQL*Plus. In most cases,… Read More »sqlplus Connecting Hang?
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
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
What is SHOW PARAMETER? SHOW PARAMETER is a SQL*Plus specific command that can show all parameters, types and their values in a simple way. If… Read More »SHOW PARAMETER, How and Why