Read Only

How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it

by Ed Chen
February 3, 2023January 5, 2023

ORA-01647 Tried to move a table to another tablespace, but it failed with ORA-01647. SQL> alter table employees move tablespace example; alter table employees move… Read More »

How to Resolve ORA-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »

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-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-12081: update operation not allowed on table

by Ed Chen
September 23, 2022September 19, 2022

ORA-12081 An user tried to update some data in a table (DML), but it failed with ORA-12081. SQL> update employees set first_name = 'Ed' where… 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 PRKO-2002 : Invalid command line option

by Ed Chen
June 24, 2022June 27, 2022

PRKO-2002 There could be many cases that throw PRKO-2002, this is only a case when we tried to open the database to READ ONLY. [oracle@primary01… 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 »

How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup

by Ed Chen
March 18, 2020December 12, 2022
4 Comments

When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… 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 »