sqlplus Connecting Hang?
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?
SQL*Plus
How to Resolve ORA-12162: TNS:net service name is incorrectly specified
ORA-12162 To know how to solve ORA-12162 depends on where the database is. A local database? or an external database? Local Database A local database… Read More »How to Resolve ORA-12162: TNS:net service name is incorrectly specified
SQLPlus Connect and Disconnect
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
How to Resolve SP2-0547: size option out of range
SP2-0547 Saw error SP2-0547 when we tried to set the buffer size of server output in SQL*Plus. SQL> set serveroutput on size 1000; SP2-0547: size… Read More »How to Resolve SP2-0547: size option out of range
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
SHOW PARAMETER, How and Why
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
How to Resolve SP2-0735: unknown SET option beginning
SP2-0735 SP2-0735 is a SQL*Plus error which is very much like SP2-0158, they alert users that SQL*Plus cannot recognize the issued command. For example: SQL>… Read More »How to Resolve SP2-0735: unknown SET option beginning
How to Resolve SP2-0158: unknown SHOW option
SP2-0158 SP2-0158 means that the issued command is not supported by this release of SQL*Plus utility. For example, we use SQL*Plus 11.2.0.4 to connect to… Read More »How to Resolve SP2-0158: unknown SHOW option
How to Resolve SP2-0382: The SHOW PDBS command is not available
SP2-0382 SP2-0382 means that the connected user are not privileged as SYSDBA, so SQL*Plus SHOW PDBS command is not available to the user. SQL> conn… Read More »How to Resolve SP2-0382: The SHOW PDBS command is not available
How to Execute SQL Statements in One CMD Line
If your query contains just only one statement, you can do this:C:Usersed>echo select name from v$database; | sqlplus scott/tiger@orclWhen the query is finished, the command… Read More »How to Execute SQL Statements in One CMD Line