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
Process Monitor (PMON)
How to Resolve ORA-01220: file based sort illegal before database is open
When I queried the archive gap on the standby database which is a 9i database, I got this error: SQL> select * from v$archive_gap; select… Read More »How to Resolve ORA-01220: file based sort illegal before database is open
How to Resolve "PMON failed to acquire latch, see PMON dump"
PMON failed to acquire latch Here was the case, the database was hanging caused by some heavy loading processes. Users complained about the high waiting… Read More »How to Resolve "PMON failed to acquire latch, see PMON dump"
Alter System Kill Session, Disconnect Session
Kill Session vs Disconnect Session Oracle SQL provides end_session_clauses syntax to terminate sessions: ALTER SYSTEM { DISCONNECT SESSION 'integer1, integer2' [ POST_TRANSACTION ] | KILL… Read More »Alter System Kill Session, Disconnect Session
How to Resolve ORA-12560 on Windows Server
ORA-12560 In this post, I'll talk about 3 error patterns of ORA-12560 on Windows platform. Database service is stop Incorrect ORACLE_SID Reach limitation of PROCESSES… Read More »How to Resolve ORA-12560 on Windows Server
How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)
ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole
How to Resolve ORA-16055: FAL request rejected
In Oracle MAA, data guard plays a very important role to secure our data on the remote location. Since it involves network and interconnection between… Read More »How to Resolve ORA-16055: FAL request rejected
How to Kill Sessions Running on Shared Server Processes
Kill Dedicated Server Sessions kill session immediate statement does not guarantee that the specified session will be killed immediate, especially when the session is active… Read More »How to Kill Sessions Running on Shared Server Processes
How to Restart Dead Dispatchers Manually
Theoretically, PMON will clean up dead process automatically, but it sometimes fails to do it in 9i databases like the error message in the alert… Read More »How to Restart Dead Dispatchers Manually
How to Set Autocommit ON and OFF
Implicit Commit In the default behavior, if session A wants to see session B's results, he must be waiting for session B to commit his… Read More »How to Set Autocommit ON and OFF