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-65054: Cannot open a pluggable database in the desired mode
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-12081: update operation not allowed on table
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
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 PRKO-2002 : Invalid command line option
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'
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 to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
You can have this one: SQL> ALTER DATABASE OPEN READ ONLY; And also this one: SQL> ALTER DATABASE OPEN RESETLOGS; But there's NO combined statement like… Read More »Can I Open Database to READ ONLY with RESETLOGS?