READ WRITE

How to Resolve ORA-16000: database or pluggable database open for read-only access

by Ed Chen
December 6, 2022December 24, 2022

ORA-16000 Tried to update some rows, but it failed with ORA-16000. SQL> update employees set first_name = 'Ed' where last_name = 'Chen'; update employees set… Read More »

How to Resolve ORA-01641: tablespace is not online - cannot add data file

by Ed Chen
August 5, 2022December 15, 2022

ORA-01641 Tried to add a data file to a tablespace, but it failed with ORA-01641. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example01.dbf' size 10m autoextend… Read More »

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

by Ed Chen
February 21, 2022January 16, 2023

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, 2021January 12, 2023

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 »

Alter Pluggable Database Open Automatically

by Ed Chen
August 15, 2020July 6, 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 Srvctl Start Database

by Ed Chen
September 28, 2019October 22, 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, 2015December 11, 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 »