SHUTDOWN IMMEDIATE

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022September 25, 2022

ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should mount the database from NOMOUNT for further… Read More »

How to Resolve ORA-03135: connection lost contact

by Ed Chen
November 13, 2021June 8, 2022

ORA-03135 ORA-03135 is also a server process problem. As I said in solving ORA-03113: No matter the database is down or session is lost, for… Read More »

How to Resolve ORA-03113: end-of-file on communication channel

by Ed Chen
November 12, 2021October 23, 2022

ORA-03113 Found ORA-03113 when we try to operate with the database. Let's see the case. First of all, we performed a query, meanwhile, the database… Read More »

How to Resolve ORA-32002: cannot create SPFILE already being used by the instance

by Ed Chen
August 16, 2021October 23, 2021

ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »

How to Resolve ORA-01149: cannot shutdown - file 1 has online backup set

by Ed Chen
July 7, 2021December 12, 2022

ORA-01149 ORA-01149 means that some data files are in backup mode, so you can't shutdown the database in this moment. SQL> shutdown immediate; ORA-01149: cannot… Read More »

How to Restart Oracle Database

by Ed Chen
September 30, 2019November 21, 2022

In this post, we'll talked about how to restart a database in a efficient way, which includes: Restart a Single-Instance DB Restart a RAC DB… Read More »

How to Stop Oracle Database

by Ed Chen
September 29, 2019December 10, 2022

A. Stop Oracle Database After knowing how to start an Oracle database, we may begin to learn something about stopping an Oracle database. For stopping… Read More »

SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019December 10, 2022

SHUTDOWN IMMEDIATE Shutdown immediate may not go smoothly as you thought, it could seem to be stuck in an infinite waiting. If you wait and… Read More »

How to Resolve ORA-19573: cannot obtain exclusive enqueue for datafile 1

by Ed Chen
November 1, 2015December 23, 2022
6 Comments

ORA-19573 It's pretty easy to reproduce ORA-19573 because the solution is pretty easy, too. In this post, I will show you two run blocks on… Read More »

Possible Reasons Why Shutdown Stuck

by Ed Chen
September 12, 2014February 14, 2023

The fastest way to solve the hanging is to do a SHUTDOWN ABORT or even kill SMON process, but they do not remove the root… Read More »