Enable Non-Oracle User Run SQL*Plus
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
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?
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 (ORACLE_SID) A local… 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
Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
SYS_AUTO_SQL_TUNING_TASK Report
SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… Read More »SYS_AUTO_SQL_TUNING_TASK Report
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
How Oracle Check Archivelog Mode
Check Archivelog Mode There're two ways that can check whether archivelog mode is enabled or not. By SQL*Plus command To use SQL*Plus specific command, you… Read More »How Oracle Check Archivelog Mode
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
How to Resolve ORA-12541: TNS:no listener
ORA-12541 and TNS-12541 ORA-12541 is the same as TNS-12541, they all indicate that the listener is not running according to your specified destination. Let’s see… Read More »How to Resolve ORA-12541: TNS:no listener