ALTER DATABASE OPEN

How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode

by Ed Chen
November 14, 2022November 21, 2022

ORA-65054 Tried to open a pluggable database (PDB), but it failed with ORA-65054. Let's see how it happened. SQL> alter session set container=ORCLPDB; Session altered.… Read More »

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-00214: control file

by Ed Chen
May 10, 2022August 23, 2022

ORA-00214 Tried to startup or mount a database, we got ORA-00214. SQL> startup ORACLE instance started. ... ORA-00214: control file '/u01/app/oracle/fast_recovery_area/ORCLCDB/control02.ctl' version 2286 inconsistent with… Read More »

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021January 24, 2023

Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021December 24, 2022
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… 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 »

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

by Ed Chen
February 23, 2019December 10, 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 »