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-16000: database or pluggable database open for read-only access
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 ORA-01641: tablespace is not online - cannot add data file
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 CRS-5702: Resource is already running on 'primary01'
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 »Database States Differentiations in Oracle
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 »Alter Pluggable Database Open Automatically