STARTUP NOMOUNT

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021December 13, 2021

To check Oracle database startup time, we have to know the difference between instance startup time and database open time. Additionally, we also check the… 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 Start Oracle Database

by Ed Chen
September 28, 2019November 12, 2022

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 Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019July 3, 2022

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 »

How to Change Control File Location in Oracle

by Ed Chen
February 23, 2019October 20, 2022

ALTER SYSTEM SET CONTROL_FILES In this post, I will show you how to change control file location in a single-instance and a cluster database. Change… Read More »

How to Move Oracle Database

by Ed Chen
January 23, 2019October 3, 2021

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

Duplicate a Standby Database (2/4) - With Backup-Based Duplication

by Ed Chen
January 28, 2013January 19, 2021

Duplicate a Standby Database (1/4) - With Active Database Duplication Backup-Based duplication requires to connect to the target database, and one copy of database backups… Read More »

Duplicate a Standby Database (1/4) - With Active Database

by Ed Chen
January 27, 2013September 26, 2021

Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012October 12, 2022

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »