READ WRITE

How to Resolve CRS-5702: Resource is already running on 'primary01'

by Ed Chen
February 21, 2022January 11, 2022

CRS-5702 Tried to startup a database in a cluster, we got CRS-5702. [oracle@primary01 ~]$ srvctl start database -d orclcdb PRCC-1014 : ORCLCDB was already running… Read More »

Oracle Controlfile Types

by Ed Chen
November 20, 2021April 5, 2022

After solving ORA-01610, you might have a question: how do I know the currently used controlfile is a BACKUP one or not? We take the… Read More »

Database States Differentiations in Oracle

by Ed Chen
February 10, 2021July 1, 2022

We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »

How to Open Pluggable Database Automatically

by Ed Chen
August 15, 2020June 14, 2022

ALTER PLUGGABLE DATABASE OPEN By default, the pluggable databases (PDB) are at MOUNT state after you startup the container database (CDB). SQL> conn / as… Read More »

How to Start RAC Database

by Ed Chen
September 28, 2019May 17, 2022

To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »

How to Create PDB from Another PDB

by Ed Chen
October 20, 2015May 26, 2022

Create PDB from Another PDB Cloning a new PDB from another pdb for testing purpose in the same CDB is a very common practice during… Read More »