ORA-01507

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 Change DB_NAME of a RAC Database

by Ed Chen
January 30, 2021December 9, 2022

In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »

Srvctl Add Database Example

by Ed Chen
December 5, 2020December 15, 2022

Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »

How to Start Oracle Database

by Ed Chen
September 28, 2019January 5, 2023

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019December 10, 2022

SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »

How to Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019February 25, 2023
2 Comments

ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »

Converting Standby Database to Snapshot (2/4) - Convert Manually

by Ed Chen
March 24, 2013January 20, 2021

Converting Standby Database to Snapshot (1/4) - Convert by Broker We have demonstrated how to convert a physical standby database to a snapshot standby by… Read More »

RMAN Configuration Under Nomount

by Ed Chen
December 31, 2012March 29, 2022

Did you have ever noticed that? RMAN can show the configuration when the controlfile is not mounted. See the demonstration below: [oracle@primary01 ~]$ rman target… Read More »