SHUTDOWN IMMEDIATE

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022September 17, 2023

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, 2021May 31, 2023

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, 2019April 15, 2023

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
2 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.